Error MSG -410 while executing a select with ifx_query on a informix database on linux
| From: | Robert Hennig | Date: | Tue, 22 May 2001 13:03:13 +0000 |
| Subject: | Error MSG -410 while executing a select with ifx_query on a informix database on linux | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9526@lists.php.net to get a copy of this message | ||
Hi!
We use a informix IDS2000 server on a linux machine together with php 4.05
on Apache. As a test we wrote the following script:
<?php
$conn_id = ifx_connect("unipps","informix","sqLOpen");
if (! $conn_id)
{
echo "connection failed";
}
$ergebnis = ifx_query("select ident_nr from personal", $conn_id);
if(! $ergebnis)
{
echo "selection failed";
}
ifx_htmltbl_result($ergebnis, "border=\"2\"");
ifx_free_result($ergebnis);
echo $ergebnis;
echo $conn_id;
?>
The connect seems to work, because we get a syntax error if we use a wrong
field-name in the select. We receive the following error when executing this
script:
Warning: Describe fails (E [SQLSTATE=37 000 SQLCODE=-410]) in
/v/u/robert/public_html/datenbank.php on line 8
(line 8 is the line $ergebnis = ifx_query("select ident_nr from personal",
$conn_id);)
What wents wrong?
Robert