Hi all,
Has anyone ever used the Win32::ODBC to process multiple result sets of different sizes? It doesnt seem to rebind the columns correctly for me.
$db->sql("
select starttime = getdate()
select a=1, b=2
select endtime = getdate() " );
do
{
while ($db->FetchRow())
{
my @columnNames = $db->FieldNames();
my @values = $db->Data();
print join "|", @columnNames;
print "\n";
print join "|", @values;
print "\n";
}
} while $db->MoreResults();
yeilds:
starttime
2002-08-01 18:45:31.277
starttime
1
starttime
2002-08-01 18:45:31.277
But I was expecting:
starttime
2002-08-01 18:45:31.277
a b
1 2
endtime
2002-08-01 18:45:31.277
Thanks!