ID: 15083
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Old Status: Feedback
Status: Closed
Bug Type: MSSQL related
Operating System: Windows 2000 Pro
PHP Version: 4.1.1
New Comment:
<?
//////////////////////////////////
//
// Apologize for the bug information,
// the mssql functions work fine...
// But the problem occurs only when set_magic_quotes_runtime is set to
true on PHP 4.1.1
// with version 4.0.6, the problem don't appear.
//
set_magic_quotes_runtime(true);
$conn = mssql_connect(yourHostname, yourUsername, yourPassword);
mssql_select_db(yourDatabase, $conn);
$result = mssql_query("SELECT name FROM Country"); // name type nchar
$count = mssql_num_rows($result)
$value = array();
for($i = 0; $i < $count; $i++) { $value[] =
mssql_fetch_object($result); }
print_r($value);
mssql_free_result($result);
mssql_close($conn);
?>
Previous Comments:
------------------------------------------------------------------------
[2002-01-17 13:45:59] [EMAIL PROTECTED]
Status -> feedback
------------------------------------------------------------------------
[2002-01-17 13:44:39] [EMAIL PROTECTED]
Can you provide a sample script?
------------------------------------------------------------------------
[2002-01-17 09:17:48] [EMAIL PROTECTED]
On PHP 4.0.6 on Windows 2000 Pro
I use the php_mssql.dll extension to access mssql server 7.0 and all
the method works very well.
(hum!! only the problem with ntext type but with CAST(yourfieldname AS
text) on the SQL query, that disappears)
After updating to PHP 4.1.1 on Windows 2000 Pro
The same code crashes Apache and Windows displays a dialog box with :
Apache.exe
The instruction at "0x006db197" referenced memory at "0x043bcc3a".
The memory could not be "written".
I have search for a long time in the SQL query but in reality the
problem is not there...
The problem depends of the type returned by the query.
All the numerical types work fine but all the string types like char,
nchar, text, ... result in crashes.
This problem appears only when you try to read the result with
mssql_fetch_xxxx methods...
My configuration :
Windows 2000 Pro
MSSQL SERVER 7.0
APACHE 1.3.20
PHP 4.1.1 (same problem with PHP 4.1.0)
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=15083&edit=1
--
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]
