> The basic question is what's the ASP/PerlScript way to fetch a row of data > into a hash the way DBI's fetchrow_hashref() does? If you know DBI, why not use it? It sounds like the right tool for the job in your case. Ron Savage has a tutorial on using DBI with ADO: http://savage.net.au/Perl-tutorials.html#tut-12 > The basic question is what's the ASP/PerlScript way to fetch a row of data > into a hash the way DBI's fetchrow_hashref() does? Its more ADOish ( not to mention faster ) to use GetRow(), GetString(), or iterate through the recordset object with MoveNext() rather than copy the value into another data structure and then reprocess the information. You could very easily roll your own using these: $rs->Fields->{Count}; # number of columns for this row $rs->Fields( N )->{Name}; # name of the Nth column $rs->Fields( N )->{Value}; # value of the Nth column # extract column names from first record for my $i ( 0 .. $rs->Fields->{Count}-1 ) { $names{ $rs->Fields(0)->{Name} } = $i; } foreach my $column ( sort { $names{$b} <=> $names{a} } keys %names ) { $Response->Write("'$column' is the name of column [$names{$column}]<br>"); } - Ron _______________________________________________ Perl-Win32-Web mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web
