Home | Classes | Modules | Annotated | Hierarchy | Functions | Files

MSSQLConnection Class Reference

Inherits ConnectionCommon, and Connection.

List of all members.

Public Member Functions

• connect ( $dsninfo, $flags )
• getDatabaseInfo ()
• getIdGenerator ()
• prepareStatement ( $sql )
• createStatement ()
• applyLimit ( & $sql, $offset, $limit )
• close ()
• executeQuery ( $sql, $fetchmode )
• executeUpdate ( $sql )
• commit ()
• void rollback ()
• int getUpdateCount ()
• CallableStatement prepareCall ( $sql )

---

Member Function Documentation

MSSQLConnection::connect ( $dsninfo, $flags = 0 )

See also Connection::connect() Implements Connection.

MSSQLConnection::getDatabaseInfo ( )

See also Connection::getDatabaseInfo() Implements Connection.

MSSQLConnection::getIdGenerator ( )

See also Connection::getIdGenerator() Implements Connection.

MSSQLConnection::prepareStatement ( $sql )

See also Connection::prepareStatement() Implements Connection.

MSSQLConnection::createStatement ( )

See also Connection::createStatement() Implements Connection.

MSSQLConnection::applyLimit ( & $sql, $offset, $limit )

Returns false since MSSQL doesn't support this method. Reimplemented from ConnectionCommon.

MSSQLConnection::close ( )

See also Connection::close() Implements Connection.

MSSQLConnection::executeQuery ( $sql, $fetchmode = null )

See also Connection::executeQuery() Implements Connection.

MSSQLConnection::executeUpdate ( $sql )

See also Connection::executeUpdate() Implements Connection.

MSSQLConnection::commit ( )

Commit the current transaction. Implements Connection.

void MSSQLConnection::rollback ( )

Roll back (undo) the current transaction. Exceptions SQLException  Returns void Implements Connection.

int MSSQLConnection::getUpdateCount ( )

Gets the number of rows affected by the last query. if the last query was a select, returns 0. Returns int Number of rows affected by the last query Exceptions SQLException  Implements Connection.

CallableStatement MSSQLConnection::prepareCall ( $sql )

Creates a CallableStatement object for calling database stored procedures. Parameters string  $sql Returns CallableStatement Exceptions SQLException  Reimplemented from ConnectionCommon.

---

This file is part of the Creole[php5] library.