[Zope] Z SQL Method - DTML Method

Jens Vagelpohl tommymi@concentric.net
Thu, 30 Dec 1999 10:32:12 -0500


hi cesare,

try passing the variable along with its name like:

<dtml-in "SQLSottoRubriche(Rubrica='71')">

jens




> -----Original Message-----
> From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
> cesare@planningsrl.it
> Sent: Thursday, December 30, 1999 09:25
> To: zope@zope.org
> Subject: [Zope] Z SQL Method - DTML Method
>
>
> I am a beginner and I am developing a trial application with zope, but I
> have a problem.
>
> In a DTML Method (say "MyMethod") I have the following code:
> ......
> <select name="SottoRubrica">
> <dtml-in "SQLSottoRubriche('71')" >
> <option>   <dtml-var descrizione>
> </dtml-in>
> .....
>
> in the Z SQL Method "SQLSottoRubriche" (with Argument "Rubrica") I have
> the following code:
>
> select *
> from SottoRubriche
> where codrubrica=
> <!--#sqlvar Rubrica type=string-->
>
>
> The test on the ZSQL Method run proprely.
>
>
> But as soon as I try to access to MyMethod via browser I have the
> following error:
>
>
>
>
> Zope Error
> Zope has encountered an error while publishing this resource.
> Error Type: Bad Request
> Error Value: ['Rubrica']
>
>
> If I delete the part of code in the MyMethod, the page work fine even via
> browser.
>
> I know I miss something, but I don't understand what. Can you help me?
>
>
> TIA,
> Cesare
>