Re: [sqlite] ORDER BY terms must be non-integer constants

On Tue, 11 May 2004, Mitchell Vincent wrote: >This is a re-post as I didn't get any comments on what that error >message really means.. > >My view : > >CREATE view product_detail as SELECT * FROM products as p,categories as >c WHERE c.category_id = p.category_id; > >When I do this query (which hap

[sqlite] ORDER BY terms must be non-integer constants

This is a re-post as I didn't get any comments on what that error message really means.. My view : CREATE view product_detail as SELECT * FROM products as p,categories as c WHERE c.category_id = p.category_id; When I do this query (which happens at a certain point in one of my applications) I