[Zope] INSERT/UPDATE in SQL methods

Evan Simpson evan@4-am.com
Tue, 17 Aug 1999 12:32:48 -0500


Martijn Pieters wrote:

[Corrections to my sea of mis-coding]

Urgh.  That should teach me to send off untested, off-the-top-of-my-head
code.

> Better would be using sqltest in stead of name = <!--#sqlvar-->:
>
>    UPDATE addressbook SET email = <!--#sqlvar email type=string-->
>      WHERE <!--#sqltest name=name type=string-->

Sure enough.  The 'sql.*' tags should be used wherever possible, for the
reason you mention, among others.

And thanks for the kind word, Brad.  I hope this means you've reconsidered
withdrawing from the Zope community.

back-to-my-PythonMethods-ly-y'rs
Evan Simpson