Dave...sorry for the lack of information, after read what I posted I thought
I should have given a little more information. My form looks like this:
<form action="#self#?fuseaction=admin.selectSongs" name="songSelect"
method="post">
<input type="text" name="week_of" size="25" maxlength="50" value="" />
This is generated from doing a read with cfdirectory
<cfloop query="songs">
<a href="songs/#name#">#name#</a> <input type="checkbox"
name="songTitle" value="#name#" />
</cfloop>
<input type="submit" name="submit_songs" value="Submit Songs" /> <input
type="reset" value="Clear Selections" />
</form>
I am passing this to:
<cfloop list="#Form.songTitle#" index="item">
<cfquery name="current_week" datasource="#dsdata#" username="myname"
password="mypwd">
INSERT INTO current_week (song_title)
VALUES ('#item#')
</cfquery>
</cfloop>
Working with mysql, song_id(pk) week_of, song_title and doc_title are all 3
varchars, I hope this enough information to get a better understanding of
what I'm trying to do. In addition to the form above, I also have a second
form setup the same way for the accompanying docs, this also built from a
cfdirectory read. I guess my main question is, since the week_of field in my
form is outside the loop, how do I handle that value? I sure hope this is
making sense to someone ;)
Thanks ...Bob
What exactly do you mean by a group of songs? More information about your
form and database schema would be helpful here.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized instruction
at our training centers in Washington DC, Atlanta, Chicago, Baltimore,
Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272291
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
