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:265265 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
