Hi there I am getting the follwoing error and I am not sure what the error means…can anyone help?
Thanks
[B]Warning: mssql_query() [function.mssql-query]: message: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16) in C:\Inetpub\wwwroot\zycko_2007\06\admin\cms2.php on line 7
Warning: mssql_query() [function.mssql-query]: Query failed in C:\Inetpub\wwwroot\zycko_2007\06\admin\cms2.php on line 7
Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in C:\Inetpub\wwwroot\zycko_2007\06\admin\cms2.php on line 9[/B]
<?
session_start();
include "../../connect.inc.php";
$query="SELECT * FROM zycko_products.dbo.cms_pages";
$result=mssql_query($query);
while ($array=mssql_fetch_assoc($result)) {
echo $array['domain']."<br>";
}
?>
Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library
solution:
try: select field from table, avoid “select * from table” php will scream at you. strangely after executing select field from table you’ll be able to execute select * from table.
i’m using apache2, win XP, sqlexpress05
Doing a select * for anything is a massive no no - select the fields you want not the whole caboodle!