- Original Message -
From: "david" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 02, 2002 10:15 AM
Subject: Re: Insertion and Quotes
> Jessee Parker wrote:
>
> >
> > I tried doing this on my last run of data but things
Jessee Parker wrote:
>
> 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 again
> 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
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.
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 w
