creole.drivers.mssql
[ class tree: creole.drivers.mssql ] [ index: creole.drivers.mssql ] [ all elements ]

Class: MSSQLCallableStatement

Source Location: /creole/drivers/mssql/MSSQLCallableStatement.php

Class Overview

PreparedStatementCommon
   |
   --MSSQLPreparedStatement
      |
      --MSSQLCallableStatement

MS SQL Server class to handle stored procedure execution.


Author(s):

Version:

  • $Revision: 1.18 $

Methods


Inherited Variables

Inherited Methods

Class: MSSQLPreparedStatement

MSSQLPreparedStatement::escape()
Add quotes using str_replace.
MSSQLPreparedStatement::executeQuery()
MSSQL must emulate OFFSET/LIMIT support.
MSSQLPreparedStatement::setBlob()
MSSQL-specific implementation of setBlob().

Class: PreparedStatementCommon

PreparedStatementCommon::__construct()
Create new prepared statement instance.
PreparedStatementCommon::close()
Nothing to close for emulated prepared statements.
PreparedStatementCommon::escape()
Escapes special characters (usu. quotes) using native driver function.
PreparedStatementCommon::executeQuery()
Executes the SQL query in this PreparedStatement object and returns the resultset generated by the query.
PreparedStatementCommon::executeUpdate()
Executes the SQL INSERT, UPDATE, or DELETE statement in this PreparedStatement object.
PreparedStatementCommon::getConnection()
PreparedStatementCommon::getLimit()
PreparedStatementCommon::getMoreResults()
PreparedStatementCommon::getOffset()
PreparedStatementCommon::getResource()
Statement resources do not exist for emulated prepared statements, so this just returns
  1. null
.
PreparedStatementCommon::getResultSet()
PreparedStatementCommon::getUpdateCount()
PreparedStatementCommon::replaceParams()
Replaces placeholders with the specified parameter values in the SQL.
PreparedStatementCommon::set()
A generic set method.
PreparedStatementCommon::setArray()
Sets an array.
PreparedStatementCommon::setBlob()
PreparedStatementCommon::setBoolean()
Sets a boolean value.
PreparedStatementCommon::setClob()
PreparedStatementCommon::setDate()
PreparedStatementCommon::setDecimal()
PreparedStatementCommon::setDouble()
PreparedStatementCommon::setFloat()
PreparedStatementCommon::setInt()
PreparedStatementCommon::setInteger()
Alias for setInt()
PreparedStatementCommon::setLimit()
PreparedStatementCommon::setNull()
PreparedStatementCommon::setOffset()
PreparedStatementCommon::setString()
PreparedStatementCommon::setTime()
PreparedStatementCommon::setTimestamp()

Class Details

[line 42]
MS SQL Server class to handle stored procedure execution.

Developer note:

There is no CallableStatement superclass. Unlike JDBC, Creole uses abstract parent classes rather than interfaces -- in order to minimize code duplication. Since PHP doesn't support multiple inheritance, the DRIVERCallableStatement class cannot extend both the DRIVERPreparedStatement class and the would-be abstract CallableStatement class.




Tags:

version:  $Revision: 1.18 $
author:  Hans Lellelid <hans@xmpl.org>


[ Top ]


Class Methods


constructor __construct [line 89]

MSSQLCallableStatement __construct( Connection $conn, resource $stmt)

Construct new MSSQLCallableStatement.



Tags:

access:  public


Overrides PreparedStatementCommon::__construct() (Create new prepared statement instance.)

Parameters:

Connection   $conn  
resource   $stmt  

[ Top ]

method close [line 107]

void close( )



Tags:

see:  CallableStatement::close()


Overrides PreparedStatementCommon::close() (Nothing to close for emulated prepared statements.)

[ Top ]

method executeQuery [line 116]

void executeQuery( [mixed $p1 = null], [mixed $fetchmode = null])



Tags:

see:  CallableStatement::executeQuery()


Overrides MSSQLPreparedStatement::executeQuery() (MSSQL must emulate OFFSET/LIMIT support.)

[ Top ]

method getArray [line 324]

void getArray( mixed $paramIndex)



Tags:



[ Top ]

method getBlob [line 348]

void getBlob( mixed $paramIndex)



Tags:



[ Top ]

method getBoolean [line 336]

void getBoolean( mixed $paramIndex)



Tags:



