Re: [PHP] MS SQL Server problem

2003-02-24 Thread Adam Voigt
Let me guess, your using NTEXT datatypes in one or more columns on that table right? It's not a big deal to work around this, just use: mssql_query("SELECT CAST(field1 AS TEXT) AS field1 FROM table;"); Essentially you have to cast your NTEXT colums (or any which could have more then 255

[PHP] MS SQL Server problem

2003-02-23 Thread Mark Virtue
This code works perfectly and returns all the data that I expect: mssql_pconnect($hostname, $username, $password) or die("blah blah"); mssql_select_db($dbName) or die("blah blah"); $result = mssql_query("select MyFieldName from MyTable"); But if I change the last line to this: $result = mssql_q