Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AlexCold
Starting Member
39 Posts |
 Posted - 2001-02-19 : 05:33:08
|
| My question corresponding with this articlehttp://www.cfvault.com/index.cfm/mode/DisplayTutorial/TuUUID/CA3C99A0-EC34-11D3-85030050DABEAE1Bwhich is about creating Next/Previous record navigation.I'm NOT satisfied with this technique, because it need me to return all records that matching criteria and to filter this set of the records using cold fusion build-in tools. BUT... query result can contain hundreds of thousands rows and this way is VERY bad.So, my question is "How to select three rows from the table(s) - previous, current and next row?" |
|
|
|
|
|
HELP!!! Urgent!!! Selecting next/previous record.