Re: Select previous group

[Rhino]

----- Original Message ----- From: Carl To: mysql@lists.mysql.com Sent: Sunday, March 20, 2005 8:38 AM Subject: Select previous group Seems like there should be a simple solution to my problem but I have been unable to find it.   Suppose you have a phone book of names, addresses, etc.  You are looking at page 100 and want to now see page 99.  (The person data is, of course, dynamic so a specific name is not tagged to a specific page.)  How can I select the names for page 99 (in this case) knowing only the first name on page 100 and the number of names I want to display?   Thanks,   Carl   The answer is: it depends. Are you trying to accomplish this in SQL from a command line or batch script or are you doing this in a program? If you are using a programming language, which one are you using and what version of the language are you using? Also, what version of MySQL are you using? Different versions have different capabilities.   In brief, it is easier to do what you are describing - scrolling backwards through a result set - in a programming language like Java than it is in straight SQL; I'm not even sure if it is *possible* in straight SQL but greater minds than mine may have figured out a way. Even within programming languages, it can be tedious to manage or relatively straightforward; for example, using (Java) JDBC 1.0, it is fairly tedious to scroll backwards through a result but later versions of JDBC make it relatively easy.   Rhino

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15/03/2005


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]