Hi, In ZSQLMethod I would have SQL query similar to this logic: IF value1=<dtml-var value1> and value2=<dtml-var value2> THEN update table set( name='<dtml-var name>' )where value1=<dtml-var value1> and value2=<dtml-var value2> ELSE insert into table values( Id, name='<dtml-var name>', value1=<dtml-var value1>, value2=<dtml-var value2> ) I can't figure out how to change this notation. Many greetings and thanks for every answer!
How do you want to change this notation? What is it you want to do? Please spend as much time writing a question as someone may in answering it! You do not want logic in your zsql methods. I tend to use python scripts for branching logic, eg # python script request = context.REQUEST if request.get('value1') == someValue: do the add zsql else: do the edit zsql. celtek@wp.pl wrote:
Hi, In ZSQLMethod I would have SQL query similar to this logic:
IF value1=<dtml-var value1> and value2=<dtml-var value2> THEN update table set( name='<dtml-var name>' )where value1=<dtml-var value1> and value2=<dtml-var value2> ELSE insert into table values( Id, name='<dtml-var name>', value1=<dtml-var value1>, value2=<dtml-var value2> ) I can't figure out how to change this notation.
Many greetings and thanks for every answer!
Plus, celtek, when you use DTML in ZSQL methods use this: <dtml-sqlvar value1 type="string"> to automatically quote strings. Otherwise you'd have to do this: '<dtml-var "value.replace('\'','\'\'\'')">' which might not work anyway. 2005/9/25, David H <bluepaul@earthlink.net>:
How do you want to change this notation? What is it you want to do? Please spend as much time writing a question as someone may in answering it!
You do not want logic in your zsql methods. I tend to use python scripts for branching logic, eg
# python script request = context.REQUEST if request.get('value1') == someValue: do the add zsql else: do the edit zsql.
celtek@wp.pl wrote:
Hi, In ZSQLMethod I would have SQL query similar to this logic:
IF value1=<dtml-var value1> and value2=<dtml-var value2> THEN update table set( name='<dtml-var name>' )where value1=<dtml-var value1> and value2=<dtml-var value2> ELSE insert into table values( Id,
name='<dtml-var name>', value1=<dtml-var value1>, value2=<dtml-var value2> ) I can't figure out how to change this notation.
Many greetings and thanks for every answer!
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
-- Peter Bengtsson, work www.fry-it.com home www.peterbe.com hobby www.issuetrackerproduct.com
participants (3)
-
celtek＠wp.pl -
David H -
Peter Bengtsson