> 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
>
> --
I tried doing this on my last run of data but things still got shifted
over by the quotes when I look at the actual data. It's kind of strange,
when I run the same bit of code on some test info, it seems to work fine
(nothing is shifted) but when I run it against a larger set of data, only
the records that contain quotes seem to screw things up.
Also, I know this is most likely a stupid question but when you do a
select on the information you just stored, will the quotes mess up things if
you do something like this (this is after setting up the query, preparing
and then executing it) :
($field1,$field2,$field3,$field4,$field5) = $sth6->fetchrow;
Jessee
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
