RE: Paging!

2004-01-29 Thread Mike Johnson
From: Adel Ardalan [mailto:[EMAIL PROTECTED] When I select a rather large table to be shown, the rows are going very fast and I can't see the rows at the beginning. Also, I can't scroll up. How can I view the results page by page? I can only assume you're talking about the native mysql

RE: Paging!

2004-01-29 Thread Mike Johnson
From: Mike Johnson From: Adel Ardalan [mailto:[EMAIL PROTECTED] When I select a rather large table to be shown, the rows are going very fast and I can't see the rows at the beginning. Also, I can't scroll up. How can I view the results page by page? I can only assume you're

RE: Paging!

2004-01-29 Thread Dan Greene
another option is to set your pager option: mysql pager more then re-run your query -Original Message- From: Mike Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 11:01 AM To: Adel Ardalan; [EMAIL PROTECTED] Subject: RE: Paging! From: Adel Ardalan [mailto

RE: Paging!

2004-01-29 Thread Mike Johnson
From: Dan Greene [mailto:[EMAIL PROTECTED] another option is to set your pager option: mysql pager more then re-run your query Wow. You learn something new every day. Thanks! -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For

Re: Paging!

2004-01-29 Thread Fred van Engen
On Thu, Jan 29, 2004 at 11:19:27AM -0500, Mike Johnson wrote: From: Dan Greene [mailto:[EMAIL PROTECTED] another option is to set your pager option: mysql pager more then re-run your query Wow. You learn something new every day. How about the 'help' command? You'll learn

Re: paging of records.. any suggestions?

2002-07-17 Thread Shashank Tripathi
Hi, Not sure which language you are using, but I hope this will give you some ideas: http://www.phpbuilder.com/columns/rod20001214.php3 Hope this is useful, Shashank -- sql, query, select etc. all the jazz that will make this message go through to the list.

RE: paging of records.. any suggestions?

2002-07-17 Thread Cal Evans
Depends on the language you are writing in and the acceptable latency of the user. If you are writing in PHP or another scripting language for a web based application where the server will have to artificially preserve stat then I would not attempt to cache the recordset, I would get a new one