Christopher, Thanks for the feedback. I will try to come up with a better designed solution and some more examples of where and why to use it.
Thanks! On 12/28/06, Christopher Jordan <[EMAIL PROTECTED]> wrote: > > Yeah, shopping sites was the example I thought of half way through my > post. Like when amazon shows me random products that I might like... > that sort of thing. I suppose it's because I don't spend time writing > consumer sites that I forget things like that. I'm currently working on > a scheduling program for what amounts to a temp agency. No randomness > needed... well, not as far as random table rows goes. :o) > > Cheers, > Chris > > Snake wrote: > > That brings back some memories. > > I actually wrote a banner system once, and I believe the method I used > back > > then, was to query all the primary keys, then pick a random row from the > > query, extract the primary key and selectthat record. > > This was many years ago back in the days of CF4 though :-) > > > > Russ > > > > -----Original Message----- > > From: Dan Vega [mailto:[EMAIL PROTECTED] > > Sent: 28 December 2006 22:17 > > To: CF-Talk > > Subject: Re: random cfc > > > > Christopher, > > Please remember that I am asking these same questions so there is no > such > > thing as ignorance just different perspectives. With that being said I > would > > read the two posts because even if you do not need the random cfc they > are > > very good articles. Here is a situation where you would need a random > row. > > You could use it in a banner ad program where you just want to display a > > random ad, or a shopping cart where you want to show a random product > from > > the products table. Maybe you would even like to customize it for our > > shopping cart application. Lets say we have a featured flag in our > products > > table, you could add to that > > > > and featured = 1 > > > > Now on our home page instead of writing a featuredProduct rotator > component > > we can just grab a random row. These are just ideas but who knows, maybe > > someone else can make use of it. I needed it for a specific reason that > I am > > not at liberty to share. Feedback is always welcome so thank you for > your > > thoughts Christopher! > > > > Dan Vega > > > > On 12/28/06, Christopher Jordan <[EMAIL PROTECTED]> wrote: > > > >> Okay. I'm gonna show some ignorance here. Ready? Good. :oP > >> > >> I read your blog entry, Dan, and the entire CFC. I did not read either > >> of the other two blog articles you mentioned (so maybe that's where > >> this ignorance is coming from). I understand how your code works. > >> That's not my problem. > >> > >> uh... what's the point? Why would you want to get a random row from a > >> table? > >> > >> Okay, to be fare, I just thought of one reason. So maybe there are > more. > >> Are there folks out there clamoring for the ability to get a random > >> rows, random directories and random colors? > >> > >> Random strings and numbers I see more use for, but there are already > >> plenty of UDFs written that can obtain a random string of characters > >> (numbers included). > >> > >> I guess I just don't understand. There must be a reason I'm missing. > >> Help me. :o) > >> > >> Cheers, > >> Chris > >> > >> Dan Vega wrote: > >> > >>> All, > >>> I just created a quick and dirty random cfc component and a quick > >>> > >> posting to > >> > >>> go with it. I could really use some feedback on how to split it up > >>> if > >>> > >> anyone > >> > >>> gets a chance. > >>> > >>> http://www.danvega.org/blog/index.cfm/2006/12/28/Random-CFC > >>> > >>> > >>> > >>> > >>> > >> -- > >> http://www.cjordan.info > >> > >> > >> > >> > >> > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
