I've got a dynamicly created selection in a Multi select combo box, the
values are all numeric. I want to be able to get the count so that I can
insert each selection in to a database.
Explanation:
At form you can select mutipuls selections in multi combo box.
On submit the process page will get number of selections so that I have a
max number for a CFLOOP so that each selection will be inserted in as a
seperate record.
Code Example:
<cfset mylist = "#FORM.DIS_SITE_ID#">
<cfset count = ListValueCount(mylist, value)> <!--Not sure what the value in
the listvaluecount needs to be--->
<cfloop index="siteid" from="1" to="#count#">
<cfoutput>
<cfquery datasource="#dsn#">
Insert into SITE_ON_STUDY_T
( STUDY_ID,
EVENT,
DIS_SITE_ID,
<CFIF isdefined("OTHER_SITE") AND len(trim(OTHER_SITE)) neq
0>OTHER_SITE,</CFIF>
UserId,
CREATE_DATE )
Values
( #Study_Id#,
1,
#siteid#,
<CFIF isdefined("OTHER_SITE") AND len(trim(OTHER_SITE)) neq
0>'#metastasis_site_other#',</CFIF>
#cookie.userid#,
#createODBCdatetime(now())# )
</cfquery>
</cfoutput>
</cfloop>
Any thoughts?
Thanks in advance
Ernie Pena
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
