> First off...shouldn't you all be out doing something other
> than working? ;-) Since you're not out somewhere having way
> too much fun, I could use some enlightenment here.
> I have a form passing multiple values via some checkboxes, I
> think I've got the insert down ok for that with the
> following: I'm working with MySql and the week_of field I
> have set to unique in the db.
>
> <cfloop list="#Form.songTitle#" index="item">
> <cfquery name="current_week" datasource="#dsdata#" username="me"
> password="mypwd">
> INSERT INTO current_week (song_title)
> VALUES ('#item#')
> </cfquery>
> </cfloop>
>
> My question comes in with a form field that only needs to be
> inserted once for each group of songs, this value is also
> being passed via the form, how would I go about handling
> this? To muddy this up a tad more, I have a second for that
> handles song docs that need to be inserted and associated
> with the week_of insert from the first insert statement. Any
> help would of course be greatly appreciated! I work alone so
> my only source for feedback/help/direction is this and a few
> other lists.
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!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 &
Flex 2.
Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272287
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
