Class: MSSQLPreparedStatement

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

Class Overview

PreparedStatementCommon
   |
   --MSSQLPreparedStatement

MSSQL specific PreparedStatement functions.

Author(s):

Hans Lellelid <hans@xmpl.org>

Version:

$Revision: 1.12 $

Methods

Child classes:

MSSQLCallableStatement: MS SQL Server class to handle stored procedure execution.

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: 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 32]
MSSQL specific PreparedStatement functions.

Tags:

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

[ Top ]

Class Methods

method escape [line 64]

void escape(
mixed
$subject)

Add quotes using str_replace.

This is not as thorough as MySQL.

Tags:

access:

protected

Overrides PreparedStatementCommon::escape() (Escapes special characters (usu. quotes) using native driver function.)

[ Top ]

method executeQuery [line 74]

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

MSSQL must emulate OFFSET/LIMIT support.

method setBlob [line 45]

void setBlob(
int
$paramIndex, mixed
$blob, mixed
$value)

MSSQL-specific implementation of setBlob().

If you are having trouble getting BLOB data into the database, see the phpdoc comment in the MSSQLConnection for some PHP ini values that may need to be set. (This also applies to CLOB support.)

Overridden in child classes as:

MSSQLCallableStatement::setBlob()

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

Parameters:

int	$paramIndex
mixed	$value	Blob object or string.

[ Top ]

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