andy wrote: [...]
The WHERE line of the current Access query reads:
WHERE ((([Daily Orders].Date) Between [Enter the beginning date] And [Enter the end date]))
[...]
<form method=POST action="query"> Enter the start date: <input type=text name=startdate size=10 maxlength=10> <p> Enter the end date: <input type=text name=enddate size=10 maxlength=10> <p> <i>Ensure dates are entered in mm/dd/yyyy format</i> <p> <input type=submit> </form>
... and I want to pass those values into the ZSQL Method, and this is
[...] quick and simple answer - not tested, see ISSUES: a) in zsql replace [Enter the beginning date] and [Enter the end date] by <dtml-var STARTDATE> and <dtm-var ENDDATE> b) in zsql Parameters write simply STARTDATE ENDDATE c) test the zsql! d) call the zsql method QUERY from a Page Template like this: tal:define="recordset python:container.QUERY(STARTDATE=request.form.startdate, ENDDATE=request.form.enddate)" to get the set of records and use it afterwards, or tal:repeat="record python:..." to imediately loop over the records (foreach) and repeat html stuff like <TR>. ISSUES: 1) I used capital letters but it's not necessary. I used them just to visually differentiate from the form parameters. 2) You might have to do #<dtml-var ...># 3) Look for <dtml-sqlvar> in the documentation (e.g. zope book). It includes a parameter 'type' that's supposed to take care of type representation issues (point 2) according to the database. 4) Obviously you can call the zsql method from a Python script (like in d) and from DTML but for this one I don't know. HTH, Fernando