You could always store them as XML/WDDX within one field in the DB, or you could also store them as a list....both are not ideal RDBMS teqniques but they will work..
-----Original Message----- From: Paul Campano [mailto:[EMAIL PROTECTED]] Sent: 17 January 2003 14:52 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
