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

[Daniel Tang]

Hello,

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.

--Daniel




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=
eger
> 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
>