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
_______________________________________________ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db