RE: insert data

[Paul DuBois]

At 5:38 -0600 2/27/05, Gerald Preston wrote:
I just created a new table with the following:
CREATE TABLE `wolfies` (
`group_name` VARCHAR( 38 ) NOT NULL,
`me`         VARCHAR(  3 ) NOT NULL,
`daily`      VARCHAR(  8 ) NOT NULL,
`item`       VARCHAR( 60 ) NOT NULL,
`unit`       VARCHAR( 38 ) NOT NULL,
`qty`        int           NOT NULL,
`amount`     decimal(8,2) NOT NULL,
`tax`        decimal(8,2) NOT NULL,
`total`      decimal(8,2) NOT NULL
);
And get the same "Can't call method "prepare" on an un undefined value".
I suspect that means $dbh is not defined, not that $sql is undefined.
prepare() isn't being called as a method of $sql.

All the name listed are correct by looking at MySQLAdmin1.4.
my $sql = "insert into wolfies ( group_name, me, daily, item, unit, qty,
amount,
tax, total )
        values( ?,          ?,  ?,     ?,    ?,    ?,   ?,      ?,   ? ) ";
  my $sth = $dbh->prepare( $sql );
  die $dbh->errstr if $dbh->err;
What am I ding wrong?
Thanks,
Jerry
---Original Message-----
From: Gerald Preston [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 27, 2005 5:13 AM
To: 'Logan, David (SST - Adelaide)'; 'mysql users'
Subject: RE: insert data
David,
The actual code is uncommented:
my $sql = "insert into bar( group_name, me, daily, item, unit, qty, amount,
tax, total )
        values( ?,          ?,  ?,     ?,    ?,    ?,   ?,      ?,   ? ) ";
Sorry,
Jerry
-----Original Message-----
From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 27, 2005 5:09 AM
To: Gerald Preston; mysql users
Subject: RE: insert data
Hi Gerald,
If  this is copied out of your perl code then you haven't put anything
into the $sql variable. Try uncommenting the 2 lines above.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-----Original Message-----
From: Gerald Preston [mailto:[EMAIL PROTECTED]
Sent: Sunday, 27 February 2005 9:33 PM
To: mysql users
Subject: insert data
Hi!

I am trying to insert data for the first time using MySQL.  In Oracle I
used
the following:

#  my $sql = "insert into bar( group_name, me, daily, item, unit, qty,
amount, tax, total )
#                      values( ?,          ?,  ?,     ?,    ?,    ?,
?,
?,   ? ) ";
  my $sth = $dbh->prepare( $sql );
  die $dbh->errstr if $dbh->err;

  $sth->execute( $group_name, $me, $daily, $item, $unit, $qty, $amount,
$tax, $total ) || die "Cannot execute FIRST Statement!!\n$DBI::errstr";

I keep getting "Can't call method "prepare" on an un undefined value.
All
the name listed are correct by looking at MySQLAdmin1.3\4.

Any ideas?

Thanks,

Jerry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]