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

Grakka jflores@codeit.com
Fri, 26 May 2000 09:17:21 -0700


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 )