I'm using placeholders like this: (using Perl) $stmt .= "," if $stmt; $stmt .= $f->{t_name} . " = ?"; my $temp_value_holder = $f->{value}; $temp_value_holder =~ s/\,/\;/g; push (@placeholder, $temp_value_holder);
The reason I'm using a temp value then switching the commas with ; is because the syntax for the placeholders is using commas. the strings might contain commas, which throws the whole thing off. Is there a way to LEAVE the commas? Does MySQL recognize escapes if I where to switch the commas with an Escaped comma? or is there another way to do it? Thanks, Richard