Re: [Zope] ZSQL select on date/time

6 Jul 2001

      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
`------------------>