Hi folks-
Apologies in advance if this is a dumb question, but I have more experience with mysql...
I have a redhat 6.2, informix 7.30, php 4 setup that seems to be working. I am trying (at this point) to create a db table browser. I can use the setup to query the informix.systables table to get a list of all the tables in a particular db, but when I issue a simple select command (like 'select * from table1'), something seems to be prepending the username (specified as the 2nd argument in the ifx_connect function) to the table generating a query like 'select * from username.table1' at which point the DB responds with a table (username.table1) does not exist error. If I use an illegal username or database name, I get the expected error messages from the DB.
The phpinfo() printout looks fine as well.
I suspect that the problem is one of configuration, but I cannot figure this out (the Informix docs are horrid). I cannot see why the username is getting prepended, and I have searched the web for a day looking for an answer but to no avail...
tia,
dave
Apologies in advance if this is a dumb question, but I have more experience with mysql...
I have a redhat 6.2, informix 7.30, php 4 setup that seems to be working. I am trying (at this point) to create a db table browser. I can use the setup to query the informix.systables table to get a list of all the tables in a particular db, but when I issue a simple select command (like 'select * from table1'), something seems to be prepending the username (specified as the 2nd argument in the ifx_connect function) to the table generating a query like 'select * from username.table1' at which point the DB responds with a table (username.table1) does not exist error. If I use an illegal username or database name, I get the expected error messages from the DB.
The phpinfo() printout looks fine as well.
I suspect that the problem is one of configuration, but I cannot figure this out (the Informix docs are horrid). I cannot see why the username is getting prepended, and I have searched the web for a day looking for an answer but to no avail...
tia,
dave