[ Top ]

method getClob [line 363]

void getClob( mixed $paramIndex)



Tags:



[ Top ]

method getDate [line 378]

void getDate( mixed $paramIndex, [mixed $fmt = '%Y-%m-%d'])



Tags:



[ Top ]

method getFloat [line 402]

float getFloat( mixed $paramIndex)



Parameters:

mixed   $paramIndex   Column name (string) or index (int).

[ Top ]

method getInt [line 414]

void getInt( mixed $paramIndex)



Tags:



[ Top ]

method getMoreResults [line 143]

void getMoreResults( )



Tags:

see:  CallableStatement::getMoreResults()


Overrides PreparedStatementCommon::getMoreResults() (parent method not documented)

[ Top ]

method getResource [line 99]

void getResource( )



Tags:

access:  public
see:  CallableStatement::getResource()


Overrides PreparedStatementCommon::getResource() (Statement resources do not exist for emulated prepared statements, so this just returns
  1. null
.)

[ Top ]

method getString [line 426]

void getString( mixed $paramIndex)



Tags:



[ Top ]

method getTime [line 438]

void getTime( mixed $paramIndex, [mixed $format = '%X'])



Tags:



[ Top ]

method getTimestamp [line 460]

void getTimestamp( mixed $paramIndex, [mixed $format = 'Y-m-d H:i:s'])



Tags:



[ Top ]

method registerOutParameter [line 160]

void registerOutParameter( mixed $paramIndex, mixed $sqlType)



Tags:



[ Top ]

method setArray [line 168]

void setArray( mixed $paramIndex, mixed $value, [mixed $out = false])



Tags:

see:  CallableStatement::setArray()


Overrides PreparedStatementCommon::setArray() (Sets an array.)

[ Top ]

method setBlob [line 197]

void setBlob( mixed $paramIndex, mixed $blob, [mixed $out = false])



Tags:

see:  CallableStatement::setBlob()


Overrides MSSQLPreparedStatement::setBlob() (MSSQL-specific implementation of setBlob().)

[ Top ]

method setBoolean [line 182]

void setBoolean( mixed $paramIndex, mixed $value, [mixed $out = false])



Tags:

see:  CallableStatement::setBoolean()


Overrides PreparedStatementCommon::setBoolean() (Sets a boolean value.)

[ Top ]

method setClob [line 214]

void setClob( mixed $paramIndex, mixed $clob, [mixed $out = false])



Tags:

see:  CallableStatement::setClob()


Overrides PreparedStatementCommon::setClob() (parent method not documented)

[ Top ]

method setDate [line 230]

void setDate( mixed $paramIndex, mixed $value, [mixed $out = false])



Tags:

see:  CallableStatement::setDate()


Overrides PreparedStatementCommon::setDate() (parent method not documented)

[ Top ]

method setFloat [line 244]

void setFloat( mixed $paramIndex, mixed $value, [mixed $out = false])



Tags:

see:  CallableStatement::setFloat()


Overrides PreparedStatementCommon::setFloat() (parent method not documented)

[ Top ]

method setInt [line 258]

void setInt( mixed $paramIndex, mixed $value, [mixed $out = false])



Tags:

see:  CallableStatement::setInt()


Overrides PreparedStatementCommon::setInt() (parent method not documented)

[ Top ]

method setNull [line 272]

void setNull( mixed $paramIndex)



Tags:

see:  CallableStatement::setNull()


Overrides PreparedStatementCommon::setNull() (parent method not documented)

[ Top ]

method setString [line 282]

void setString( mixed $paramIndex, mixed $value, [mixed $out = false])



Tags:

see:  CallableStatement::setString()


Overrides PreparedStatementCommon::setString() (parent method not documented)

[ Top ]

method setTime [line 296]

void setTime( mixed $paramIndex, mixed $value, [mixed $out = false])



Tags:

see:  CallableStatement::setTime()


Overrides PreparedStatementCommon::setTime() (parent method not documented)

[ Top ]

method setTimestamp [line 310]

void setTimestamp( mixed $paramIndex, mixed $value, [mixed $out = false])



Tags:

see:  CallableStatement::setTimestamp()


Overrides PreparedStatementCommon::setTimestamp() (parent method not documented)

[ Top ]


Documentation generated on Mon, 23 Aug 2004 21:51:35 -0400 by phpDocumentor 1.3.0RC3