Hello all;

I'm using webpy with postgre as the backend db and i'm having problems when the condition uses the datetime field.

I have a sentence like this in the code:

if 'expira' in i:
    where += " AND expira ILIKE $expira"
    vars.update({'expira': i.expira})

I'm using expira as a string because i want to use %-10-2009, as example.

But it seems to fail when i'm trying to get a query for "%2009"; instead of getting it, i get a void result. But it works if i use "2009%'; which is pointing me to think it is a locale problem.

How can i solve it?

In the all-statements postgresql log i see the query run ok.

Thank you!

--
Ferran at fompi.net
another sexy techie

--
You received this message because you are subscribed to the Google Groups 
"web.py" 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/webpy?hl=en.

Reply via email to