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 )