Re^4: DBI Invalid Cursor State when PRINT statements are embedded in SQL


No such thing as a small change
	PerlMonks

Re^4: DBI Invalid Cursor State when PRINT statements are embedded in SQL

by JamesNC (Chaplain)

on Oct 18, 2004 at 19:55 UTC ( [id://400300]=note: print w/replies, xml )

Need Help??

in reply to Re^3: DBI Invalid Cursor State when PRINT statements are embedded in SQL
in thread DBI Invalid Cursor State when PRINT statements are embedded in SQL

This was helpful... but any idea how can I capture both the SQL_SUCCESS_WITH_INFO __AND__ the results of the select? I see $dbh->errstr has Microsoft ODBC SQL Server Driver SQL Server...begin(SQL-01000) when the PRINT statement is run all alone, but get the cursor error when it is run with the select... arrgh...