[Zope] ZSQL select on date/time

Laurie Nason laurien@tiger.3dem.bioch.bcm.tmc.edu
Fri, 6 Jul 2001 15:23:51 -0500


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 )