[Zope] SQL query in ZSQLMethod

2005-09-24 Thread celtek
Hi, In ZSQLMethod I would have SQL query similar to this logic:   IF value1= and value2= THEN update table set( name='' )where value1= and value2= ELSE insert into table values( Id, name='', value1=,  value2= ) I can't figure out how to change this notation.   Many greetings and thanks for 

Re: [Zope] SQL query in ZSQLMethod

2005-09-24 Thread David H
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 reque

Re: [Zope] SQL query in ZSQLMethod

2005-09-25 Thread Peter Bengtsson
Plus, celtek, when you use DTML in ZSQL methods use this: to automatically quote strings. Otherwise you'd have to do this: '' which might not work anyway. 2005/9/25, David H <[EMAIL PROTECTED]>: > How do you want to change this notation? What is it you want to do? Please > spend as much time wr