Solved

Perl - Recordset

Posted on 2004-03-25
4
678 Views
Last Modified: 2006-11-17
I'm fetching data from the sql server into a perl recordset. I need to traverse thro' the recordset multiple times. How to proceed?
0
Comment
Question by:Karuppaiah
4 Comments
 
LVL 8

Expert Comment

by:davorg
ID: 10677280
What are you using to query the database and build the recordset? DBI or Win32::ODBC or something else?

It's hard to help without any real information and debugging by telepathy gives me a headache.

Dave...
0
 
LVL 3

Accepted Solution

by:
PerlKing earned 500 total points
ID: 10755912
You should be able to get the recordset into an array.
To take an example, assuming you are using DBI to connect to Oracle:

use DBI;

my $dbh = DBI->connect("dbi:Oracle:hostname", "username/password", "",);

my $results = $dbh->selectall_arrayref(qq{SELECT blah, blah FROM somewhere... });

Now $results is an array reference to the list of rows.
So you could traverse the list, back and forth, as many times as you want !!

Regards
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Existing perl code to be changed for ftp to sftp handling 14 212
Perl for loop for 2000 ms 7 105
problem with using the glob function 1 74
Control Number of Log Files -Perl 7 87
I've just discovered very important differences between Windows an Unix formats in Perl,at least 5.xx.. MOST IMPORTANT: Use Unix file format while saving Your script. otherwise it will have ^M s or smth likely weird in the EOL, Then DO NOT use m…
In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (http://dilbert.com/strips/comic/2007-08…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question