rolics = db(db.rolic.id>0).select(db.rolic.id.with_alias('myid'))
Traceback (most recent call last):
File "/home/www-data/web2py/gluon/contrib/shell.py", line 225, in
run
exec compiled in statement_module.__dict__
File "<string>", line 1, in <module>
File "/home/www-data/web2py/gluon/dal.py", line 4507, in select
return self.db._adapter.select(self.query,fields,attributes)
File "/home/www-data/web2py/gluon/dal.py", line 1003, in select
rows = response(sql)
File "/home/www-data/web2py/gluon/dal.py", line 994, in response
self.execute(sql)
File "/home/www-data/web2py/gluon/dal.py", line 1067, in execute
return self.log_execute(*a, **b)
File "/home/www-data/web2py/gluon/dal.py", line 1064, in log_execute
return self.cursor.execute(*a,**b)
ProgrammingError: syntax error at or near "AS"
LINE 1: SELECT (rolic.id AS myid) FROM rolic WHERE (rolic.id > 0);
^
What's wrong? Help, please.
