Dear Zenith of Zope Knowledge,<br><br>Thanks for all the help from before it is truly appreciated.<br><br>I know that it's possible to provide arguments when selecing in a ZSQL Method, but is it possible to provide arguments to UPDATE and INSERT.
<br><br>I'll use an example that I found from a previous entry in the Zope mailing list.<br><br>The ZSQL method looks like this:<br><br>Arguments: emp_id<br> first<br> last<br> salary
<br><br>UPDATE person<br>SET person_first_name = first,<br>person_last_name = last,<br>person_salary = salary<br>WHERE person_emp_id = emp_id<br><br>and the call in the Script(Python) would be:<br><br>(context.aq_parent).updates.update_person(empid=someval1, first=someval2,
<br>last=someval3, salary=someval4)<br><br>I'm having trouble correlating the Python variables with the ones in the ZSQL method. I know how to pass variables from forms in DTML documents via <dtml-sqlvar emp_id type=string>. Any help would be appreciated. Thanks in advance and have a great weekend!
<br><br>Take care,<br>Muk Yan<br>