Also, since Sybase ASE uses a lot of the same T-SQL constructs, you can
attempt some methods located here:
http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#6.2.12
--
Matt
"Noam Giladi" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> a solution offered i recei
l :)
>
> -Original Message-
> From: Noam Giladi [mailto:[EMAIL PROTECTED]]
> Sent: woensdag 19 februari 2003 16:00
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] "LIMIT" problem MSSQL
>
>
> I'm trying to split results into different pages and number the pages
Well if you do, (sort by id) this will work.
On Wed, 2003-02-19 at 11:14, Noam Giladi wrote:
i'm not using a fixed sort
tnx noam
"Adam Voigt" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
Assuming your sorting by id, just do:
i'm not using a fixed sort
tnx noam
"Adam Voigt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Assuming your sorting by id, just do:
SELECT TOP 50 * FROM TABLE WHERE id > $lastid
And just have lastid posting to the page every time
they hit next,
Assuming your sorting by id, just do:
SELECT TOP 50 * FROM TABLE WHERE id > $lastid
And just have lastid posting to the page every time
they hit next, and in lastid, put the last id of the results
on that page.
On Wed, 2003-02-19 at 09:59, Noam Giladi wrote:
I'm trying to sp
> > $sql = "SELECT * FROM bla Limit $start, $numbers_to_show";
> >
> > or just go to mysql.com and use the manual :)
> >
> > -Original Message-
> > From: Noam Giladi [mailto:[EMAIL PROTECTED]]
> > Sent: woensdag 19 februari 2003 16:00
> >
From: Noam Giladi [mailto:[EMAIL PROTECTED]]
Sent: woensdag 19 februari 2003 16:00
To: [EMAIL PROTECTED]
Subject: [PHP-DB] "LIMIT" problem MSSQL
I'm trying to split results into different pages and number the pages
accordingly. I've been able to build a fairly intellige
t: [PHP-DB] "LIMIT" problem MSSQL
I'm trying to split results into different pages and number the pages
accordingly. I've been able to build a fairly intelligent page numbering
system which knows which rows it should pull (at least by numbering each row
numerically) but I don'
I'm trying to split results into different pages and number the pages
accordingly. I've been able to build a fairly intelligent page numbering
system which knows which rows it should pull (at least by numbering each row
numerically) but I don't know how to construct a SQL query to pull 10
results
