Hi,
I am having a problem with DBD::ODBC (version 0.31) that has fixes to
handle multiple result set. This fix is working fine only when the number of
columns of the previous result set is equal to or greater than the number of
columns of the following result set. If the number of columns of the result
set of the previous result set is greater than the following, SQLFetch
function call is failing and returning -1.
Error message is:
DBD::ODBC::st fetchrow_arrayref failed: [OpenLink][ODBC][Driver]Invalid
column number (SQL-S1002)(DBD: st_fetch/SQLFetch err=-1)
Can somebody please suggest a solution for this problem ?
Your help will be greatly appreciated.
Sample sql statements used:
a. "select emp_name, address1, address2 from employee where emp_id = 2 "
select emp_id from employee where emp_id = 2" -- Failing
with message ( SQLFetch = -1 )
b. " select emp_id from employee where emp_id = 2
select emp_name, address1, address2 from employee where emp_id =
2" -- Executes succefully
_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
