Differences

This shows you the differences between two versions of the page.

--- reference:preparesp [2015/08/12 03:55] – created mnewnham
+++ v5:reference:connection:preparesp [2016/01/17 01:43] – ↷ Page moved from v5:reference:preparesp to v5:reference:connection:preparesp mnewnham
@@ Line 1: / Line 1: @@
 ====== prepareSp ======
 ~~NOTOC~~
-<WRAP alert>
+<WRAP info>
-Support for this function is limited to drivers that connect to Microsoft SQL Server databases
+Support for this function is limited. See the feature compatibility matrix
 </WRAP>
 <WRAP right box>
+== See Also ==
+[[v5:reference:connection:prepare]]\\
 == Syntax ==
   mixed prepareSp (
@@ Line 13: / Line 15: @@
 ===== Description =====
-The function ''prepareSP()'' accesses an existing stored procedure on a SQL server database. If the stored procedure is valid the function return a resource otherwise it returns false.
+The function ''prepareSP()'' accesses an existing stored procedure. If the stored procedure is valid the function return a resource otherwise it returns false.
+===== PrepareSp Correct Usage =====
+''prepareSp'' should only be used with database drivers that support direct access to the procedures. It should not be passed an SQL statement that might access the procedure so, assuming a stored procedure ''PROC_LIST'' exists,
+the statement:
+  $db->prepareSp('PROC_LIST')
+is correct, however
+   $db->prepareSp('CALL PROC_LIST')
+is not.
 -------------------------------------
 ===== Usage =====