[Zope-dev] Re: [Zope] newbie question: parameter passing for ZSQL Object

2000-05-28 Thread Stephan Richter
With dtml-call insertItem, Zope gives me following error message: If the parameters are from another SQL statement, then the SQL method will not find them, since not the entire namespace is sent. Try: dtml-call "insertItem(param1=pvalue1, param2=pvalue2, param3=pvalue3, param4=pvalue4)"

Re: [Zope] newbie question: parameter passing for ZSQL Object

2000-05-28 Thread Stephan Richter
With dtml-call insertItem, Zope gives me following error message: If the parameters are from another SQL statement, then the SQL method will not find them, since not the entire namespace is sent. Try: dtml-call "insertItem(param1=pvalue1, param2=pvalue2, param3=pvalue3, param4=pvalue4)"

[Zope] newbie question: parameter passing for ZSQL Object

2000-05-26 Thread zope
Hi. With some values that I got from a formular, I wan't to do some calculation stuff, and insert the calculated values into a database. My Z SQL method'insertItem' looks like Arguments: param1, param2, param3, param4 INSERT INTO plan (field1, field2, field3, field4) VALUES (dtml-var param1,

[Zope] newbie question: parameter passing for ZSQL Object

2000-05-26 Thread Andy Pahne
It's pretty easy: dtml-call "sql_method(argument1=value1, argument2=value2)" There's a problem with your SQL-statement: INSERT INTO plan (field1, field2, field3, field4) VALUES (dtml-var param1, dtml-var param2, dtml-var param3, dtml-var param4) It should be: INSERT INTO plan (field1,