Yes.
Run a connect to each DB you want to work with. You can then run queries with a where clause of 'rownum <= 20' to get a sampling of a table from each DB. I'm not sure about a page count myself, but you can check the number of records in each DB in each table with a 'select count(*)' query statement. These are pretty much SQL questions for the most part. $dbh1=DBI->connect(.....); $dbh2=DBI->connect(.....); $dbh3=DBI->connect(.....); . . $sth1=$dbh1->prepare(....); . . $sth2=$dbh2->prepare(....); . . $sth3=$dbh3->prepare(....); . . . . $dbh3->disconnect; $dbh2->disconnect; $dbh1->disconnect; -----Original Message----- From: Purcell, Scott [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 7:36 AM To: '[EMAIL PROTECTED]' Subject: Select X number of rows Hello, I am a Perl guy, not a DBA. Anyway, if I have a couple of DBs with X amount of records, can I select from three databases, acquire the first 20 records (sort by ASC), then (show them on the web) and when they hit next, show the next 20, eg. 21-40 and so on and so on. Also, If that is doable, how do I know how many pages. Is there some command in SQL that would tell me how many records are in the three DBS without me having to acquire and count all the records first? I hope this is not too much of a SQL question, but as I am building this in Perl. I hope I do not offend anyone with this morning off-perl question. Thanks you very much, Scott Purcell
