You'd probably be wanting to look at cursors within the DB, that's if your using MS SQL.
Taco Fleur 07 3535 5072 Tell me and I will forget Show me and I will remember Teach me and I will learn -----Original Message----- From: Ricardo Russon [mailto:[EMAIL PROTECTED] Sent: Friday, 26 March 2004 10:17 AM To: CFAussie Mailing List Subject: [cfaussie] SQL SELECT Morning guys... Is there a quick (and clean or dirty) way of finding the previous and next record from a database? I would just use the auto increment to do it, but I am not willing to trust that records won't get deleted. And I didn't want to grab the whole table and process it. TIA Ricardo. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
