ID:               7779
 Comment by:       [EMAIL PROTECTED]
 Reported By:      [EMAIL PROTECTED]
 Status:           Closed
 Bug Type:         ODBC related
 Operating System: Windows 2000
 PHP Version:      4.0.3pl1
 New Comment:

It happens to me, too...win98, personal web server, filemaker pro ODBC
driver, php 4.2.3 used as CGI.

"select distinct field from table" crashes php.exe but works fine with
every other ODBC query tool I tried.
The only difference between my case and the original bug report is that
the crash doesn't happen immediately, but only after I try to examine
the query results.

i.e.:

$resultid = odbc_do($connectionid, "select distinct field from
table");
odbc_free_result($resultid);

works fine, but

$resultid = odbc_do($connectionid, "select distinct field from
table");
odbc_fetch_into($resultid, $resultarray);
// or odbc_fetch_row, or any other function which
// tries to make use of the results

crashes.

"select field from table" works fine.


Previous Comments:
------------------------------------------------------------------------

[2001-05-08 10:55:10] [EMAIL PROTECTED]

no user feedback.  considered fixed in cvs.  if this is untrue, please
reopen the bug.

------------------------------------------------------------------------

[2001-04-18 22:04:16] [EMAIL PROTECTED]

can you please try this with a more recent version of PHP?  with my
limited resources, attempting this on win98SE i cannot reproduce the
error... so either its been fixed, or it may be win2k specific...

------------------------------------------------------------------------

[2000-11-13 05:56:41] [EMAIL PROTECTED]

(PHP Version 4.0.4-dev on Windows 2000 without SP1)

php.exe and the isapi module both crash with a query like:
$query = "select distinct date from datetest";
The query without "distict" works fine.

ISAPI modules says: PHP has encountered an Access Violation at
04C2EA86, php.exe quits with no special message.

There is no error message from the ODBC driver when the same query is
(successfully) issued directly through an odbc client. 


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=7779&edit=1

Reply via email to