[ZPT] Re: Passing ZSQL Method an argument/variable with ZPT

Daniel Tang daniel.tang@chronicle.com
Thu, 20 Feb 2003 17:56:23 -0500 (EST)


I've gotten it to work after looking at all the variable settings.  I had
a form parameter keep giving me an error.  My fault for not double
checking the symptoms more carefully.

Thanks, and I appreciate the help, the Zope community rocks.


On Thu, 20 Feb 2003, [ISO-8859-15] Geir B=E6kholt wrote:

> DT> Hello,
> DT> After using all these below... it seems that the variable being passe=
d is
> DT> still not going through.
> DT> <select name=3D"result" size=3D"10" tal:define=3D"jobclasses
> DT> python:here.get_id(my_id=3Drequest.form['id'])">
> DT> The ZSQL method is: get_id
> DT> SELECT job_id FROM inventory WHERE (my_id =3D <dtml-sqlvar my_id
> DT> type=3D"string">
> Does the ZSQL method have the parameter my_id defined ?
> DT> Is this because of the variable being a particular typecast, like int=
> DT> vs. string?  (I am using zope 2.5.0 on a red hat linux box).
> in your database, "my_id" has to be a string column to match.
> Do you get an error message when it fails ?
> --
> Geir B=E6kholt
> _______________________________________________
> ZPT mailing list
> ZPT@zope.org
> http://mail.zope.org/mailman/listinfo/zpt