Re: [PHP] I need do paging in php, I use ODBC Access

2005-04-24 Thread Jochem Maas
Richard Lynch wrote: On Fri, April 22, 2005 7:31 am, Matthew Weier O'Phinney said: Actually, LIMIT is in ANSI SQL. Either the ANSI standard changed, or Rasmus needs to update his Bio... http://lerdorf.com/bio.php "...he can be blamed for the ANSI92 SQL-defying LIMIT clause in mSQL 1.x which has no

Re: [PHP] I need do paging in php, I use ODBC Access

2005-04-22 Thread Richard Lynch
On Fri, April 22, 2005 7:31 am, Matthew Weier O'Phinney said: > Actually, LIMIT is in ANSI SQL. Either the ANSI standard changed, or Rasmus needs to update his Bio... http://lerdorf.com/bio.php "...he can be blamed for the ANSI92 SQL-defying LIMIT clause in mSQL 1.x which has now, at least conce

Re: [PHP] I need do paging in php, I use ODBC Access

2005-04-22 Thread Matthew Weier O'Phinney
* Jochem Maas <[EMAIL PROTECTED]> : > Richard Lynch wrote: > > On Thu, April 21, 2005 12:23 pm, Warren Vail said: > > > > > The only approach left that I could come up with is to transfer the > > > entire sequence set to your application, and count the rows, perhaps > > > only displaying the rows

Re: [PHP] I need do paging in php, I use ODBC Access

2005-04-22 Thread Jochem Maas
Richard Lynch wrote: On Thu, April 21, 2005 12:23 pm, Warren Vail said: The only approach left that I could come up with is to transfer the entire sequence set to your application, and count the rows, perhaps only displaying the rows you want to show. This is obviously not very efficient (in fact,

RE: [PHP] I need do paging in php, I use ODBC Access

2005-04-22 Thread Richard Lynch
On Thu, April 21, 2005 12:23 pm, Warren Vail said: > The only approach left that I could come up with is to transfer the > entire sequence set to your application, and count the rows, perhaps > only displaying the rows you want to show. This is obviously not very > efficient (in fact, with enough

Re: [PHP] I need do paging in php, I use ODBC Access

2005-04-22 Thread Richard Lynch
On Thu, April 21, 2005 2:02 pm, chris said: > You are right about MSSQL not having a limit, but here is an article that > shows a work around > http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=850&lngWId=5 Just use a cursor. It's not that tricky. Honest. -- Like Music? h

Re: [PHP] I need do paging in php, I use ODBC Access

2005-04-21 Thread chris
You are right about MSSQL not having a limit, but here is an article that shows a work around http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=850&lngWId=5 "Warren Vail" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >> Somebody did paging in php for data ori

RE: [PHP] I need do paging in php, I use ODBC Access

2005-04-21 Thread Warren Vail
> Somebody did paging in php for data origin in ODBC Access? > > I need an algorithm for doing this, please Help me! I assume by "paging" you are referring to a scrolling algorithm that allows you to view only a small portion of your query result set. The algorithm that comes to mind is depe