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 On Saturday, May 6, 2023 at 6:04:39 PM UTC-5 snide...@gmail.com wrote: 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";') 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 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/de93a343-95c5-4a35-8092-28c65f3ba86an%40googlegroups.com.