I think I fixed it. All but oracle expect SQL to be ; terminated.
web2py adds the ; and removes it for Oracle. Because of a type it was
not adding it so it was removing the last char thinking it was a ;.
On Aug 25, 6:40 pm, Tim Korb <jtk...@gmail.com> wrote:
> I did this, but am not sure what I'm looking for. This appears...
>
> function:
> select
>
> and
>
> last_query:
> db.auth_user.id>0
>
> for example, and lots of other settings, etc. But I don't see anything that
> looks like an actual SQL query.
>
> So, working with one of my colleagues, we added tracing to dal.py and got
> this SQL out...
>
> ('SELECT count(*) FROM auth_user WHERE (auth_user.id > 0', [])
>
> We dug further into expand, thinking that was where the parenthesis was
> being omitted, but got lost in the layers.
>
> Hope this helps!
