note 70720 added to function.mssql-query

From: Date: Wed, 25 Oct 2006 07:37:52 +0000
Subject: note 70720 added to function.mssql-query
Groups: php.notes 
Request: Send a blank email to php-notes+get-119091@lists.php.net to get a copy of this message
It seems inserting records to a temporary table using sp_executesql within a stored procedure is not supported. I run insert...exec sp_executesql... within a sproc, and get 0 results, no errors. I also noticed some other odd behaviour running subsequent queries on the same connection. Same sproc runs fine using ADO, QA, etc. Ideas anyone? Maybe there is some kind of 'master list' of non-PHP-mssql compatible T-SQL? ---- Server IP: 217.160.250.20 Probable Submitter: 58.6.127.73 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-query.php Edit -- https://master.php.net/note/edit/70720 Del: integrated -- https://master.php.net/note/delete/70720/integrated Del: useless -- https://master.php.net/note/delete/70720/useless Del: bad code -- https://master.php.net/note/delete/70720/bad+code Del: spam -- https://master.php.net/note/delete/70720/spam Del: non-english -- https://master.php.net/note/delete/70720/non-english Del: in docs -- https://master.php.net/note/delete/70720/in+docs Del: other reasons-- https://master.php.net/note/delete/70720 Reject -- https://master.php.net/note/reject/70720 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#119091) next »