From:             [EMAIL PROTECTED]
Operating system: Windows 98 SE
PHP version:      4.0.6
PHP Bug Type:     ODBC related
Bug description:  odbc_exec() throws ISE 500 error

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 

        global $page, $action, $ID, $user_data;
        global $global_conn, $bgcolor;
        $SQL = 'SELECT bunnyID, name, email, content, signed, IP, dateAdded FROM 
        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.


Edit Bug report at:

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to