ID: 11763
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: ODBC related
Operating system: Windows 98 SE
PHP Version: 4.0.6
Description: odbc_exec() throws ISE 500 error
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
Previous Comments:
---------------------------------------------------------------------------
[2001-06-27 22:47:52] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=11763
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
