cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scherler, Thorsten" <Thorsten.Scher...@weidmueller.de>
Subject AW: esql / xsp <- query for date
Date Wed, 13 Nov 2002 17:09:14 GMT
Jepp!

That way I don't an error but neither any result!

-----Ursprüngliche Nachricht-----
Von: Cedric Picard [mailto:C.Picard@kainos.com]
Gesendet: Mittwoch, 13. November 2002 18:03
An: cocoon-users@xml.apache.org
Betreff: RE: esql / xsp <- query for date


Have you tried '11/11/2002' instead?

I would 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
To: Cocoon-Users (E-Mail)
Subject: esql / xsp <- query for date


Hello group,

I have a big problem!

I want to do the following:

I have a query on a database. It is working fine!

I can do the following with every field but the date:
e.g.
http//...?id=1

but as soon as I but ?date='11.11.2002'

it blows!

So trying the following blows it too:
<esql:query>
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 & Co.
> P.O. Box 2807
> 33058 Paderborn
> Tel.:+ 49 - 5252-960-350
> Fax:+ 49 - 5252-960-116
> eMail: thorsten.scherler@weidmueller.de http://www.weidmueller.de
> 
> 

---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>



--

This e-mail is confidential and is intended for the named recipient only. If
you receive it in error please destroy the message and all copies. Kainos
Software Ltd. does not accept liability for damage sustained as a result of
malicious software (e.g. viruses). Kainos does not accept liability for, or
permit, the creation of contracts on its behalf by e-mail, the publication of
any defamatory statement by its employees by e-mail, or changes subsequently
made to the original message. The Company's registered office is located at
4-6 Upper Crescent, Belfast, BT7 1NT, Northern Ireland, Tel +44 28 9057 1100.

---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message