> -Original Message-
> From: Daniel Falkenberg [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 07, 2001 7:58 PM
> To: Beginners (E-mail)
> Subject: DBI Perl and rows...
>
>
> List,
>
> I have the following code here
>
> my $sth = $dbh ->prepare( qq{ SELECT * FROM
>
sage-
From: Michael Fowler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 11:08 PM
To: Daniel Falkenberg
Cc: Beginners (E-mail)
Subject: Re: DBI Perl and rows...
On Wed, Aug 08, 2001 at 09:27:34AM +0930, Daniel Falkenberg wrote:
> Now what I really want to be able to do is only displ
On Wed, Aug 08, 2001 at 09:27:34AM +0930, Daniel Falkenberg wrote:
> Now what I really want to be able to do is only display 10 of the rows in
> the database then create a hyperlink to to the next 10 and so on.
Pass along an offset with each request, and structure your SQL query to
use this offse
The answer to this is probably in your DBMS. What DBMS are you using.
Different ones have different ways to page the data. Using MySQL you need to
use the LIMIT keyword to specify how many rows to skip, and how many to
return (when two parameters are used with limit).
Using MSSQL 7.0 or later you
