I have a drop drop where i SELECTING MULTIPLE values and I want to insert those
values into the column
here is my code but it is only inserting 1 value rather than a list
<cfif isDefined("form.btnAdd")>
<cfloop index="i" from="1" to="#ListLen(form.foundOn)#">
<cfset listItem = ListGetAt(form.foundOn,i)>
<cfquery name="addTopMenu" datasource="cfelsunrise" dbtype="ODBC">
insert into dbo.Menu values ('#form.topLevel#','#form.txtAreaDesc#',
'#listItem#','NULL')
</cfquery>
<cflocation url="#cgi.script_name#">
</cfloop>
</cfif>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299413
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
