[Zope] passing value to sql method question

[Chris Beaven]

Hi Sean

You are correct that you are inside the speech marks (""), you have to talk
python rather than DTML. What you really want is:
<dtml-in expr="get_record(PermitNumber=PermitNumber)">

Or if this is a ZSQL then it's even simpler:
Just call it like:
<dtml-in get_record>


-----Original Message-----
From: Kelley, Sean [mailto:SKelley@ci.santa-rosa.ca.us]
Sent: Tuesday, 25 June 2002 11:33 a.m.
To: 'zope@zope.org'
Subject: [Zope] passing value to sql method question


Hi,
Learning dtml and zope...

I am trying to call an sql method called get_record and pass a parameter to
it.  This works if I hardcode the value into the dtml method like this:
<dtml-in expr="get_record(PermitNumber=12345)"> 

However,
The above line is in a dtml method called edit_dtml
So I want to call edit_dtml from an html document like this:
<a href="edit_dtml?PermitNumber=<dtml-var PermitNumber>"> <dtml-var Company
null=""></a>

The value of PermitNumber gets passed okay and can be displayed in the
called page (edit_dtml) with:
<dtml-var PermitNumber>

But I need to plug it into the dtml-in expresssion something like this:
<dtml-in expr="get_record(PermitNumber=<dtml-var PermitNumber>)">

But this generates a syntax error.  There must be a correct way to do this.
Any ideas on how else I might do it?
I assume that the part after expr=" must be python code and this is why this
does not work ??


Sean Kelley
Technology Coordinator
City of Santa Rosa



_______________________________________________
Zope maillist  -  Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )