How about we not break the most basic rules of normalization for no good reason. Both XML and list methodologies are lumping separate data elements together into a single field.
If you do this you're going to have lots of problems down the road. With a list or xml, how can you determine the average number of songs a person has selected? How can you determine what is the most popular song? What happens if you remove a song? All of these very trivial questions in a normalized database become a real PIA with a non-normalized database where you're storing data in a list or XML. Ray's suggestion is the correct normalized way to store the data. Sam At 09:54 AM 1/17/2003, you wrote: >Why not just use a delimited list? Or save it in the database as WDDX or >XML? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
