On Tue, 08 Jan 2002 18:10:18 +0100, Martin Hesse wrote:
>A quoted string (that has a lot of special characters in it) is written
>to a file. Later on it is read from that file and inserted into the
>database using placeholders and bind_param.
>
>Now my problem is, that none of that quoting and metasign-substition
>disappears. e.g. don\'t is still don\'t and \n stays \n. How can I
>unquote, resubstitue, ... ???
You could enter the quoted string directly in your SQL statement.
And perhaps, but I'm not sure this will work, you could fool DBI into
believing that this field is numeric (bind it to some numerical sql_type
once), then it won't quote the data again. I haven't tested it, though.
--
Bart.
