No biggy.. <dtml-in searchMySql start=query_start> <dtml-var variable_name> </dtml-in> That should get you started but you should read the ZSQL Guide as it has lots of options that you can include (size, orphan, start sequence, end sequence, etc) Really is worth the read. Enjoy, JMA
I am making slow progress, but now can't seem to display my results from a ZSQL method. How are the results returned? If they are in some RESPONSE object, how would I read the items out? So far, I have an SQL query which I'm fairly sure is working, and whcih when tested gives the results I expect, but when I use it in the following bit of DTML, nothing is rendered at all:
<dtml-call "REQUEST.set('cmatch', 'sup_name')"> <dtml-var searchMySQL>
The <dtml-var searchMySQL> line returns nothing, even though I know that there are results for that method.
Apologies if I'm missing something I should be picking up from searching the archives, but at the moment our connection is bogged down with lunch time traffic, so I can't even get to the zope site. thanks Allen