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:
Sent: Tuesday, August 09, 2005 1:50 PM
Subject: RE: [U2] True random select lists?
> I
Sidebar: Are you playing the MP3's with QM or just managing them.
Thanks.
- Original Message -
From: "Dave Walker" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 09, 2005 10:04 AM
Subject: [U2] True random select lists?
> I've posted the following to the OpenQM user's list, and thought I
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(),
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
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 .7
4 * Peace
I have yet to figure them out?
George
-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 busi
ce
> -Original Message-
> 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 pr
] 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
half Of Dave Walker
> Sent: 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.
>
>
g.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 managed to create a python wrapper for the library, an
> From: [EMAIL 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 .
Elwood
> Sent: Tuesday, August 09, 2005 12:11 PM
> To: u2-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 h
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/
-Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] 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
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 La
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/
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
u2-users@listserver.
> [mailto:[EMAIL PROTECTED] 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
>
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
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 effectiv
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
21 matches
Mail list logo
