David,
The way I would approach this is to write a query and then use CFFile to
write your output to a text file. You can do an output to screen first
and if it looks like what you want, then do the file write.
Chris Montgomery [EMAIL PROTECTED]
Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner
210-490-3249/888-745-7603 Fax 210-490-4692
>-----Original Message-----
>From: David Shadovitz [mailto:[EMAIL PROTECTED]]
>Sent: Sunday, November 19, 2000 2:49 PM
>To: CF-Talk
>Cc: [EMAIL PROTECTED]
>Subject: OT: Flattening a relational database
>
>
>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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
