Don't you need to know something else if you use Last Name as the index? What if there are multiple John Smith's?
I haven't actually done this, but what if you pulled all records with the last name they selected, then used array notation to pull the ID from the record before and after the current record? Too bad databases don't generally have a numeric, sequential record number like ColdFusion's query object (currentRow variable). -----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Sunday, December 12, 2004 1:41 PM To: CF-Talk Subject: Re: select next/previous *record*? > Quick question...are ya using DreamweaverMX? Nope. Another complication I didn't mentuion before is the user has the ability to select which index is current, so they might be indexing on ID, and cycling up and down thru the numbers, or one of several other fields, such as Last Name. I'm working thru that now. Don't see how it would work in the ID-based example. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187409 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
