Exceptional oddity in query processing

[Dave S]

Why does this

• File C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py in _select_aux at line 865 code arguments variables

  Function argument list

  (self=<pydal.adapters.sqlite.SQLite object>, sql='SELECT "badlist"."id", "badlist"."burl", "badlis...LL)> ORDER BY "badlist"."tags", "badlist"."burl";', fields=[<pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>], attributes={'orderby': <pydal.objects.Expression object>}, colnames=['badlist.id', 'badlist.burl', 'badlist.tags', 'badlist.PostDate'])

• turn into this?

The relevant controller code is 

r = db(db.badlist.PostDate != None)

rows=db(r).select(orderby=db.badlist.tags|db.badlist.burl)

The exception is

File "C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py", line 468, in execute
rv = self.cursor.execute(command, *args[1:], **kwargs)
sqlite3.OperationalError: near "<": syntax error

[Dave S]

Added missing frame info

On Saturday, May 6, 2023 at 3:51:43 PM UTC-7 Dave S wrote:

Why does this

• File C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py in _select_aux at line 865 code arguments variables

  Function argument list

  (self=<pydal.adapters.sqlite.SQLite object>, sql='SELECT "badlist"."id", "badlist"."burl", "badlis...LL)> ORDER BY "badlist"."tags", "badlist"."burl";', fields=[<pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>], attributes={'orderby': <pydal.objects.Expression object>}, colnames=['badlist.id', 'badlist.burl', 'badlist.tags', 'badlist.PostDate'])

• turn into this?

• File C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py in _select_aux_execute at line 859 code arguments variables

  Function argument list

  (self=<pydal.adapters.sqlite.SQLite object>, sql='SELECT "badlist"."id", "badlist"."burl", "badlis...LL)> ORDER BY "badlist"."tags", "badlist"."burl";')

[Jim S]

I think you want

r = (db.badlist.PostDate != None) without the db in front of it.

-Jim

[Dave S]

On Monday, May 8, 2023 at 4:33:42 AM UTC-7 Jim S wrote:

I think you want

r = (db.badlist.PostDate != None) without the db in front of it.

-Jim

Thank you, sir!  That seems to have been the key.

Dave S

/dps