Interbase error code = -504 Cursor unknow
| From: | Mauricio Junqueira | Date: | Tue, 27 Mar 2001 18:22:20 +0000 |
| Subject: | Interbase error code = -504 Cursor unknow | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-45752@lists.php.net to get a copy of this message | ||
Hello, this is my first attempt to query and print a result coming from a
database, in this case interbase6.
I got the following error: InterBase: Dynamic SQL Error SQL error code =
-504 Cursor unknown in maingeral.htm on line 8
Here's the code:
<? include("php/header.php");
ibase_pconnect(BANCO,DBUSER,DBPASSWD)
or die ("<script language='javaScript'> alert('" . ibase_errmsg()
.
"'); </script>");
$stmt = "select count(*) from soldcars";
$query = ibase_query($stmt) or die ("<script
language='javaScript'>alert('" . ibase_errmsg() . "');
</script>");
$result = ibase_fetch_row($query); // THIS IS LINE 8
$TOTSOLD = $result;
ibase_free_result($query);
$stmt ="select Total from monthsold";
$query = ibase_query($stmt) or die ("<script
language='javaScript'>alert('" . ibase_errmsg() . "');
</script>");
$result = ibase_fetch_row($query);
$TOTMONTH = $result[0];
ibase_free_result($query);
$stmt = "select count(*) from deal where available = 1";
$query = ibase_query($stmt) or die ("<script
language='javaScript'>alert('" . ibase_errmsg() . "');
</script>");
$result = ibase_fetch_row($query);
$TOTAVAIL= $result[0];
ibase_free_result($query);
ibase_commit();
ibase_close();
?>
I have 3 query blocks. the result shows the contents of 2nd and 3rd block
variable:TOTMONH and TOTAVAIL but nothing from the first block, TOTSOLD.
If I comment the first block entirely, I got the same error
(ibase_fetch_row line) on the 2nd block and the only result that appear is
from the 3rd block.
What I am doing wrong?
I've put this statement before the first block to see if $query was empty
but the statement return true and the same error occured in the
ibase_fetch_row line and the echo $query shows everytime Resource id#4
if (isset($query)) {
echo($query);
$result = ibase_fetch_row($query);
$TOTSOLD = $result;
ibase_free_result($query);
} else echo "query not set";
If just comment the following lines, everything works.... Please help...
I'm getting nut !!
<? include("php/header.php");
ibase_pconnect(BANCO,DBUSER,DBPASSWD)
or die ("<script language='javaScript'> alert('" . ibase_errmsg()
.
"'); </script>");
$stmt = "select count(*) from soldcars";
$query = ibase_query($stmt) or die ("<script
language='javaScript'>alert('" . ibase_errmsg() . "');
</script>");
// $result = ibase_fetch_row($query);
// $TOTSOLD = $result[0];
// ibase_free_result($query);
$TOTSOLD ="COMMENTED";
$stmt ="select Total from monthsold";
$query = ibase_query($stmt) or die ("<script
language='javaScript'>alert('" . ibase_errmsg() . "');
</script>");
$TOTMONTH = $result[0];
ibase_free_result($query);
$stmt = "select count(*) from deal where available = 1";
$query = ibase_query($stmt) or die ("<script
language='javaScript'>alert('" . ibase_errmsg() . "');
</script>");
$result = ibase_fetch_row($query);
$TOTAVAIL= $result[0];
ibase_free_result($query);
ibase_close();
?>