1. Check that your parameters ara on scope 2. try the following: <dtml-call "InsertItem(param1=param1,param2=param2,param3=param3,param4=param4)"> ...And in the ZSQL method define your dtml-vars as <dtml-sqlvar param1 type=int> (etc) zope wrote:
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>, <dtml-var param2>, <dtml-var param3>, <dtml-var param4>)
(parameters should be integer values)
Can anybody tell me how I can call this method and pass parameters from my DTML method?
With <dtml-call insertItem>, Zope gives me following error message:
Zope has encountered an error while publishing this resource. Error Type: Bad Request Error Value: ['param1', 'param2', 'param3', 'param4']
I was checking then "ZSQL Methods User's Guide" but, they don't give an example :-(
Please help. Any idea?
Thanks, Marc.
_______________________________________________ Zope-Dev maillist - Zope-Dev@zope.org http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )