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
