There's an interesting article in CFDJ Oct 2002 page 40 by Tom Nunamaker which has an innovative way of storing checkbox selections using integers.
I'm not sure if it will help your basic problem but definately worth the read. Frank ----- Original Message ----- From: "Owens, Howard" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 17, 2003 11:39 AM Subject: RE: Best way to store 40 values? > Ah, what the hell ... I'll weigh ... besides ... I've done this -- this > exact thing. > > I assume with 10,000 songs to choose from, what you want to create is some > sort of shopping cart. > > Users will want to browse by Artist, Song Title, Song Style, at least. > Users will also want to be able to search. You're not going to be able to > serve up all 10,000 songs on a single page and just have them go through > check boxes. > > Each hitlist page (either through browse or search) will list the songs -- > there are two options on how songs get added to the cart ... either the user > clicks a button or checkbox and it's immediately added to the cart; or the > user checks the checkboxes and then scrolls to the bottom (or top) of the > page and clicks a "add selected items to cart" button. > > The cart is an array of structures stored in either session variables or in > WDDX and then the WDDX package is stored in a client variable (my > preference, but then I usually work on clustered servers). > > At insert, checkout, I prefer the table method recommended by others > (user_id,song_id). This gives more flexibility in a number of ways, such as > reporting (as mentioned previously). > > H. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
