Whoops - my bad - A structure of arrays.
So item = qNews["Header"][3] Just to clarify ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] Quoting Mark M <[EMAIL PROTECTED]>: > 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 > > > --- 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
