and hats of off to you...we will now have a nice Tea Maker SP in the office......
-----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 17 July 2003 13:21 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] random variable selection.. Good point. I just didn't like the tone of the reply. >> What I'm trying to say is that quite often I need to question why someone wants answers to a specific problem, as invariably there's a much easier/better way of going about it. Yup, but isn't it all a leaning process? Someone has a problem, you offer a solution, but remind them of the fact that there maybe a better way (which I didn't). >> Simply providing someone with the answer to their question isn't necessarily a good thing. Quite right, but sometimes in doing so you spark off new lines of investigation. I will never understand why some people get flustered to replies on these lists. If you feel there is a better way of doing something, then point it out, but don't be rude about it. And anyway, I'm a little rusty on using CASE in SQL so it was a good reason to give it a go. Sometimes I feel like a little challenge, and today is one of those days. Ade -----Original Message----- From: Steve Martin [mailto:[EMAIL PROTECTED] Sent: 17 July 2003 13:04 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] random variable selection.. Stephen had a fair point. For example, I have a bunch of developers here who quite often ask me questions along the lines of: "Which toothpick should I use to eat this rice with?" Now, I could provide a nice neat answer which provides him with the best toothpick on the market, or I could say "whoa, why use a toothpick? Use a spoon instead." What I'm trying to say is that quite often I need to question why someone wants answers to a specific problem, as invariably there's a much easier/better way of going about it. Simply providing someone with the answer to their question isn't necessarily a good thing. Steve > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 17 July 2003 12:59 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] random variable selection.. > > > Well he didn't mention CF. > > He asked for a solution to something, which I gave, whether > it's the best > solution is another issue. > > Also, you have no idea what else is going on in the SP/SPs. > Granted if a > fuller picture is given you can give a better answer. Why get > your knickers > in a twist over a solution to a problem? > > Ade > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 17 July 2003 12:45 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] random variable selection.. > > > I have to say that's got to be the most pointless use of a > stored procedure. > This is the reason why I really hate developers using stored > procedures in > their applications! Nine times out of ten, when you look at > what the SP has > been set up to do you discover there was really no need to > give it to the DB > server to do and all they've managed to do is generate code that is > virtually unreadable, impossible to move and virtually > impossible to use. > Just because you can doesn't mean you should! > > <cfscript> > varlist = "varone,vartwo,varthree,varfour"; > selectedvar = ListGetAt(varlist,RandRange(1,ListLen(VarList))); > varcontent = variables[selectedvar]; > </cfscript> > > Stephen > ---- Message from Adrian Lynch <[EMAIL PROTECTED]> > at 12:39:15 > 2003-07-17 ------ > >Opps, this will work better... > > > > > > DECLARE > > @one INT, > > @two INT, > > @three INT, > > @theChosenOne INT, > > @var INT > > > > SELECT @one = 1, @two = 2, @three = 3 > > > > SELECT @theChosenOne = > > CASE SELECT CAST(RAND() * 3 AS INT) + 1 > > WHEN 1 THEN @one > > WHEN 2 THEN @two > > WHEN 3 THEN @three > > END > > > > SELECT @theChosenOne > > > >I get back 1, 2 or 3 now > > > >Enjoi > > > >Ade > > > >-----Original Message----- > >From: Adrian Lynch [mailto:[EMAIL PROTECTED] > >Sent: 17 July 2003 12:37 > >To: '[EMAIL PROTECTED]' > >Subject: RE: [ cf-dev ] random variable selection.. > > > > > >You'll need to play about with the RAND() bit as I was > getting back NULL > >some of the time. But this assigns the value of @one, @two > or @three to > >@theOne. > > > > DECLARE > > @one INT, > > @two INT, > > @three INT, > > @theOne INT > > > > SELECT > > @one = 1, > > @two = 2, > > @three = 3 > > > > SELECT @theOne = > > CASE CAST(RAND() * 4 AS INT) > > WHEN 1 THEN @one > > WHEN 2 THEN @two > > END > > > > SELECT @theOne > > > > > >Ade > > > >-----Original Message----- > >From: Robertson-Ravo, Neil (RX) > >[mailto:[EMAIL PROTECTED] > >Sent: 17 July 2003 12:19 > >To: '[EMAIL PROTECTED]' > >Subject: [ cf-dev ] random variable selection.. > > > > > >I am having a real brain fuzz this morning.... > >anyone got an example of how I can create an sp which has > say 10 predefined > >vars in it : > > > >a,b,c,d etc..... and then runs a routine to select a random one? > > > > > >-- > >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] > >-- >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] > >-- >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
