When you submit a form with multiple entries under the same inoput name
(checkboxes, multiple select, etc) it should create a comma separated list
for that value. (value1,value2,value3)
In your first example it looked like you wanted to save the form, and ALL
values to One database entry.
In your second example you are generating multiple database entries.
Neither is wrong or right - it just depends on how you want to use the
data.... Do you have a preference?
I think my example may have "broken" because of the newID you are setting -
you could try this:
<!--- assign new project an id_number... --->
<cfquery name="newid" maxrows="1">
SELECT RTP_MASTER_SEQUENCE.NEXTVAL AS TEMPID FROM DUAL
</cfquery>
<cfset ThisNewID = #newid.tempid #>
<cfquery name="insert_mcd">
insert into RTP_MCD
(RTP_ID, MCD)
values
('#ThisNewID#', '#mcd#')
</cfquery>
If that doesn't work - check what your form is actually passing <cfdump
var="#FORM#"> You may find out it's not submitting what you think it is.
- Nick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4052
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
