I'd recommend not using a loop on the action page ...
change the structure of the form like this:
<input type="hidden" name="availableitems"
value="#valuelist(myquery.mycolumn)#">
<cfoutput query="myquery">
<input type="checkbox" name="hotitems"
value="#myquery.mykey#" <cfif myquery.hot>checked</cfif>>
</cfoutput>
Then on the action page
<cfquery ...>
UPDATE mytable SET
hot = CASE WHEN mykey IN (#form.hotitems#) THEN 1 ELSE 0 END
WHERE mykey IN (#form.availableitems#)
</cfquery>
Should be much more efficient.
hth
S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
> Hi everyone,
> I am developing a sales thing for our reps and I got yanked off a project
> to
> do it and my brain is fuzzy.
> I have a column that gets returned that is titled Hot (a bit field in a
> SQL
> 2K DB). This column has checkboxes that can be checked so that the DB will
> flag them for future contact. The check box contains a dual value: 1, and
> the PK. So what I would like to do is when the check box is checked, set
> the
> Hot field to 1 for that particular record. My problem is that both values
> are numbers and not text.
> I am also unsure of how to accomplish this if someone selects like 20
> checkboxes. I would need to update all associated records.
> Thanks!
> Tony
> Here is my VERY feabile attempt thus far. I just wanted to make sure the
> records were coming back correctly. I haven't started the update to the DB
> yet. So advice there would be greatly appreciated as well.
> <cfset x = ListToArray(hot, ",") >
> <CFLOOP From = "1" TO = "#ArrayLen(x)#" INDEX = "Counter">
> <cfoutput><LI> #Counter#: #ListGetAt(x, Counter)#</cfoutput>
> </CFLOOP>
> The error I get:
> Error Diagnostic Information
> An error occurred while evaluating the expression:
> #ListGetAt(x, Counter, ",")#
> Error near line 54, column 29.
>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
