Re: mySQL/ Insert [set] problem escaping

[August Detlefsen <augustd@idiom.com>]

I just got done writing a userTag to do just that!:

# [sql_escape]Any text[/sql_escape]
#
# Escapes chars that would cause a select error
#
UserTag sql_escape HasEndTag 1
UserTag sql_escape Interpolate 1
UserTag sql_escape Routine <<EOF
sub {
        my $message = shift();
        my $message_escaped = $message;
        $message_escaped =~ s/\'/\'\'/g;
        return $message_escaped;
}
EOF

Obviously this can be adjusted to escape anything you want, but for my purposes,
replacing ' with '' does the trick...

-August
--
 mailto:augustd@idiom.com