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 <mdipie...@cs.depaul.edu> 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 <snak...@gmail.com> 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
>
