Salutations to monks. I observed that perl (5.005_03) with DBlib behaves in an unexpected way, when $dbh->dbnextrow(return_hash=1,return_ref=1) is called; For first dbnextrow(1,1) call all fine. But second dbnextrow(1,1) call over writes the first reference returned.

I solved the problem by using dbnextrow(1,0) (getting hash instead of hash ref) But just wondering where is the problem 

$  /apps/gnu/bin/perl
use Sybase::DBlib;
$dbh = new Sybase::DBlib (SERVER,USER,PASS);

$dbh->dbcmd('select ser=@@servername');
$dbh->dbsqlexec; $dbh->dbresults;
$a = $dbh->dbnextrow(1,1);

$dbh->dbcmd('select dt=getdate()');
$dbh->dbsqlexec; $dbh->dbresults;
$b = $dbh->dbnextrow(1,1);

print " a-ser:  $a->{'ser'} \n\n";  # this becomes non-existant
print " a-dt:  $a->{'dt'}  \n\n";   # this value suddenly appears, whi
+ch was not even present in the original query
print " b-ser:  $b->{'ser'}  \n\n";
print " b-dt:  $b->{'dt'}   \n\n";
__END__

OUTPUT :
--------

 a-ser:

 a-dt:  Mar 30 2011  8:37:50:646PM

 b-ser:

 b-dt:  Mar 30 2011  8:37:50:646PM

[download]

In reply to DBlib dbnextrow(1,1) problem by Kargil Jay

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.