No, I'm all for it. Actually it sounds more like bugfix since atm web2py can't make datetime queries on Oracle.
On Mon, Apr 19, 2010 at 6:16 PM, mdipierro <[email protected]> wrote: > There is no hook for this, but should this not be always the default? > If so I am happy to add it to trunk. Any counterindication? > > On Apr 19, 12:32 am, Alexey Nezhdanov <[email protected]> wrote: > > 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 >
