why would you convert a list to an array then convert it back to a list
again?
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-----Original Message-----
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 12:01 PM
To: CF-Talk
Subject: RE: Array Help - SOLVED
I figured it out. Just FYI:
<cfset x = ListToArray(hot, ",") >
<cfset y = ArrayToList(x,",")>
<CFLOOP From = "1" TO = "#ArrayLen(x)#" INDEX = "Counter">
<cfoutput><LI> #Counter#: #ListGetAt(y, Counter)#</cfoutput>
</CFLOOP>
-----Original Message-----
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 2:28 PM
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.
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.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
