If the songs all have a unique ID, why not just store the ID's as a comma separated list in one field? ----- Original Message ----- From: "Paul Campano" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 17, 2003 8:51 AM Subject: Best way to store 40 values?
> I have a database of approx 10000 songs. I want users to be able to choose 40 of them (probably using checkboxes via a form) and save their preference of these songs to a database. I guess I could always make 40 database fields named song1, song2, song3...., but I figured there must be a better way than that. Any suggestions? Thanks. > > > Paul > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
