And, in case you're still fuzzy, it's no longer a list because of the call to ListToArray().
-- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 2:49 PM > To: CF-Talk > Subject: RE: Array Help > > > by the time you get to here #ListGetAt(x, Counter)#, x is no longer a list > > Ade > > -----Original Message----- > From: Tony Carcieri [mailto:[EMAIL PROTECTED]] > Sent: 25 September 2002 19:28 > To: CF-Talk > Subject: Array Help > > > 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. > > > ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists