Re: [U2] True random select lists?

2005-08-11 Thread Mark Johnson
Sidebar: Are you playing the MP3's with QM or just managing them. Thanks. - Original Message - From: Dave Walker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, August 09, 2005 10:04 AM Subject: [U2] True random select lists? I've posted the following to the OpenQM

Re: [U2] True random select lists?

2005-08-11 Thread Mark Johnson
You are getting at the ID3 tags from QM? Sorry for the late question. I've been away for 3 days. Thanks. - Original Message - From: Dave Walker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, August 09, 2005 1:50 PM Subject: RE: [U2] True random select lists? I use

Re: [U2] True random select lists?

2005-08-10 Thread Dave Walker
On Tue, 2005-08-09 at 10:21 -0500, Geoffrey Mitchell wrote: This doesn't work (at least on UV). The sample happens before the sort, not after. Otherwise, however, it's an ingenious idea. Incidentally, you could do the same thing (at least in UV) without creating a new dictionary, by

Re: [U2] True random select lists?

2005-08-10 Thread Martin Phillips
Hi Dave, SELECT MYFILE BY EVAL RND(@TIME) This sounded good, but OpenQM complains Sort item cannot be a literal value. Sounds like a bug to me! This is the query processor trying to be too clever. It rejects expressions that have no variable elements when used as sort items. RND(), of

[U2] True random select lists?

2005-08-09 Thread Dave Walker
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

Re: [U2] True random select lists?

2005-08-09 Thread Christophe Marchal
I'va made something like this on U2 too. Juste make a derived field that use RND(@TIME) to generate a random number. (maybe in a subroutine) And use select like this : SELECT MYFILE BY RANDOM_FIELD SAMPLE 100 But, as ordering record is made before sampling, it could take a little time if you

Re: [U2] True random select lists?

2005-08-09 Thread Martin Phillips
Hi Dave, 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. This depends what you mean by random. If you are happy to agree that the hashing process is effectively

Re: [U2] True random select lists?

2005-08-09 Thread Geoffrey Mitchell
This doesn't work (at least on UV). The sample happens before the sort, not after. Otherwise, however, it's an ingenious idea. Incidentally, you could do the same thing (at least in UV) without creating a new dictionary, by using EVAL. i.e., SELECT MYFILE BY EVAL RND(@TIME) That way you

RE: [U2] True random select lists?

2005-08-09 Thread Dave Walker
Phillips Sent: Tuesday, August 09, 2005 10:46 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] True random select lists? Hi Dave, 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

Re: [U2] True random select lists?

2005-08-09 Thread harjinder . dhothar
@listserver.u2ug.org To u2-users@listserver.u2ug.org 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

RE: [U2] True random select lists?

2005-08-09 Thread Mark Eastwood
Try creating an I Descriptor dictionary item that uses the RND() function. SSELECT xxx BY NEWDICT READNEXT first item, should be different each time? Mark. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] True random select lists?

2005-08-09 Thread Martin Phillips
Dave, I'm wondering which would be more efficient; the basic subroutine or Christophe's suggestion of an I descriptor? Both solutions require that the entire file is read to construct the list. There probably isn't a lot in it either way. Martin Phillips Ladybridge Systems 17b Coldstream

RE: [U2] True random select lists?

2005-08-09 Thread Allen E. Elwood
] Behalf Of Martin Phillips Sent: Tuesday, August 09, 2005 10:46 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] True random select lists? Hi Dave, 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

RE: [U2] True random select lists?

2005-08-09 Thread Rex Gozar
To build on Christophe Marchal's idea, why not SELECT MYFILE BY EVAL RND(@TIME) SELECT MYFILE SAMPLE 100 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] True random select lists?

2005-08-09 Thread Dave Walker
-users@listserver.u2ug.org Subject: RE: [U2] True random select lists? The I-desc is a nice idea, however you're going to get multiple hits on the same song, and don't we all hate that when we hear the same song? The basic idea is very similar to something that I did with the thought

RE: [U2] True random select lists?

2005-08-09 Thread Dave Walker
PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 11:31 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] True random select lists? Note truly random but you could try SELECT SAMPLED x SAMPLE 100 where x is a number to specify how often

RE: [U2] True random select lists?

2005-08-09 Thread Allen E. Elwood
' Subject: RE: [U2] True random select lists? I use xmms for playing the music, but until now have used a mysql database to generate the playlists. What I'm actually trying to do is learn how to talk to OpenQM with qmclilib. I've managed to create a python wrapper for the library, and have now built

RE: [U2] True random select lists?

2005-08-09 Thread Norman Morgan
: Tuesday, August 09, 2005 12:51 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] True random select lists? I use xmms for playing the music, but until now have used a mysql database to generate the playlists. What I'm actually trying to do is learn how to talk to OpenQM with qmclilib. I've

RE: [U2] True random select lists?

2005-08-09 Thread Peter Gonzalez
] Behalf Of Dave Walker Sent: Tuesday, August 09, 2005 10:51 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] True random select lists? I use xmms for playing the music, but until now have used a mysql database to generate the playlists. What I'm actually trying to do is learn how to talk to OpenQM

RE: [U2] True random select lists?

2005-08-09 Thread Dave Walker
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Tuesday, August 09, 2005 2:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] True random select lists? Wow, and here I just program dull business programs, day after day, year after year

RE: [U2] True random select lists?

2005-08-09 Thread George Gallen
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Walker Sent: Tuesday, August 09, 2005 3:02 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] True random select lists? The dull business programs is my day job. The fun stuff is at night. Just

[OT] Sig (WAS RE: [U2] True random select lists?)

2005-08-09 Thread Dave Walker
Well, back before I had to use outlook as my email client, it was some spiffy ascii art that looks like swirls of smoke and stars with 'Peace' at the end. Outlook mangles it so that it's unrecognisable before it sends it, though. -- Dave Walker 8..7 4(()) -::- -::-8.74