Sorry if my original message is hard to get, just try running this code in a test page. Are the results as expected? What's wrong here?
<cfset codes="siteMinute,siteNews,site,siteSpin,mi,os,ol,mn,siteHome"> <cfset Vehicles="siteMinute,siteNews,siteSpin"> <cfloop list="#codes#" index="i"> <cfoutput><input class=text type="checkbox" name="#i#" <cfif ListContains("#Vehicles#", "#i#")>checked</cfif>> #i#<br></cfoutput> </cfloop> Mark Kecko The Computer Guy MediaPost Communications [EMAIL PROTECTED] http://www.mediapost.com (203)222-0330 ext309 "Imagination is the one weapon in the war against reality." Jules de Gaultier -----Original Message----- From: Mark M. Kecko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 12:32 PM To: CF-Talk Subject: ListContains NOT functioning properly - Help! Help! When I'm looping over a list Campaign.Vehicles that's coming from a SQL table varchar field I'm getting strange results from ListContains. Looping over Vehicles.code= "siteMinute,siteNews,site,siteSpin,mi,os,ol,mn,siteHome" - several rows from a database call. Campaign.Vehicles="siteMinute,siteNews,site,siteSpin" - a 'static' database record. When Vehicles.code = "SiteSpin" the below "ListContains("#Campaign.Vehicles#", "#Vehicles.Code#")" returns 4. <cfloop query="Vehicles"> <input class=text type="checkbox" name="#Vehicles.Code#" <cfif ListContains("#Campaign.Vehicles#", "#Vehicles.Code#")>checked</cfif>> #Vehicles.Name#<br><br> </cfloop> Actual output to screen from testing: Campaign.Vehicles: siteMinute,siteNews,site,siteSpin Vehicles.Code: siteSpin ListContains - 4 As far as I can see from the output above siteSpin is only in the list Campaign.Vehicles once. Can anybody see something I can't. I've tried specifying the delimiter as a comma, changing the delimiter to a ~, setting the database field to a variable, changing the delimiters of that variable and I've tried all of those things with ListContainsNoCase as well. I've even tried changing the datatype of my SQL database field to nvarchar, ntext etc! Please help, this is holding up a very profitable ad campaign from being served on my site! Mark Kecko The Computer Guy MediaPost Communications [EMAIL PROTECTED] http://www.mediapost.com (203)222-0330 ext309 "Imagination is the one weapon in the war against reality." Jules de Gaultier ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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