<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-2" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
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!<br>
<br>
You do not want logic in your zsql methods.<br>
I tend to use python scripts for branching logic, eg<br>
<br>
# python script<br>
request = context.REQUEST<br>
if request.get('value1') == someValue:<br>
do the add zsql<br>
else:<br>
do the edit zsql.<br>
<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:celtek@wp.pl">celtek@wp.pl</a> wrote:
<blockquote cite="mid005201c5c17f$ab00f060$16361f53@useridgukb7c11"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.2800.1106" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">Hi, </font></div>
<div><font face="Arial" size="2">In ZSQLMethod I would have SQL
query similar to this logic:</font></div>
<div> </div>
<div><font face="Arial" size="2">IF</font></div>
<div><font face="Arial" size="2">value1=<dtml-var value1> and
value2=<dtml-var value2></font></div>
<div><font face="Arial" size="2">THEN</font></div>
<div><font face="Arial" size="2">update table set</font><font
face="Arial" size="2">(</font></div>
<div><font face="Arial" size="2">name='<dtml-var name>'</font></div>
<div><font face="Arial" size="2">)where <font face="Arial" size="2">value1=<dtml-var value1>
and value2=<dtml-var value2></font></font></div>
<div><font face="Arial" size="2">ELSE</font></div>
<div><font face="Arial" size="2">insert into table values(</font></div>
<div><font face="Arial" size="2">Id,</font></div>
<div>
<div><font face="Arial" size="2">name='<dtml-var name>',</font></div>
</div>
<div><font face="Arial" size="2">value1=<dtml-var value1>, </font></div>
<div><font face="Arial" size="2">value2=<dtml-var value2></font></div>
<div><font face="Arial" size="2">)</font></div>
<div><font face="Arial" size="2">I can't figure out how to change
this notation.</font></div>
<div> </div>
<div><font face="Arial" size="2">Many greetings and thanks for every
answer! <br>
</font></div>
<br>
<br>
</blockquote>
<br>
</body>
</html>