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?

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 F

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! > &g

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 assu

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 mysq

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 ea

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. --