Note truly random but you could try SELECT .... SAMPLED x SAMPLE 100 where x is a number to specify how often to select a recod, you could change this number every time you did the select
h [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/08/2005 15:04 Please respond to [email protected] To [email protected] cc Subject [U2] True random select lists? I've posted the following to the OpenQM user's list, and thought I'd have a crack at U2-users as well. I've been playing with OpenQM at home for a couple of days now. Most of the questions I've had were quickly answered by consulting the manual. But because of the app I'm building at home, I have a question that could just as easily pertain to D3, U2, OpenQM or any of the other various multivalue databases. I've built a database of all my mp3s. Now I want to generate a random list of 100 songs. s there a way to do that with a SELECT statement, or must I muck around in basic to do so. I've searched c.d.p. and the U2 users mailing list. I use U2 at work, and am familiar with "SELECT ... SAMPLE 100", but it returns the same 100 records every time. Any thoughts? Thanks, -- Dave Walker 8..7 4(()) -:&:- -:&:- 8.74 .74(()) ((88.74 ..74 -:&:- ((88.74 * Peace ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
