Is this an MX thing or an sql thing.
I did a trace on the query, and the string was being passed in as
('tom,bill,jim') as oppossed to ('tom','bill','jim').
This list is actually be generated by a client side _javascript_ app, which then posts the data to CF.
Inside a loop doing I doing this,
there is evaluation happening which then just puts names to a comma deliminated list
if(field_str!=''){field_str+=','+h[i].value}else{field_str=h[i].value}
//check if the variable is not empty and add to hidden field
if(field_str!=''){
d.value=field_str;
}
on alert the string effectively looks like this, tom,bill,jim
so get the single quotes in i tried this,
if(field_str!=''){field_str+=','+"'"+h[i].value+"'"}else{field_str="'"+h[i].value+"'"}
but in the trace file the sql trace then shows this,
(''tom','bill','jim'').
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
