Bug #11763 Updated: odbc_exec() throws ISE 500 error

ID: 11763 Updated by: kalowsky@php.net Reported By: lustig@acsu.buffalo.edu -Status: Open +Status: Closed Bug Type: ODBC related Operating System: Windows 98 SE PHP Version: 4.0.6 New Comment: type TEXT is not a valid ODBC type in version 2.0 and 3.0 systems. It is in version 3.5 and greater... PHP does not support ODBC 3.5 or better yet. I'm still working on that. Previous Comments: ------------------------------------------------------------------------ [2001-06-30 01:57:53] lustig@acsu.buffalo.edu Another thing -- I've been playing around with some other code, and am getting the same type of thing. I think that the problem is witth fields of the type "text". When I take out the field "content" from the query in the first snippet, it works fine. Otherwise, 500 error. With another piece of code very similar to that one, it SELECTs a field "summary" from the table "fanfic". "summary" is a text field, and it throws the 500 error. So I'm pretty sure that it's SELECTing text datatype fields that is giving the 500 error. --Jason ------------------------------------------------------------------------ [2001-06-27 22:47:52] lustig@acsu.buffalo.edu Another note on the above code snippet -- the dbtext() function just puts quotes around whatever is the params... ie, dbtext(1) would return "1" (the quotes being part of the returned string). --Jason ------------------------------------------------------------------------ [2001-06-27 22:45:52] lustig@acsu.buffalo.edu 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 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=11763&edit=1