You are executing, $dbobj the database object. You should execute the statement
handle.
The code should be:
$query = "SELECT UserID,Name FROM test";
$sdb = $dbobj->prepare($query);
$sdb->execute();
Placed At :
"Clinton Hesse" <[EMAIL PROTECTED]> on 01/01/2002 03:21:15 AM
To: [EMAIL PROTECTED]
cc: (bcc: Durga Prasad/Satyam)
Subject: Execute Error
It's funny, i can call method prepare on the database object but not
execute, error on line 3.
1. my $query = "SELECT UserID,Name FROM test";
2. my $sdb = $dbobj->prepare($query);
3. $dbobj->execute;
where $dbobj is a reference to the database object
I get error
Can't locate object method "execute" via package "DBI::db" (perhaps you
forgot to load "DBI::db"?)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
