Sybase array result problems-- help!!

From: Date: Mon, 17 Jul 2000 20:49:04 +0000
Subject: Sybase array result problems-- help!!
Groups: php.db php.dev 
Request: Send a blank email to php-db+get-1213@lists.php.net to get a copy of this message
We're currently developing a web-based php database application and are experiencing problems while fetching rows from Sybase. The array result values seem to change whenever the page is refreshed. Occassionally, the proper results will be displayed, but an additional page refresh often leads to different array values. The results often appear random, or are the contents of other array elements pulled from the database. For example, a lastname field in the returned array may contain numbers stored elsewhere in the database as opposed to actual last names. Looking over the list of reported bugs, we noticed that there are currently outstanding issues associated with the db-lib (which is what we are currently running on a unix box along with Apache). The same code worked fine over an odbc connection on a PC running Win98, PWS and an MS Access back-end, which is what led us to question Sybase. We were also able to locate several other developers who stated similar problems, as in Bug Report 5439 and 5637. We're thinking of switching over to the ct-lib which seems to be the consensus until db-lib is fixed, but first wanted to verify that such behavior has been reported for other users running db-lib; or if no reports of this nature have been experienced. Any help anyone is able to provide would be great, as we are considering switching over to ct-lib within the next two days. Thnx. -Pretlow Stevenson Comuter Associates International p.s. We apologize for posting this to both lists, but were trying to catch all possible responses by posting in both the general dev and db forums.

« previous php.db (#1213) next »