valuelist issue 2

[GUJUm0deL]

I am using valuelist to put all values in a query into a list, but for some reason I the list returns:

one ,two ,three ,four ,five ,etc...

Why is there a space then a comma? The space shouldn't be there...


____________________________________
Just Imagine.

http://www.imajinarts.com

 

[joepeacock]

listfindnocase() is what you want, but the syntax is switched from findnocase().

try this:

<cfloop list="#FAList#" index="i" delimiters="|,">
 [color=red]<cfif listfindnocase(badwordslist,i)>[/color]
  <!--- if badwords found, increment by one --->
  <cfset badWordsstatus = badWordsstatus + 1>
 </cfif>            
</cfloop>

Joe

 

[joepeacock]

never mind the [color] part of that - my TGML was bad. try this:

<cfloop list="#FAList#" index="i" delimiters="|,">
 [COLOR=red]<cfif listfindnocase(badwordslist,i)>[/color]
  <!--- if badwords found, increment by one --->
  <cfset badWordsstatus = badWordsstatus + 1>
 </cfif>            
</cfloop>

 

[GUJUm0deL]

I think I have it working. I'll let all you guys know on Monday. *Cross fingers*


____________________________________
Just Imagine.

http://www.imajinarts.com

 

[GUJUm0deL]

Eureka!! It works now. This is the entire code for the badwords script.

<!--- gets all the badwords from the badwords table --->
  <cfquery name="badwordscheck" datasource="#default_ds#">
    SELECT RTRIM(BadWords) as BD
    FROM BadWordsTable
  </cfquery>

<!--- creates a list of the 'badwords' --->
	<cfset badwordslist = valuelist(badwordscheck.BD)>
<!--- sets badwordsstatus to 0 intially --->
	<cfset badWordsstatus = 0>
<!--- creates var to store badwords --->
	<cfset listMatches = "">
	
    <cfoutput>
	  <cfloop index="FAListIndex" from="#listfirst(fields)#" to="#listlast(fields)#">
		<cfset FAList = listappend(FAList,trim(getAnswers.FormAnswer))>
		<cfset FAList = Replace(FAList," ",",","ALL")>
		  <cfloop list="#FAList#" index="i" delimiters="|,">
    		<cfif listFindNoCase(badwordslist, i)>
      	<cfset listMatches = listAppend(listMatches,i)>
				<cfset badWordsstatus = badWordsstatus + 1>
    		</cfif>			
		  </cfloop>
		<cfset FAList = "">
	  </cfloop>	
	</cfoutput>

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[GUJUm0deL]

Sorry, hit "SUBMIT" too fast.

I wanna thanks everyone for helping me out on this. This is the entire bad words script:

<!--- gets all the badwords from the badwords table --->
  <cfquery name="badwordscheck" datasource="#default_ds#">
    SELECT RTRIM(BadWords) as BD
    FROM BadWordsTable
  </cfquery>

<!--- creates a list of the 'badwords' --->
	<cfset badwordslist = valuelist(badwordscheck.BD)>
<!--- sets badwordsstatus to 0 intially --->
	<cfset badWordsstatus = 0>
<!--- creates var to store badwords --->
	<cfset listMatches = "">
	
    <cfoutput>
	  <cfloop index="FAListIndex" from="#listfirst(fields)#" to="#listlast(fields)#">
		<cfset FAList = listappend(FAList,trim(getAnswers.FormAnswer))>
		<cfset FAList = Replace(FAList," ",",","ALL")>
		  <cfloop list="#FAList#" index="i" delimiters="|,">
    		<cfif listFindNoCase(badwordslist, i)>
      		  <cfset listMatches = listAppend(listMatches,i)>
		    <cfset badWordsstatus = badWordsstatus + 1>
    		</cfif>			
		  </cfloop>
		<cfset FAList = "">
	  </cfloop>	
	</cfoutput>

____________________________________
Just Imagine.

http://www.imajinarts.com