Class: MSSQLConnection

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

Class Overview

ConnectionCommon
   |
   --MSSQLConnection

MS SQL Server implementation of Connection.

Author(s):

Hans Lellelid <hans@xmpl.org>
Stig Bakken <ssb@fast.no>
Lukas Smith

Version:

$Revision: 1.22 $

Methods

Inherited Variables

Class: ConnectionCommon

ConnectionCommon::$autocommit
ConnectionCommon::$dblink
ConnectionCommon::$dsn
ConnectionCommon::$flags
ConnectionCommon::$transactionOpcount

Inherited Methods

Class: ConnectionCommon

ConnectionCommon::getAutoCommit(): Get auto-commit status.
ConnectionCommon::getDSN()
ConnectionCommon::getFlags()
ConnectionCommon::getResource()
ConnectionCommon::prepareCall(): Creates a CallableStatement object for calling database stored procedures.
ConnectionCommon::setAutoCommit(): Enable/disable automatic commits.
ConnectionCommon::__sleep(): This "magic" method is invoked upon serialize() and works in tandem with the __wakeup() method to ensure that your database connection is serializable.
ConnectionCommon::__wakeup(): This "magic" method is invoked upon unserialize().

Class Details

[line 49]
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.

Tags:

version:	$Revision: 1.22 $
author:	Hans Lellelid <hans@xmpl.org>
author:	Stig Bakken <ssb@fast.no>
author:	Lukas Smith

[ Top ]

Class Methods

method applyLimit [line 135]

void applyLimit(
mixed
&$sql, mixed
$offset, mixed
$limit)

Returns false since MSSQL doesn't support this method.

Tags:

access:

public

[ Top ]

method close [line 143]

void close(
)

Tags:

see:

Connection::close()

[ Top ]

method commit [line 196]

void commit(
)

Commit the current transaction.

[ Top ]

method connect [line 57]

void connect(
mixed
$dsninfo, [mixed
$flags = 0])

Tags:

see:

Connection::connect()

[ Top ]

method createStatement [line 126]

void createStatement(
)

Tags:

access:	public
see:	Connection::createStatement()

[ Top ]

method executeQuery [line 151]

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

Tags:

see:

Connection::executeQuery()

[ Top ]

method executeUpdate [line 167]

void executeUpdate(
mixed
$sql)

Tags:

see:

Connection::executeUpdate()

[ Top ]

method getDatabaseInfo [line 99]

void getDatabaseInfo(
)

Tags:

access:	public
see:	Connection::getDatabaseInfo()

[ Top ]

method getIdGenerator [line 108]

void getIdGenerator(
)

Tags:

access:	public
see:	Connection::getIdGenerator()

[ Top ]

method getUpdateCount [line 236]

int getUpdateCount(
)

Gets the number of rows affected by the last query.

if the last query was a select, returns 0.

Tags:

return:	Number of rows affected by the last query
throws:	SQLException

[ Top ]

method prepareCall [line 261]

CallableStatement prepareCall(
string
$sql)

Creates a CallableStatement object for calling database stored procedures.

Tags:

throws:

SQLException

Overrides ConnectionCommon::prepareCall() (Creates a CallableStatement object for calling database stored procedures.)

Parameters:

string

$sql

[ Top ]

method prepareStatement [line 117]

void prepareStatement(
mixed
$sql)

Tags:

access:	public
see:	Connection::prepareStatement()

[ Top ]

method rollback [line 215]

void rollback(
)

Roll back (undo) the current transaction.

Tags:

throws:

SQLException

[ Top ]

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