Count <cfselect> values

Report · Nov 01, 2009

Good evening all,

I have two <cfselect>s in my form, I want to count how many values the user select and save that count to my database. Anyone seen this before? I would like to accomplish this, any help is very welcome.

Thanks,

DJ Khalif

Report · Nov 01, 2009

Remember the cfselect attribute multiple="yes", which enables a user to select multiple items!

Report · Nov 01, 2009

Suppose the fields are called select1 and select2. You could, in the action page, do something like listLen(form.select1)+listLen(form.select2). After all, a multiple selection will produce a comma-delimited list.

Report · Nov 01, 2009

BKBK,

Thanks. I do have another question:

How do I INSERT that list into SQL with same ID number for each item in list that is the same as the ID of the main table?

Thanks,

djkhalif

Report · Nov 01, 2009

insert into yourtable (id, otherfield)

select 1, ''

from some_small_table where 1 = 2

union

select distinct #id_variable#, '#something#'

from some_small_table

closing tags

Report · Nov 02, 2009

Dan,

This is my "INSERT" Code:

<cfquery name="finalInspectionInsert" datasource="#REQUEST.datasource#">
INSERT INTO tbl_FinalInspAttr (DateInsp, INspby, WorkOrder, Total_Insp, Total_Defective, Total_Defects, Notes, Fitem, Model, Battery_Type, Cells, NoPlates)
VALUES('#Trim(FORM.DateInsp)#',
'#Trim(FORM.Inspby)#',
 '#Trim(FORM.WorkOrder)#',
 '#Trim(FORM.Total_Insp)#',
 '#Trim(FORM.Total_Defective)#',
 '#Trim(FORM.Total_Defects)#',
 '#Trim(FORM.Notes)#',
 '#Trim(FORM.Fitem)#',
 '#Trim(FORM.Model)#',
 '#Trim(FORM.Battery_Type)#',
 '#Trim(FORM.Cells)#',
 '#Trim(FORM.NoPlates)#')
</cfquery>

<cfquery name="finalDefects" datasource="#REQUEST.datasource#">
INSERT INTO tbl_Final_Defects (ID, Unit, DefectCode)
SELECT ID, '#Trim(FORM.Unit)#', '#Trim(FORM.DefectCode)#'
FROM tbl_FinalInspAttr
WHERE tbl_FinalInspAttr.WorkOrder = '#FORM.WorkOrder#'
<cfloop list = "#FORM.UNIT#" index="j">
UNION
SELECT DISTINCT #UNIT#, '#j#'
FROM tbl_DefectTypes
</cfloop>
</cfquery>

Report · Nov 02, 2009

Dan,

This is my Confirmation Page. The use will see this for proceding to action (INSERT) page.

<cfquery name="rsItemLU" datasource="#REQUEST.datasource#">
SELECT i.Item, i.Model, i.Model_Adder, i.Type, i.Plates, i.Cells
FROM tlkp_Item AS i INNER JOIN
 tbl_Assembly_Production AS p ON p.Item = i.Item
WHERE (p.WorkOrder = '#FORM.WorkOrder#')
GROUP BY i.Item, i.Model, i.Model_Adder, i.Type, i.Plates, i.Cells
</cfquery>
<cfset list1 = "#FORM.total_defective#">
<cfset list2 = "#FORM.total_defects#">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><cfoutput>#REQUEST.companyName#</cfoutput></title>
<link rel="shortcut icon" href="/images/favicon.ico">
<link href="/finalCut.css" rel="stylesheet" type="text/css" />
<cfset copyRight = DateFormat(now(), 'yyyy')>
</head>

<body>

Date Inspected:<cfoutput>#DateFormat(FORM.DateInsp, 'mm/dd/yyyy')#</cfoutput>
 
Work Order:<cfoutput>#FORM.WorkOrder#</cfoutput>
 
Inspected by:<cfoutput>#FORM.inspBy#</cfoutput>
 
<cfoutput>#FORM.inspectedByName#</cfoutput>
 
Total Inspected:<cfoutput>#FORM.Total_Insp#</cfoutput>
 
Total Defective:<cfoutput>#ListLen(FORM.total_defective)#</cfoutput>
 
Total Defects:<cfoutput>#ListLen(FORM.total_defects)#</cfoutput>
 
Comments / Notes:<cfoutput>#FORM.notes#</cfoutput>
<h3 style="font:Trebuchet MS; font-size:12px;">Battery Description</h3>
<cfif isDefined ("form.WorkOrder")>

<cfoutput query="rsItemLU">
Item: #Item# 
Model: #Model# 
Adder: #Model_Adder# 
Type: #Type# 
Cells: #Cells# 
Plates: #Plates#
</cfoutput>
</cfif>
<cfif listlen(list1) gt 0>
<cfloop from="1" to="#listlen(FORM.Total_Defective)#" index="j">
<cfoutput>#listGetAt(FORM.Total_Defective, j,",")# </cfoutput>
</cfloop>
 
<cfloop from="1" to="#listlen(FORM.Total_Defects)#" index="k">
<cfoutput>#listGetAt(FORM.Total_Defects, k,",")#</cfoutput>
</cfloop>
</cfif>

Report · Nov 02, 2009

Are you storing the list FORM.total_defective into a database column? That is usually to be avoided.

Adobe Community

Count <cfselect> values

1 Correct answer