Hi.
Sometimes I have to execute this line prior to making a query:
oradb.executesql("ALTER SESSION set NLS_DATE_FORMAT = 'YYYY-MM-DD
HH24:MI:SS';")
That is because Oracle by default uses different date format that causes my
queries to fail.
The problem is that doing that in model is incorrect - this should be
executed just once for each db connection.
Doing that just prior to query is inconvenient and still incorrect - I am
probably reusing same connection.
Can I somehow tell web2py to execute this sql right after calling connect()?
Regards
Alexey
--
Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en
