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!