Re: Re: Reading from databse and writing to file.

This is the error I get.
DBD::ODBC::st execute failed: Microsoft ODBC SQL Server DriverCOUNT field incorrect or syntax error (SQL-07001)(DBD: st_execute/SQLExecute err=-1) at Bookkeeping.pl line 51.
How can I fix it.

Comment on Re: Re: Reading from databse and writing to file.

Replies are listed 'Best First'.
Re: Re: Re: Reading from databse and writing to file. by runrig (Abbot) on May 15, 2003 at 18:09 UTC
This is the error I get. DBD::ODBC::st execute failed: ... How can I fix it. You print the sql statement, and see what's wrong with it. If it doesn't work when you cut and paste it into a SQL query window (or whatever query utility you have), then its not going to work in perl. Maybe you need to quote some/all of your arguments, maybe you should use placeholders (see the DBI docs).	[reply]