If you already have the result set, and it is ordered by the id, then you could just use this
myQueryResult.id[currentrow+/-1] to fetch the previous/next id number very pseudo code here, but hopefully you get the drift. but not quite sure if this is what you're asking? On Jan 15, 2008 1:20 PM, Scott Stewart <[EMAIL PROTECTED]> wrote: > I have a basic table > > It has a numeric primary key and a field that determines display order. > > > > The records are displayed based on the record order. However the record > order may not be continuous > > (IE: 1, 2, 5, 7, 10) > > > > The application calls for an up/down order change feature. What I need to > be > able to do is select record order 7 and move it up or down > > So I'd need to be able to get the order number prior to or the next one. > > > > Any Ideas on how to retrieve this? > > > > sas > > -- > > Scott Stewart > > ColdFusion Developer > > > > SSTWebworks > > 4405 Oakshyre Way > > Raleigh, NC. 27616 > > (919) 874-6229 (home) > > (703) 220-2835 (cell) > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4