Can you please turn on tracing and send me the trace file for the statement(s) that fail?
Thanks, Jeff > -----Original Message----- > From: Abi Pothen [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 28, 2002 8:02 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Multiple Results in DBD::ODBC 0.31 > > > 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 > >
