Are you wanting to insert each song into the same column?
If your fields are named something like
Song1
Song2
Song3
You can do something like this, but it would do 14 queries.
<cfloop from="1" to="14" index="I">
<cfset songName = evaluate("FORM.song" & I)>
<cfquery name="insertSong" datasource="blah">
INSERT INTO songs
(songName)
Values
'#songName#'
</cfquery>
</cfloop>
Another way to do it would be to do 14 Insert statements in the SQL.
______________________
steve oliver
cresco technologies, inc.
http://www.crescotech.com
I have 14 fields that hold the values of song titles, I need to insert
these into one column on insert. How can I accomplish this? Each song
title is associated with a album ID
There are two major products that come out of Berkeley: LSD and [Unix]
BSD. We don't believe this to be a coincidence.
Doug Brown
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
