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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
