as a list... get your songId's as the value of your checkboxes, have all of the checkboxes "named" the same thing, and then they will come in a list.
do some checking to validate the length of the list to only 40 values, and from there you got it. and from there, that list can become an array, etc... that's how I would do it. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -----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