Re: Execute Error

2002-01-01 Thread Durga_Prasad



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


Re: Execute Error

2001-12-31 Thread Brent Cowgill

try $sdb-execute()

Clinton Hesse wrote:

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




-- 
Regards,
Brent

interactivetools.com, inc.
Tel: (604)689-3347 - Fax: (604)689-3342 - Toll Free: 1(800)752-0455
Software for your Website - http://www.interactivetools.com/  

Attachments accepted: TXT, HTML, RTF, PDF 
I do not accept attachments which are capable of harbouring viruses, 
for example Word for Windows. Please use File/Save As RTF or HTML.





-
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