Hi.
I have a database of 4,000 or so records. I would like to do a query based
on some conditions (i.e. where active =1 AND group_id = 45). I can do this.
The problem I have having is that out of the conditional query I would like
to pull a random 3 records out and have use and be able to output the data
in those random 3 rows. So, to recap.......4,000 records in a database. I
might have a query where 500 out of the 4,000 match my conditional criteria.
Out of that 500 that gets returned in the query I would like to select a
random 3 out of only that 500 returned and have use of the data.. Can anyone
help?
Richard Mazur
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
