Home | Classes | Modules | Annotated | Functions | Files

MSSQLConnection Class Reference
[Creole::Drivers, Creole::Drivers::MSSQL]

Inherits ConnectionCommon.

List of all members.

Public Member Functions

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

Public Attributes

• $database

---

Detailed Description

MS SQL Server implementation of Connection.

If you have trouble with BLOB / CLOB support --------------------------------------------

You may need to change some PHP ini settings. In particular, the following settings set the text size to maximum which should get around issues with truncated data: ini_set('mssql.textsize', 2147483647); ini_set('mssql.textlimit', 2147483647); We do not set these by default (anymore) because they do not apply to cases where MSSQL is being used w/ FreeTDS.

Author Hans Lellelid <hans@xmpl.org>

Michael Aichler <aichler@mediacluster.de>

Stig Bakken <ssb@fast.no>

Lukas Smith

Version 

Revision

1.1

---

Member Function Documentation

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

See also Connection::connect() Reimplemented from Connection.

& MSSQLConnection::getDatabaseInfo ()

See also Connection::getDatabaseInfo() Reimplemented from Connection.

& MSSQLConnection::getIdGenerator ()

See also Connection::getIdGenerator() Reimplemented from Connection.

& MSSQLConnection::prepareStatement ( $  sql)

See also Connection::prepareStatement() Reimplemented from Connection.

& MSSQLConnection::createStatement ()

See also Connection::createStatement() Reimplemented from Connection.

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

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

MSSQLConnection::close ()

See also Connection::close() Reimplemented from Connection.

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

See also Connection::executeQuery() Reimplemented from Connection.

MSSQLConnection::executeUpdate ( $  sql)

See also Connection::executeUpdate() Reimplemented from Connection.

MSSQLConnection::commit ()

Commit the current transaction. Reimplemented from Connection.

MSSQLConnection::rollback ()

Roll back (undo) the current transaction. Exceptions: SQLException  Returns void Reimplemented from Connection.

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  Reimplemented from Connection.

& MSSQLConnection::prepareCall ( $  sql)

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

---

Member Data Documentation

MSSQLConnection::$database

Current database (used in mssql_select_db()).

---

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