esql / xsp - query for date

select * from IDM_info where Info_datum = '11.11.02' /esql:query My db is access 97 but that should be ok because I use the odbc:jdbc - bridge. So how can I get all data where the date is e.g. 13.11.2002? Mit freundlichem Gruss, Thorsten Scherler Marketing / Telefonmarketing Weidmüller GmbH

AW: esql / xsp - query for date

expect esql to use a Java Date class to wrap the date string into a Date object, which is then converted to the format used in the database by the JDBC driver. Cedric -Original Message- From: Scherler, Thorsten [mailto:Thorsten.Scherler;weidmueller.de] Sent: 13 November 2002 17:00

AW: esql / xsp - query for date

select * from IDM_info where Info_datum = #11/13/2002# is working (F**cking MS)! Took my hours :-( -Ursprüngliche Nachricht- Von: Scherler, Thorsten Gesendet: Mittwoch, 13. November 2002 18:09 An: [EMAIL PROTECTED] Betreff: AW: esql / xsp - query for date Jepp! That way I don't

AW: esql / xsp - query for date

have to use ## to narrow the date, right! because: esql:query select * from IDM_info where Info_datum = #xsp-request:get-parameter name=date/# /esql:query is working fine! Thanks a lot for the hint! Good luck, Cedric -Original Message- From: Scherler

AW: AW: esql / xsp - query for date

to secure it: esql:query select * from IDM_info where Info_datum = #esql:parameterxsp-request:get-parameter name=date//esql:parameter# /esql:query -- Ilya Scherler, Thorsten wrote: Hello Cedric, By this, I mean that if Info_datum is '11/11/2002 17:12:05.000', it will not equal

<    1   2