Re: Error MSG -410 while executing a select with ifx_query on a informix database on linux

Hi Robert, Your test code is correct although you could do with an ifx_close($conn_id); at the end. Have you tried running isql(assuming you've got it) and just trying to run the query from there? Regards, - Paul - "Robert Hennig" <R.Hennig@knoll-is.de> wrote in message news:9ednu0$p93$1@toye.p.sourceforge.net... > 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 > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >