This content has been marked as final. Show 4 replies
Ok, I'm not quite sure what you are doing here. You are doing a comparison of the field to see if it is equal to a specific value?
If you have a comma delimited value why not do something like this
<cfif listFind(getRSM.Username, 'T-03')>
> I have a record set that returns 2 records
Try a slight variation ..
<cfset userNameList = valueList(getRSM.UserName)>
<cfif listFindNoCase(userNameList, "T-03") gt 0>
Mike - If you have a recordset that returns individual records use the valueList function to get the recordset into a comma delimited list. If you are returning a comma delimited field of values than you don't need to use the valueList.
Thank you so much! I'm a ASP to CF newb and I played around with ValueList and could not get it right. I had four different versions of this going to see what would work, a loop, a query output, you name it I tried it but thank you very much ... swhoo!