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

6 Aug 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

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

Muk Yan