[Zope] SQL query in ZSQLMethod

[celtek at wp.pl]

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!  
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope/attachments/20050925/2a557ade/attachment.htm