Remove item from ValueList?

Folks, too many people make use #xxxxx# when it's totally unnecessary, it's inefficient and it's harder to read.

THIS

<CFSET test=QuotedValueList(getPerson.id,",")>
<CFSET deletePosition=listfind(variables.test,"'1232'")>
<CFSET test=listDeleteAt(variables.test,variables.deletePosition)>

NOT

<CFSET test=#QuotedValueList(getPerson.id,",")#>
<CFSET deletePosition=#listfind(variables.test,"'1232'")#>
<CFSET test=#listDeleteAt(variables.test,variables.deletePosition)#>

General rule, if you're not displaying it you probably don't need ##. If you aren't displaying it but it's inside quotes then you probably need it
e.g. <CFSET firstlast = "#RTrim(firstname)# #RTrim(lastname)#">
although an alternative is
<CFSET firstlast = Trim(firstname) & " " & Trim(lastname)>

Ways to improve on the existing answer.

1. If possible, strengthen the where clause of your first query so the value list has only the items you want.
2. In the 2nd query, use cfqueryparam list="yes". Then you can use a normal value list and not have to worry about quotes.

Then you need to also replace the quotes, not just the characters
between them

#Replace(variables.test,"'12321'","","all")#