cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scherler, Thorsten" <Thorsten.Scher...@weidmueller.de>
Subject [summary] RE: esql Update Date
Date Thu, 17 Apr 2003 12:20:02 GMT
Hello I found the solution:
<esql:query>update bck_serienbriefe set bck_serienbriefe.date=#05/14/2003#; </esql:query>

with other words for MS ACCESS DB you need to add "bck_serienbriefe." and then date.

Don't ask me why (it is like that, ...and why I still use ACCESS ;-)

King regards

> -----Original Message-----
> From: Scherler, Thorsten 
> Sent: Thursday, April 17, 2003 1:59 PM
> To: Cocoon-Users (E-Mail)
> Subject: esql Update Date
> 
> 
> Hello group,
> 
> <esql:query>update bck_serienbriefe set date=?; </esql:query>
> 
> I want to update a date within an Access DB!
> 
> I know I had a similar problem before with a select statement 
> I solved like that:
> date = #04/17/2003#.
> 
> That way I was able to get the data out of the DB. But trying 
> the same format with the update statement will result in an 
> error. I can update any other field (string/int) of the table 
> except the date.
> 
> What can I do?
> 
> > 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
> > 
> > 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
> 
> 

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