> 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>
This is a bit off your point, but why do you have links in there? If someone
clicks on one of the links, they'll leave your form without finishing it.
> 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 ;)
I'm not sure what you're doing with "week_of", but it doesn't matter whether
the field is inside or outside your loop if you only want it to have one
value. In your action page, you'll have "week_of" along with "songTitle".
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 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272294
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
