Links fail in deployed application

I have an application that works fine on the development system. A simple Grid, with a link to a Form.

In development, when I turn on SQL debug, I see this when I go from the Grid to the form.

(informix): SELECT count(*) from packaddr where shipto_code=“1001”
(informix): SELECT shipto_code, p_custname, p_addr1, p_addr2, city_state, zip, p_addr4, dis_code, sony_flag, skid_tag_watermark, shipping_lead_days from packaddr WHERE (shipto_code=“1001”) AND (shipto_code = ‘1001’) order by shipto_code

When I move the application from development, I need to change the connection from native Informix, to Informix_PDO (which works and tests out out at least initially).

I get the Grid screen OK, and it displays as I would expect. But the Form does not find any records. The debug SQL shows

(pdo-informix): SELECT count(*) from packaddr where shipto_code="1001 "
(pdo-informix): SELECT shipto_code, p_custname, p_addr1, p_addr2, city_state, zip, p_addr4, dis_code, sony_flag, skid_tag_watermark, shipping_lead_days from packaddr WHERE (shipto_code="1001 ") AND (shipto_code = ‘’) order by shipto_code

Note that in the second one, the second ‘1001’ is missing.

On your production system check register_globals and set it to off …

It is off in both systems.

Thanks for the suggestion though.

Hello,

Issue reported to our bugs team.

regards,
Bernhard Bernsmann

Ok, can you still make a test with the following .htaccess in your project directory?

php_value register_globals 0

Somehow I do not believe a bug, because I also had the problem days before and there was just a few register_globals is the problem … But, anything is possible ;-).

Sorry… server is set with allowoverrides none… :frowning:

But I have checked it by info.php from within the _lib directory where it is deployed. So this should be pretty accurate.

Nick