Class: MSSQLStatement

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

Class Overview

StatementCommon
   |
   --MSSQLStatement

Class that contains MSSQL functionality for Statements.

Author(s):

Hans Lellelid <hans@xmpl.org>

Version:

$Revision: 1.4 $

Methods

Inherited Variables

Class: StatementCommon

StatementCommon::$conn
StatementCommon::$limit
StatementCommon::$offset
StatementCommon::$resultClass
StatementCommon::$resultSet
StatementCommon::$stmt
StatementCommon::$updateCount
StatementCommon::$warnings

Inherited Methods

Class: StatementCommon

StatementCommon::__construct(): Create new statement instance.
StatementCommon::close(): Free resources associated with this statement.
StatementCommon::execute(): Generic execute() function has to check to see whether SQL is an update or select query.
StatementCommon::executeQuery(): Executes the SQL query in this PreparedStatement object and returns the resultset generated by the query.
StatementCommon::executeUpdate(): Executes the SQL INSERT, UPDATE, or DELETE statement in this PreparedStatement object.
StatementCommon::getConnection(): Gets the db Connection that created this statement.
StatementCommon::getLimit(): Returns the maximum number of rows to return or 0 for all.
StatementCommon::getMoreResults(): Gets next result set (if this behavior is supported by driver).
StatementCommon::getOffset(): Returns the start row.
StatementCommon::getResultSet(): Get result set.
StatementCommon::getUpdateCount(): Get update count.
StatementCommon::isSelect(): Returns whether the passed SQL is a SELECT statement.
StatementCommon::setLimit(): Sets the maximum number of rows to return from db.
StatementCommon::setOffset(): Sets the start row.

Class Details

[line 32]
Class that contains MSSQL functionality for Statements.

Tags:

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

[ Top ]

Class Methods

method executeQuery [line 42]

object Creole::ResultSet executeQuery(
string
$sql, [int
$fetchmode = null])

Executes the SQL query in this PreparedStatement object and returns the resultset generated by the query.

Tags:

access:	public
throws:	SQLException If there is an error executing the specified query.

Overrides StatementCommon::executeQuery() (Executes the SQL query in this PreparedStatement object and returns the resultset generated by the query.)

Parameters:

string	$sql	This method may optionally be called with the SQL statement.
int	$fetchmode	The mode to use when fetching the results (e.g. ResultSet::FETCHMODE_NUM, ResultSet::FETCHMODE_ASSOC).

[ Top ]

method getMoreResults [line 65]

boolean getMoreResults(
)

Gets next result set (if this behavior is supported by driver).

Some drivers (e.g. MSSQL) support returning multiple result sets -- e.g. from stored procedures.

This function also closes any current restult set.

Default behavior is for this function to return false. Driver-specific implementations of this class can override this method if they actually support multiple result sets.

Tags:

return:	True if there is another result set, otherwise false.
access:	public

Overrides StatementCommon::getMoreResults() (Gets next result set (if this behavior is supported by driver).)

[ Top ]

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