note 44108 added to function.odbc-exec

Problem: Adding the FOR XML clause when accessing SQL Server gives the following: Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]The FOR XML clause is not allowed in a CURSOR statement., SQL state 37000 in SQLExecDirect in C:\htdocs\sqlserver\index.php on line 20 Any ideas how to execute this directly, not in a CURSOR statement? ---- Manual Page -- http://www.php.net/manual/en/function.odbc-exec.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+44108 Delete -- http://master.php.net/manage/user-notes.php?action=delete+44108&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+44108&report=yes Search -- http://master.php.net/manage/user-notes.php