lulu50
asked on
help with <cfloop
Hi,
I have a multiple select box that has two values.
I need to insert my values into my table, but not sure how to do it.
My code works fine with one value in my multiple select box, but I have two values this time.
So, I need your help please.
Thanks,
Lulu
I have a multiple select box that has two values.
I need to insert my values into my table, but not sure how to do it.
My code works fine with one value in my multiple select box, but I have two values this time.
So, I need your help please.
Thanks,
Lulu
The number in the select is the segment
the name in the select is the group name
<select name="DispSelectedGroupBox" class="SearchBySelect5" id="DispSelectedGroupBox" style="background-color: #f8fafc; width: 250px; height: 100px;" size="180" multiple="multiple" sizzle-1394543330211="[object Object]">
<option value="2,A & A DRIVING SCHOOL" data-companyname="A & A DRIVING SCHOOL"></option>
<option value="2,A & A HARDWARE & AUTO SUPPLY" data-Companyname="A & A HARDWARE & AUTO SUPPLY"></option>
<option value="2,A & A MANUFACTURING INC" data-Companyname="A & A MANUFACTURING INC"></option>
</select>
<cfloop list="#FORM.DispSelectedGroupBox#" index="GroupImpacted" delimiters=",">
<cfquery name = "QGroupImpacted" datasource='#strDSN#' username='#strUID#' password='#strPWD#'>
INSERT INTO SelectedGroup (GroupName, SegmentID, IssueID, CreatedDate)
VALUES (
<cfif #form.DispSelectedGroupBox# neq ''>
<cfqueryparam cfsqltype="cf_sql_integer" value="#GroupImpacted.GroupName#">,
</cfif>
<cfif #form.DispSelectedGroupBox# neq ''>
<cfqueryparam cfsqltype="cf_sql_integer" value="#GroupImpacted.SegmentID#">,
</cfif>
#IssueIDVal#,
<cfqueryparam cfsqltype="cf_sql_date" value="#Now()#" />
)
</cfquery>
</cfloop>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent ++
ASKER
Thank you for your help!!!
It works!!! Great!!!!
Thank you again lol
Lulu