On 12/29/05, Jeff Watkins <[EMAIL PROTECTED]> wrote: > The problem is, I don't know how to specify a query like this in > SQLObject. Ideally, I'd prefer the count to simply appear as a property > of the product and order by the number of views, but I suspect that's > asking too much of SQLObject.
Count is a method on SelectResults and doesn't appear elsewhere in SQLObject, as far as I know.That means you'll likely need to drop down to SQL to do this particular query. (You may be able to work in a database-independent matter if you follow Ben Bangert's tips.) Kevin -- Kevin Dangoor Author of the Zesty News RSS newsreader email: [EMAIL PROTECTED] company: http://www.BlazingThings.com blog: http://www.BlueSkyOnMars.com
