Hi Dave - Once sorting is done by using order by clause in query - use anchor names <a name=XXXX> while generating/displaying records and pass the value of XXXX ( which would most probably be a date or if you guess anything better) in the url of this page.
This way the focus would be on the record which is current.. Thanks. -Sandy Vohra -----Original Message----- From: David Hind-Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 19, 2006 12:57 PM To: CF-Newbie Subject: Landing on today's date Hi all, We're writing a search in CFMX7 that returns a series of records. Each record has a date field as part of the structure. The date associated with each record can occur both in the past and the future. What we'd like to be able to do after our search is land on the closet date to 'today'. The web user then can hit 'forward' to begin scrolling through future dates or 'back' to scroll through older dates. Its easy enough to sort the records of course, but are there any suggestions that land the user in the middle? Many thanks, David -- David Hind-Smith | president ___________________________________ ://hind-smith.com 2156 Glenfield Road Oakville, ON L6M 3S6 tel. 416.234 .6406 x111 toll free. 1.866.892.1727 fax. 416 .231 .0311 [EMAIL PROTECTED] www.hind-smith.com Customized Software for Ad and Creative Agencies. See the possibilities at our new www.jobtracksoftware.com site. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2363 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
