What DB are you using Mathew? You may well be able to select a random row using the SQL.
That being said - you can acess the query object like an array of structs if you so desire. i.e. item = qNews[3]["Header"] Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] Quoting Matthew Kernick <[EMAIL PROTECTED]>: > Hi all, > > Is there any quick way to jump to a random row in a query ? > > have a series of records of which I want to randomly display 1 on the > page. > > Thanks > > Matthew Kernick > Development Team Leader > Director > eNTITy1 Pty Ltd - "The e-Business Specialists" > Switch PH: (08) 89411 162 > Direct PH: (08) 89468 271 > Fax: (08) 89411 167 > email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > website: http://www.entity1.com <http://www.entity1.com/> > > > > --- > 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
