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