This: query = (-1)
is not a valid query. The fact it works with sqlite is a miracle. On Dec 30, 11:43 am, vvk <[email protected]> wrote: > query = (-1) > query = (db.somedb.id > 0) & query > > This querying worked with SQLITE. But it's giving following error with > postgres: > > ProgrammingError: argument of AND must be type boolean, not type > integer > LINE 1: ...rchase WHERE (purchase.timeofpurchase<='2009-12-29' AND > -1); > > i) I think there is problem with type conversions, is there a way > out ? > > ii) Is there a way to initialize a NULL query (like query = (-1) I did > earlier ?) -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
