You want to use container.send_to_database(CName=x, email=y, phone=z) or alternatively make sure that CName, email and phone are in the REQUEST. You also really should use <dtml-sqlvar> rather than <dtml-var> in your method, that all of the quoting that SQL needs gets done. A On 14/1/03 6:43 pm, "Sage Mo" <sagefmo@nc.rr.com> wrote:
This is probably a very basic question, but it's been stopping me for hours (very frustrating).
I have a Python script that's trying to pass variables into a Z SQL method. In the Python script I wrote:
container.send_to_database(CName, email, phone)
where send_to_database is the Z SQL Method.
send_to_database looks like this:
Z SQL Method at / <http://www.heiropure.com/manage_workspace> send_to_database Help! <http://www.heiropure.com/HelpSys?help_url=/Control_Panel/Products/ZSQLMethod... /Help/Z-SQL-Method_Edit.stx> Title
Connection Id MySQL_database_connection Arguments CName email phone insert into name_table (CName, email, phone) values ("<dtml-var CName>", "<dtml-var email>", "<dtml-var phone>");
Yet when I run the Python script, I get
Zope Error Zope has encountered an error while publishing this resource. Error Type: KeyError Error Value: CName Am I passing the variables in the wrong way from the Python Script? Is there something wrong with the Z SQL method? In the Python script the variables CName, email, phone are well defined. Someone, anyone HELP! so I can actually do something besides look hopelessly at this error message for days on end.