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):

Hans Lellelid <hans@xmpl.org>

Version:

$Revision: 1.18 $

Inherited Variables

Class: PreparedStatementCommon

PreparedStatementCommon::$boundInVars
PreparedStatementCommon::$conn
PreparedStatementCommon::$limit
PreparedStatementCommon::$offset
PreparedStatementCommon::$positions
PreparedStatementCommon::$positionsCount
PreparedStatementCommon::$resultSet
PreparedStatementCommon::$sql
PreparedStatementCommon::$updateCount

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

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:

see:

CallableStatement::getArray()

[ Top ]

method getBlob [line 348]

void getBlob(
mixed
$paramIndex)

Tags:

see:

CallableStatement::getBlob()

[ Top ]

method getBoolean [line 336]

void getBoolean(
mixed
$paramIndex)

Tags:

see:

CallableStatement::getBoolean()

[ Top ]

method getClob [line 363]

void getClob(
mixed
$paramIndex)

Tags:

see:

CallableStatement::getClob()

[ Top ]

method getDate [line 378]

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

Tags:

see:

CallableStatement::getDate()

[ 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:

see:

CallableStatement::getInt()

[ 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

null

[ Top ]

method getString [line 426]

void getString(
mixed
$paramIndex)

Tags:

see:

CallableStatement::getString()

[ Top ]

method getTime [line 438]

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

Tags:

see:

CallableStatement::getTime()

[ Top ]

method getTimestamp [line 460]

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

Tags:

see:

CallableStatement::getTimestamp()

[ Top ]

method registerOutParameter [line 160]

void registerOutParameter(
mixed
$paramIndex, mixed
$sqlType)

Tags:

see:

CallableStatement::registerOutParameter()

[ 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