Just setup the form with the list of songs & give each song a unique id. Then, have the checkboxes (or select list) all with the same name (ie. <input type=checkbox name=songid value=songid>)...Then, when you process the results of the form, the value for songid will come back as 1,2,3,4,5,6,7,8,9...just store it as that...
Then, when you want to find out what they selected, just have it split the value by the comma, and put that into an array...Then go that route... HTH! Scott -----Original Message----- From: Paul Campano [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 9:52 AM To: CF-Talk 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