[Zope] ZSQL select on date/time

[Loren Stafford]

Does anyone have a working example of how to select on a date/time column in
an MSAccess database.

Something like

Arguments: FromDate:date

select * from "Applicant Database"
 where [Date Received] > <dtml-sqlvar FromDate type=float>

...except the above syntax produces:

Error type: sql.error
Error value: ('07001', -3010, '[Microsoft][ODBC Microsoft Access Driver] Too
few parameters. Expected 1.')

...regardless of value of type.

-- Thanks
-- Loren