The bad thing about a list or XML or WDDX as some have mentioned if you just want to grab a users songs, it is not a bad method, but if you want to later run some statistics on what is the most common saved song or any other type of lookup, you have alot of hoops to jump through to get your data and parse it.
I used to be a HUGE fan of storing lists and wddx packets .. but now stay away from it as much as possible.. Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Bruce Sorge" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 17, 2003 8:49 AM Subject: Re: Best way to store 40 values? > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
