Hi Sandy, Thanks for the feedback. As there are possibly thousands of records (I should have mentioned this) we'll be displaying about 50 records per page. So if there were 2000 records over 40 pages, we need to land on 'page 26' as an example and on the correct record. Its landing on the correct page that we'd like to handle cleanly.
Many thanks, David -----Original Message----- From: Vohra, Sandeep Singh [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 19, 2006 1:08 PM To: CF-Newbie Subject: RE: Landing on today's date 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:2364 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
