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/