ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:preparesp

Differences

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

Link to this comparison view

Next revision
Previous revision
reference:preparesp [2015/08/12 03:55] – created mnewnhamv5:reference:connection:preparesp [2016/11/02 12:45] (current) – add link to comparison matrix dregad
Line 1: Line 1:
 ====== prepareSp ====== ====== prepareSp ======
 ~~NOTOC~~ ~~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 [[v5:database:feature_comparison]].
 </WRAP> </WRAP>
 <WRAP right box> <WRAP right box>
 +== See Also ==
 +[[v5:reference:connection:prepare]]\\
 == Syntax == == Syntax ==
   mixed prepareSp (   mixed prepareSp (
Line 13: Line 15:
  
 ===== Description ===== ===== 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 ===== ===== Usage =====
v5/reference/connection/preparesp.1439344553.txt.gz · Last modified: 2017/04/21 11:33 (external edit)