Bug #18514 Updated: TEXT S1002 SQL error
| From: | kalowsky@php.net | Date: | Tue, 23 Jul 2002 21:47:09 +0000 |
| Subject: | Bug #18514 Updated: TEXT S1002 SQL error | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-14954@lists.php.net to get a copy of this message | ||
ID: 18514
Updated by: kalowsky@php.net
Reported By: drake@virtualdrake.com
-Status: Open
+Status: Closed
-Bug Type: MSSQL related
+Bug Type: ODBC related
Operating System: windows 2000
PHP Version: 4.2.2
New Comment:
1) This isn't an MS SQL issue, this is an ODBC issue (as per your error
warning).
2) Under ODBC v2 (which is what PHP is), type TEXT is not a valid SQL
Type. Any result you get from it is by chance.
Previous Comments:
------------------------------------------------------------------------
[2002-07-23 17:28:48] drake@virtualdrake.com
Warning: SQL error: [Microsoft][ODBC SQL Server Driver]Invalid
Descriptor Index, SQL state S1002 in SQLGetData in c:\program
files\apache group\apache\htdocs\gettable.php on line 135
When trying to get a text field from MS SQL, it is mis-representing THe
length of the field 2147483647
most are actually NULL, but some are a whole 30 characters
if(odbc_result($cur,$w)==NULL)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=18514&edit=1