Error in Prepared Statement in my Struts Action Class

2003-03-17 Thread Richard Raquepo
I doing an app with struts. Although my problem is not directly related to struts maybe any could help me out. I have this prepared statement SQLDef.BUSEMPINFO_INSERT= INSERT INTO busempinfo (lastupdate) VALUES (?) but when i use this on my Java servlet like this pstmt = conn.prepareStatement(

Re: Error in Prepared Statement in my Struts Action Class

2003-03-17 Thread Michał Postupalski
On 3/18/2003 2:28 AM, Richard Raquepo wrote: I doing an app with struts. Although my problem is not directly related to struts maybe any could help me out. I have this prepared statement SQLDef.BUSEMPINFO_INSERT= INSERT INTO busempinfo (lastupdate) VALUES (?) but when i use this on my Java serv

RE: Error in Prepared Statement in my Struts Action Class

2003-03-17 Thread Marc Esher
: Error in Prepared Statement in my Struts Action Class On 3/18/2003 2:28 AM, Richard Raquepo wrote: > I doing an app with struts. Although my problem is not directly related to struts maybe any could help me out. > > I have this prepared statement > SQLDef.BUSEMPINFO_INSERT= > INSERT

Re: Error in Prepared Statement in my Struts Action Class

2003-03-17 Thread Richard Raquepo
o: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, March 18, 2003 9:37 AM Subject: Re: Error in Prepared Statement in my Struts Action Class > On 3/18/2003 2:28 AM, Richard Raquepo wrote: > > I doing an app with struts. Although my problem is not directly rela

Re: Error in Prepared Statement in my Struts Action Class

2003-03-17 Thread Michał Postupalski
On 3/18/2003 2:57 AM, Richard Raquepo wrote: Datetime i used pstmt.setString(1,fdate.format(now)); because it does the data does not correctly forms the correct date pstmt.setDate(1,now); will only save the date (-MM-DD) but not the time... U should use pstmt.setTimestamp(1, well_formed_field )