Hi

I can't execute a basic count aggregate query as shown on the susonic website like so

SubSonic.Where w = new SubSonic.Where();

w.ColumnName = "categoryID";

w.ParameterValue = "1";

Query.GetCount("products", "productID", w);

My query object doesnt have a getCount method. My query class has 4 methods only. I've just downloaded the latest subsonic code and updated the subsonic reference in my visual studio project but this method still does not exist

thanks a lot

andrea

Try using (You have to use the Instance methods not the static ones)

SubSonic.Query q = new SubSonic.Query();
q.GetCount("products", "productID", w);

Hi I should have pointed out that I aready tried that but i get an error when i try and create a new query object

 'Overload resolution failed because no accessible New accepts this number of arguments'

I don't know enough about subsonic and te arguments in the query constructor to proceed

thanks

http://subsonicproject.com/querying/using-the-original-query-tool/