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
