I may have missed something in the discussion as to the ultimate goal,
but what about doing the sorting at the DB level, as this would
seemingly make your code more readable and the DB is likely faster at
this than Perl (as wonderful as it is).
Or was the original intent to sort the keys of the field, which again I
would think the DB should be able to handle this by realigning the field
names in the initial select??
Jeff 'japhy' Pinyan wrote:
> On Jul 16, Shishir K. Singh said:
>
>
>>>while($db->FetchRow()){
>>> %Data = $db->DataHash(First_Name,Last_Name);
>>> foreach $key (sort(keys %Data)) {
>>> print $key, '=', $Data{$key}, "\n";
>>> } # end foreach
>>> print("\n");
>>>}
>>
>>Just curious. I assume that you are using DBI module. If so, I don't see
>>the methods FetchRow and DataHash in the perldoc for DBI. I have version
>>DBI 1.21. Am I missing something here ??
>
>
> No, Ron is using the Win::ODBC module. Yes, its naming conventions and
> overall API suck.
>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
