RE: Error on: my $sth->execute;

2005-07-18 Thread Christian, Ed
> -Original Message- > From: Ron Smith [mailto:[EMAIL PROTECTED] > Sent: Monday, July 18, 2005 12:50 PM > To: Perl > Subject: Error on: my $sth->execute; > > > Hi all, > > I'm getting an error when trying to do an INSERT statement to > a

Re: Error on: my $sth->execute;

2005-07-18 Thread Ron Smith
--- Lawrence Statton <[EMAIL PROTECTED]> wrote: > > --0-551411304-1121705388=:507 > > Content-Type: text/plain; charset=iso-8859-1 > > Content-Transfer-Encoding: 8bit > > > > Hi all, > > > > I'm getting an error when trying to do an INSERT > statement to a MySQL databas > > e. There's something

Re: Error on: my $sth->execute;

2005-07-18 Thread Adriano Ferreira
On 7/18/05, Adriano Ferreira <[EMAIL PROTECTED]> wrote: > Beware of the difference of double and single quotes in Perl. Double > quotes interpolate: Oops. That's my mistake. Your single quotes are within double quotes. Let's try again. I would say that something is wrong here: my $sth = $dbh

Re: Error on: my $sth->execute;

2005-07-18 Thread Adriano Ferreira
On 7/18/05, Ron Smith <[EMAIL PROTECTED]> wrote: > my $sql = "INSERT INTO products VALUES ('$sku', '$partNum', '$name', > '$descr', '$stockNum', '$qty', '$img', 'vendNum', '$price')"; Beware of the difference of double and single quotes in Perl. Double quotes interpolate: $a = 3; print "a: $a\n"

Error on: my $sth->execute;

2005-07-18 Thread Ron Smith
Hi all, I'm getting an error when trying to do an INSERT statement to a MySQL database. There's something I'm not understanding here. Can anyone point me in the right direction? I also tried a "do" method, but got the same error. I know the "param" function is loading the values from the form,