i assume this problem was solved in the past....
i didn't found a ready solution.
i try to use  FATCH .

and i have another link with ths same problem..
http://forums.devshed.com/showthread.php?threadid=33114


tnx  noam


"John Krewson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> The title suggests MSSQL, which if I am correct doesn't support Limit
> like MySQL.
>
> I'm working on the same thing right now so I don't have a quick and
> dirty working example, although it doesn't look to be too difficult to
> use server side cursors in MSSQL.
>
> Here is a related a link to a similar question at phpbuilder:
> http://www.phpbuilder.com/mail/php-db/2001062/0055.php
>
> Snijders, Mark wrote:
> > $start = 10;
> >
> > $numbers_to_show = 25;
> >
> > $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
> > 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 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 starting at a certain number.
> >
> > please  did anyone wrote a proc that do it?.
> >
> >
> >
> >
>
> --
> John Krewson
> Programmer - SWORPS
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to