[development] hostmonster
Jim Taylor
jim at rootyhollow.com
Fri Nov 6 16:57:12 UTC 2009
good point, my bad.
On Fri, Nov 6, 2009 at 11:52 AM, Jeff Greenberg <jeff at ayendesigns.com>wrote:
> Jim Taylor wrote:
>
>> Jeff,
>>
>> I think you're barking up the wrong tree on this one, uc_views is simply
>> ading additional views based on the views module. It not doing anything
>> that vanila views does not in other word it does not use SQL Views.
>>
>> Jim
>>
>> Well, perhaps, but since this is in the module install:
> db_query("CREATE VIEW {uc_order_products_qty_vw}
> (nid,order_count,avg_qty,sum_qty,max_qty,min_qty) AS SELECT `op`.`nid` AS
> `nid`, COUNT(`op`.`nid`) AS `order_count`,AVG(`op`.`qty`) AS `avg_qty`,
> SUM(`op`.`qty`) AS `sum_qty`,MAX(`op`.`qty`) AS `max_qty`, MIN(`op`.`qty`)
> AS `min_qty` FROM {uc_order_products} `op` GROUP BY `op`.`nid` ORDER BY
> `op`.`nid`");
>
> along with two others, and since that Popular Products view uses them, and
> since the module description in projects says that Mysql Views create
> permissions are needed...I think I'm barking in the right direction.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20091106/26d9ace2/attachment-0001.html
More information about the development
mailing list