The list. What is that datatype your passing the list to? Is it an numeric
based or string? If it is a string (char, varchar, ntext, nvarchar, memo,
whatever) then those numbers cause an exception. You can use the ListQualify
method. It Inserts a string at the beginning and end of list elements. The
"string" in your case will be a single quote

<cfset qualifiedList1 = ListQualify(myList,"'",",","ALL")>



"pambg" <webforumsuser@macromedia.com> wrote in message
news:cuqgnb$6s8$1@forums.macromedia.com...
> No, I wish it was but it's more to do with the variable I listed up the
> top and
> referencing it in the query. I works fine on my old server and older
> version
> of CF but for some reason it doesn't like the ## or just the reference in
> general. I'm totally LOST!
>