Replace or concatenate? 1

[mochalova]

Hello Folks,

does anyone know how I can change this

SOH01123,SOH01146,SOH01141,SOH01185

to

SOH01123','SOH01146','SOH01141','SOH01185

Thanks

 

[LyndonOHRC]

Try:

<cfset myList=ListChangeDelims(MyList,"','",',')>

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[mochalova]

Lyndon,

Thanks a million, worked perfectly.

 

[cfSearching]

mochalova,

I am not sure what you are doing with the results. But if you are using the values in a SQL statement, consider using cfqueryparam with the "list" attribute instead. Then no quotes are needed.

(Untested)

<cfquery...>
SELECT Columns, .... 
FROM   SomeTable
WHERE  SomeColumn IN 
(
     <cfqueryparam 
         value="SOH01123,SOH01146,SOH01141,SOH01185"
         cfsqltype="cf_sql_varchar"
         list="true" >
)
</cfquery>

----------------------------------

http://cfsearching.blogspot.com/