On Oct 29, 12:31 pm, [EMAIL PROTECTED] (Dr.Ruud) wrote:
> "Beginner" schreef:
>
> > I am trying to insert a lots file paths into an SQLite table and am
> > having trouble with filenames with apostrophes in.
>
> Use placeholders,
Good advice.
> so prepare/execute.
irrelevant advice, nothing to do with the problem at hand. There is
no reason to alter the OP's method of using selectrow_array.
my ($val) = $dbh->selectrow_array("SELECT foo FROM bar WHERE id = ?",
undef, q{stuff'with'quotes'});
http://search.cpan.org/~timb/DBI-1.601/DBI.pm#selectrow_array
Paul Lalli
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
