|
|
cf_dev, thanks for pointing it out. The query is not the problem. Its because
of the list i'm creating.
Here is the list creation part:
<cfset value1 = #ValueList(wall.myID,",")#>
<cfset value2 = #ValueList(wall.profileID,",")#>
<cfset valueCombined = value1 & "," & value2>
<cfoutput>#valueCombined#</cfoutput>
<cfset commaReplaceOne = "#URL.id#,">
<cfset commaReplaceTwo = ",#URL.id#">
<cfset new_replaced = #ReReplace(valueCombined, commaReplaceOne, "", "ALL")#>
<cfset final_id = #ReReplace(new_replaced, commaReplaceTwo, "", "ALL")#>
Notice how value1 and value2 are being generated by the query. Thats, when
things going bad.
|
|