ID: 23990
User updated by: php at electricsurfer dot com
Reported By: php at electricsurfer dot com
Status: Open
Bug Type: MSSQL related
Operating System: Win XP PRO
PHP Version: 4.3.2
New Comment:
mssql_field_name() has same problem
Previous Comments:
------------------------------------------------------------------------
[2003-06-03 11:41:35] php at electricsurfer dot com
with mssql_fetch_assoc or mssql_fetch_array.
NOT mssql_fetch_row.
------------------------------------------------------------------------
[2003-06-03 11:29:50] php at electricsurfer dot com
If you select a field with a column name that has more than 30 chars.
Using mssql_fetch_assoc or mssql_fetch_row to fetch it will only return
a key with the 1st 30 chars.
( Mysql functions work with longer column names )
<?
// connect to db Here
$result = mssql_query('select MyVeryVeryVeryVeryVeryVeryLongColumnName
from table');
$row = mssql_fetch_assoc($result);
// $row = array('MyVeryVeryVeryVeryVeryVeryLong'=>50) (only first 30
chars in key)
?>
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=23990&edit=1
