note
bsdwolf
Okay, I'm back (again).
Using $sth->fetchrow_hashref seems to be solving my problem. I have discovered that one cannot use $sth->fetch if one chooses to execute a query containing conditionals based on fields; i.e.
<code>
$sth->prepare("SELECT * FROM db WHERE field < 2000");
while (@row = $sth->fetch) {
...
}
</code>
will return the first row and then nothing beyond that.
If I use
<code>
while ($row = $sth->fetchrow_hashref) { ...
</code>
for some reason, everything seems to be hunky dory.
Also, that <code>"undef"</code> in setting up the column names and variable references also is wont to cause me difficulty ("perldoc DBD::CSV" for reference on that one).
Go figure.
<div class="pmsig"><div class="pmsig-526115">
<center>--*greywolf;<br>/* relayer halo gmail */</center>
</div></div>
526117
526130