sybperl-l Archive

From: Jerry Grooms <grooms at uky dot edu>
Subject: Re: DBD::Sybase 1.01 & queries against temp table
Date: Dec 3 2003 6:55PM

Michael Peppler  writes:

     > Hmmm - this bit is strange. Why do we think that there is a
     > result set with a single column. The first query in your set
     > is a select into, so does not produce any results, and the
     > second has two columns, no?

Correct.

     > Have you tried coding the fetch loop so that you get all of
     > the result sets?

     > do { while(@data = $sth->fetchrow_array()) { ....  } }
     > while($sth->{syb_more_results});

Bingo!

With that advice, I can get back to where I was pre-upgrade by:

o) throwing away first (empty) set  (?)
o) using fetch loop as you indicated

Works for me, but I assume a lingering question is why?

I noticed that a second consecutive query (in this same session)
works with the "old" fetch loop coding...

Thanks!

Jerry