Well I knew that it was something like that! Laurie -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Casey Duncan Sent: Friday, July 06, 2001 3:18 PM To: Loren Stafford Cc: zope@zope.org Subject: Re: [Zope] ZSQL select on date/time 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 `------------------> _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )