[Zope-DB] Calling SQL Query in DTML Method with a string argument

[Matylda Sawicka]

Hello,
I am a fresh Zope Explorer. I was trying to call an SQL Query that requires
an argument in a DTML Method that would be called with an argument passed in
the URL. The Query looks more or less like this:

SELECT Uni_Name,
       Uni_Latitude,
       Uni_Longitude
FROM universities
WHERE Uni_Code = <dtml-sqlvar givenCode type="string"> AND
      Uni_Latitude != NULL

whilst the DTML Method consists of:
<markers>
<dtml-in expr="uniSingleByCode(givenCode='<dtml-var uni_id>')">
<mrk nm="<dtml-var Uni_Name>" lat="<dtml-var Uni_Latitude>" lng="<dtml-var
Uni_Longitude>"/>
</dtml-in>
</markers>


If I replace the <dtml-var uni_id> with an existing uni code, query works,
but as it is, I get an empty XML (well, just <markers></markers> appear).
I am perfectly aware of the fact that the mistake I make must be trivial,
but nevertheless I'd like to ask for some enlightment.
Best regards,
Olia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-db/attachments/20080728/fa0daa72/attachment.html