Sql select count(*)

[RayYates]

How would I structure an <MvOPENVIEW> QUERY expression to find out how many products were assigned to a category?

[BillBuilt]

Ray,
I dont know the specifics for Merchant, but it should be something like:

SELECT count(*) AS `tlRecs` FROM `[tablename]` WHERE `[catfield]` = '[catValue]';

then access the number via viewname.d.tlRecs

Of course this has to be looped through each different category. Check the MySQL manual, there's a GROUP BY... WITH ROLLUP feature that might work better if you want to use only 1 MvOPENVIEW.

Bill

[RayYates]

Thanks that got me going on the right path.