I tried your code Nick and got the error "invalid number". I *think* the
values of my cfselect are comma separated, but I'm not sure how to test that.
While doing more searching in Google I came across another post from the
cf-talk mailing list which sort of relates. Borrowing some code from there
gave me this:
<cfif isDefined("form_rtpinfo.mcd")>
<cfloop index="mcd" from="1" to="#ListLen(form_rtpinfo.mcd)#">
<cfset listItem = ListGetAt(form_rtpinfo.mcd,#mcd#)>
<cfquery name="insert_mcd">
insert into RTP_MCD (RTP_ID, MCD) values (#newid.tempid#, #mcd#)
</cfquery>
</cfloop>
</cfif>
This doesn't generate any errors and allows all the data to post to the
database EXCEPT the mcd info, which just vanishes. I'm really unfamiliar with
lists in general so I don't know if I'm using the ListLen and ListGetAt
correctly. Thoughts? Or alternative methods?
PS- I really appreciate all the help I've been getting on this forum, thanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:4051
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
