on Tue, 01 Oct 2002 17:55:21 GMT, Jessee Parker wrote: > I'm a bit confused on why this is happening and I'm hoping > someone can > shed some light on things for me. I read in information from a file > which is comma delimted and I use the parsing routine I found in the > Perl Cookbook. When it hits a name with " marks around it, it shifts > everything over when doing the insert. I have put escape characters > in the data before insertion for both quotes and apostrophes and when > I run it with w single entry, it inserts correctly. When run on a > longer list, the line that has the name in quotes shifts everything > over by one during the insertion. I'm using MySQL as the database. > Thanks in advance!
Use placeholders and your quoting troubles will be over forever ;-) E.g.: my $sql = "INSERT INTO atable VALUES (NULL, ?, ?)"; my $sth = $dbh->prepare($sql); $sth->execute($a_var, $another_var_with_embedded_quotes); -- felix -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]