Thanks, That put me on the right track. I also found a how-to on the subject http://www.zope.org/Members/teyc/howSQLDateTime, which suggests: select * from activity where activity_date= { ts '<dtml-var Mydate fmt=ISO>'} My final ZSQL method is: select * from "Applicant Database" where [Last Name] like <dtml-sqlvar LastName type=string> and [First Name] like <dtml-sqlvar FirstName type=string> and Position like <dtml-sqlvar Position type=string> and [Date Received] between { ts '<dtml-var FromDate fmt=ISO sql_quote>'} and { ts '<dtml-var ThruDate fmt=ISO sql_quote>'} -- Loren
Loren Stafford wrote:
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
I think MSAccess expects it's dates to be delimited by # as in: #7/6/2001#
You might try:
select * from "Applicant Database" where [Date Received] > #<dtml-var FromDate fmt="%x" sql_quote>#
-- | Casey Duncan | Kaivo, Inc. | cduncan@kaivo.com `------------------>