note 44108 deleted from function.odbc-exec by nlopess
| From: | nlopess@php.net | Date: | Thu, 15 Jul 2004 10:39:14 +0000 |
| Subject: | note 44108 deleted from function.odbc-exec by nlopess | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-73282@lists.php.net to get a copy of this message | ||
Note Submitter: Homer
----
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?