A client wants me to extract data from his relational database into a
text file. The database contains information about movies, and he wants
one line per movie. I do not know how to flatten the data. For example,
say these are the tables and fields:
Movies: MovieID, MovieName
Genres: GenreID, GenreName
MoviesGenres: MovieID, GenreID
And suppose the movie "Wild West" falls into genres Drama, Romance, and
Western.
The client wants the single line for this movie to look like:
Wild West, Drama, Romance, Western
Any suggestions?
Thanks.
-David
________________________________________________________________
GET INTERNET ACCESS FROM JUNO!
Juno offers FREE or PREMIUM Internet access for less!
Join Juno today! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
