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