You could create a database like this: ID|USERID|SONGID 1 1 222 2 1 443 3 1 9494 4 2 999 5 2 443 etc...
This can possibly grow to be HUGH ... (100,000 users X 40 = 4,000,000 records). But with stored proceedures and good indexing you should be fine. Paul Giesenhagen QuillDesign ----- 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4