[Zope] Providing Arguments to ZSQL Methods that Insert and Update in Python

Muk Yan myan at umich.edu
Sun Aug 6 15:13:33 EDT 2006


Thanks Andreas, sorry about the confusion.

What I want to do is call the ZSQL Method from a Python script instead of
from a DTML Document or Method.  I want to know if there's a way to provide
arguments from the Python Script to ZSQL Methods with Updates and Inserts.

This is just a toy problem:

Arguments: emp_id
                  first
                  last
                  salary

UPDATE person
SET person_first_name = first,
person_last_name = last,
person_salary = salary
WHERE person_emp_id = emp_id

(context.aq_parent).updates.update_person(empid=someval1, first=someval2,
last=someval3, salary=someval4)

I want to avoid using <dtml-sqlvar emp_id type=string>.

Thanks again.

Peace and take care,
Muk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope/attachments/20060806/95f7d480/attachment.htm


More information about the Zope mailing list