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 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.
>
>
>
> [EMAIL PROTECTED] wrote:
>
> 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 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
___
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 )