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

Hi Robert, isql comes from (I)nformix (S)trutured (Q)uery (L)anguage. It's similar to your sql-editor. I use the SE Database engine and not the Dynamic Server like yourself. Whether this has anything to do with it I don't know but I did run your code on my server just to make sure it ran properly and I hadn't missed something. Obviously, changing the database connection and select field and table. Can you post the exact output of the page, not the html source? Regards, - Paul - ----- Original Message ----- From: "Robert Hennig" <R.Hennig@knoll-is.de> To: <php-db@lists.php.net> Sent: Tuesday, May 22, 2001 3:40 PM Subject: Re: [PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux > Hi Paul, > > thanks for your fast reply. Maybe you could help me again :-) We are working > a lot with informix, so we thought to know every Programm, but isql is > completely unknown. Is this a special programm? > > We have executed this select with a sql-editor on the server also as with > dbaccess, on both it works. > > Thanks.... > > Robert > > ""Paul Gardiner"" <paul.gardiner@barleychalu.co.uk> schrieb im > Newsbeitrag > news:001201c0e2ca$730d0c40$0200a8c0@PDG... > > 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 - > > > > > -- > 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 > >