| 
        php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login | 
 PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits             
             [2001-06-27 22:47 UTC] lustig at acsu dot buffalo dot edu
  [2001-06-30 01:57 UTC] lustig at acsu dot buffalo dot edu
  [2002-05-21 23:00 UTC] kalowsky@php.net
  | 
    |||||||||||||||||||||||||||
            
                 
                Copyright © 2001-2025 The PHP GroupAll rights reserved.  | 
        Last updated: Tue Nov 04 11:00:01 2025 UTC | 
I have a bug... I have a function (of which the following code is from) which pulls data from a remote MS SQL database through ODBC. The line with odbc_exec() is throwing an iSE 500 error on apache 1.3.14 (which I knwo to be the exact line because it's fine when it's commented out). I am using the PHP 4.06 windows binaries (from the PHP site) with the extra options installed... and to note, $global_conn is a global persistent connection that is being made global for the function of which the following code is a snippet: global $page, $action, $ID, $user_data; global $global_conn, $bgcolor; $SQL = 'SELECT bunnyID, name, email, content, signed, IP, dateAdded FROM plotbunnies'; if ($action == 'view') { $SQL.= ' WHERE bunnyID = '.dbtext($ID); } $SQL.= ' ORDER BY dateAdded DESC ;'; $bunnies= odbc_exec($global_conn, $SQL); When the $bunnes = odbc_exec($global_conn, $SQL); line is commented, it is fine; otherwise it gives me an HTTP ISE 500 error. --Jason