Ugraded to 4.2.3 and now sql not working

romax72

I upgraded PHP to 4.2.3 and now my sql queries are not working. I already set the global variables to on to avoid that problem. However I am getting incomplete data. The right data is being returned just not all of it.

Anyone else have this issue and figure out how to fix it?

Thanks.

nightowl

the upgrade of PHP probably has nothing to do with your sql. Are you sure you run the right query with all information correct etc ?

romax72

Normally I would agree that it is the sql but since it was working before I upgraded PHP and now it is not I have to think it is the PHP. I have tried the SQL outside of PHP and it works fine.

romax72

It seems to be a limitation imposed that is 256 characters on the return data. However I am unsure why upgrading my PHP would affect my SQL Server options. Is there a setting in PHP anywhere that could be adjusted to up the limit?

Thanks.

superj

I am having the same problem. However, I know My SQL statement is working. On a page I use the echo statement to write a returned value as static text to a page and I also echo that same value in an editable text field. The static text is perfect but the editable field is only partially available. There are no field limits to the field (eg. maxlength or size). Any ideas?

Cheers.

romax72

The problem I had was that I upgraded to 4.2.3 and the php code conventions had changed. Has to do with how the sessions are handled. I could login so I made a database call but after that it would not work correctly. The ODBC connection which uses a fetch statement needed to be changed. Here is what I put in and it works fine now.

//$stat = odbc_fetch_into($this->Query_ID, ++$this->Row,
// $this->Record);
$stat = odbc_fetch_row($this->Query_ID, ++$this->Row);

I hope this works for you.