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

[Mitchell Vincent]

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 get an error "ORDER BY terms must be non-integer 
constants"..

Offending Query :

SELECT * FROM product_detail WHERE lower("p.product_name")  LIKE 
lower('%')  ORDER BY "p.product_name" ASC

It works fine and doesn't complain in 2.8.11 but in 2.8.13 it gives that 
error..

Thanks!

-- Mitchell Vincent



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]