|
|
Choosing A Webhost: |
Results returned differently - change in driver?: msg#00226db.tds.freetds
Hi, I have been using FreeTDS 0.51 with a bunch of Perl scripts to query a number of MS SQL Server databases. Some time ago, I discovered that certain queries did not return the correct results, and upgraded to version 0.61 of the driver. This fixed that problem, but has introduced another. Previously, I could do something like this: while (($one, $two, $three, $four, $five, $six, $seven) = $sth->fetchrow_array()) { print "$one \t$two \t$three \t$four \t$five \t$six \t$seven\n"; } and, if the query did not return any results, the while loop would not be entered. This is as I would expect. With version 0.61 of the driver, the while loop is now entered, (it runs once), and the value of $one is set to 0. This means that if I want to handle the case where queries may not return any results, I now have to do something like this: while ($sth->{syb_more_results}) { while (($one, $two, $three, $four, $five, $six, $seven) = $sth->fetchrow_array()) { print "$one \t$two \t$three \t$four \t$five \t$six \t$seven\n"; } } which is a huge pain, because there are hundreds of scripts that I would have to modify. Is there any way that I can change the behaviour of the driver so that empty result sets are handled like they used to be? Regards, Adam. ps - I have tried using several different versions of DBD::Sybase, but all versions behave the same.
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | ignore the prev mail having the make log- JKL, Swapna_Anand |
|---|---|
| Next by Date: | RE: MS SQL Server 2000, Swapna_Anand |
| Previous by Thread: | ignore the prev mail having the make log- JKL, Swapna_Anand |
| Next by Thread: | RE: MS SQL Server 2000, Swapna_Anand |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |