Cheers problem fixed Many Thanks Clinton ----- Original Message ----- From: "Martin J. Evans" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 26, 2003 6:30 PM Subject: RE: [dbi] Time Field & M$ Access
> I could be wrong but I think it is the ':' in the time that is causing the > problem. The DBD thinks the ':' is a parameter. > > Insert the dates/times with placeholders instead and I think you'll find it > works. e.g. INSERT INTO tblCar (date_now,time_now) VALUES(?,?) > > Martin > -- > Martin J. Evans > Easysoft Ltd, UK > Development > > > On 26-Jun-2003 Clinton wrote: > > Hi List > > I'm tring to insert a timestamp > > Using DBI 1.14, ActiveState 5.6, Access 2000 > > SQL =INSERT INTO tblCar (date_now,time_now) VALUES (#06/23/2003#,#16:13#) > > Results in > > DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver]COUNT > > field incorrect (SQL-07001)(DBD: st_execute/SQLExecute err=-1) at > > C:\project\parse\callback2.pl line 100. > > [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect > > (SQL-07001)(DBD: st_execute/SQLExecute err=-1) at > > C:\project\parse\callback2.pl line 100. > > > > However it works when running directly in Access. (If I remove the time_now > > it works thru the DBI) > > Can't figure out the error code. Help appreciated. > > Regards > > Clinton
