RE: Select X number of rows

2001-10-09 Thread Dong Wang
d Central Networks > [EMAIL PROTECTED] -Original Message- From: Steve Howard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 5:27 PM To: Steve Howard; Purcell, Scott; [EMAIL PROTECTED] Subject: RE: Select X number of rows One correction, I forgot to alias the table in the t

RE: Select X number of rows

2001-10-02 Thread Steve Howard
.Column1) BETWEEN 31 AND 40 Still ugly however you look at that one. :-( Steve H. -Original Message- From: Steve Howard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 7:08 PM To: Purcell, Scott; [EMAIL PROTECTED] Subject: RE: Select X number of rows Three suggestions dependin

RE: Select X number of rows

2001-10-02 Thread Steve Howard
M 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

RE: Select X number of rows

2001-10-02 Thread Sterin, Ilya
; Sent: 10/2/01 6:36 AM 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,

RE: Select X number of rows

2001-10-02 Thread Jones Robert Contr 81 CS/SCK
. . . . $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.

Select X number of rows

2001-10-02 Thread Purcell, Scott
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