Hi,

I am using mod_perl and MySQL 3.23.38 on Red Hat Linux
6.2 and my following codes occasionally got an error.

   $SQL = 'SELECT col1,col2 FROM table1'.
          ' WHERE keya=1 AND keyb=2';
   $STH = $DBH->prepare($SQL) || die $SQL;
   if ($STH->execute() >= 1) {
       $rec = $STH->fetchrow_hashref;
       $STH->finish();
   }

The error was:

DBD::mysql::st fetchrow_hashref failed: fetch()
without execute() at program-name line ####.

It only happened once in a few dozen transactions.  If
 anyone knows the cause of this and knows the solution
for it, please let me know.

Thank you very much in advance.

Truoc Duong.

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

---------------------------------------------------------------------
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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to