http://www.sqlteam.com/item.asp?ItemID=802
not exactly what you need, but a starter, plus links to similar articles that may be more useful Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Andy Hall" <[EMAIL PROTECTED] To: <[EMAIL PROTECTED]> .uk> cc: Subject: [ cf-dev ] Slightly OT: Returning a random row from SQL 09/03/02 Server 04:03 PM Please respond to dev Hi, I need to retrieve a random row from a table. Although I could get the whole recordset and select one in CF, I would prefer to only return the single row of data I need. Can anyone give me a neat method of getting SQL Server 7 to get one random row? I have got a random number based on the number of records, but unless I can access that row directly (like in CF - queryname.columnname[x]) then I dont know of a way to get the row. Does anyone know if I can do this? Any help appreciated Andy Hall. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
