yes it makes sense but self._execute = lambda a: self._cursor.execute(a[:-1])
seems strangely not to affect the SQL error 104 problem which is often connected with a wrong character in the statement. carlo p.s. tomorrow more test about it On 26 Feb, 23:37, mdipierro <mdipie...@cs.depaul.edu> wrote: > the convention in sql.py is that all statements and with semicolon. > For some databases the semilcolon it removed upon execution. > Using this > > self._execute = lambda a: self._cursor.execute(a[:-1]) > > does not change this > > print db()._select(db.mytable.ALL) > > but changes this > > db().select(db.mytable.ALL) > > since select _executes _select. Hope it makes sense. > > Massimo > > On Feb 26, 4:08 pm, carlo <syseng...@gmail.com> wrote: > > > About the semicolon Massimo suggested in line 789: > > > self._execute = lambda a: self._cursor.execute(a[:-1]) > > > but in my test > > > print db()._select(db.mytable.ALL) > > > but I always get the same semicolon at the end of the SELECT > > statement , trying to understand why, I will make other tests > > tomorrow. > > > Your other syntax remarks are correct as far as I know but Massimo did > > not correct sql.py yet. > > > carlo > > > On 26 Feb, 22:28, DenesL <denes1...@yahoo.ca> wrote: > > > > Massimo, did you see my previous post?. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---