[Zope] ZSQL select on date/time

[Laurie Nason]

Usually with Access you need to have # around your dates.

hth
Laurie
btw - the space in the column name - DON'T DO IT!!! (if you can help it - it
just makes life difficult!)

-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Loren
Stafford
Sent: Friday, July 06, 2001 3:08 PM
To: zope@zope.org
Subject: [Zope] ZSQL select on date/time


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


_______________________________________________
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 )