Class: MDB2_Result_mssql

Source Location: /MDB2-2.0.0beta2/MDB2/Driver/mssql.php

Class Overview

MDB2_Result
   |
   --MDB2_Result_Common
      |
      --MDB2_Result_mssql

Variables

$limits

Methods

Child classes:

MDB2_BufferedResult_mssql

Inherited Variables

Class: MDB2_Result_Common

MDB2_Result_Common::$mdb
MDB2_Result_Common::$result
MDB2_Result_Common::$rownum
MDB2_Result_Common::$types

Inherited Methods

Class: MDB2_Result_Common

MDB2_Result_Common::MDB2_Result_Common(): Constructor
MDB2_Result_Common::fetch(): fetch value from a result set
MDB2_Result_Common::fetchAll(): Fetch and return a column of data (it uses fetchRow for that)
MDB2_Result_Common::fetchCol(): Fetch and return a column of data (it uses current for that)
MDB2_Result_Common::fetchRow(): Fetch and return a row of data
MDB2_Result_Common::free(): Free the internal resources associated with result.
MDB2_Result_Common::getColumnNames(): Retrieve the names of columns returned by the DBMS in a query result.
MDB2_Result_Common::getResource(): return the resource associated with the result object
MDB2_Result_Common::nextResult(): Move the internal result pointer to the next available result
MDB2_Result_Common::numCols(): Count the number of columns returned by the DBMS in a query result.
MDB2_Result_Common::resultIsNull(): Determine whether the value of a query result located in given row and field is a null.
MDB2_Result_Common::seek(): seek to a specific row in a result set
MDB2_Result_Common::setResultTypes(): Define the list of types to be associated with the columns of a given result set.

Class Details

[line 510]

[ Top ]

Class Variables

$limits =

[line 512]

Type:

mixed

[ Top ]

Method Detail

MDB2_Result_mssql (Constructor) [line 520]

MDB2_Result_mssql MDB2_Result_mssql(

&$mdb, 
&$result, 
$offset, 
$limit)

Constructor

Parameters:

	`&$mdb`	—
	`&$result`	—
	`$offset`	—
	`$limit`	—

[ Top ]

fetch [line 570]

mixed fetch(
[int
$rownum = 0], [int
$colnum = 0])

fetch value from a result set

Return: string on success, a MDB2 error on failure
Access: public

Overrides MDB2_Result_Common::fetch() (fetch value from a result set)

Parameters:

int	`$rownum`	—	number of the row where the data can be found
int	`$colnum`	—	field number where the data can be found

[ Top ]

fetchRow [line 603]

int fetchRow(
[int
$fetchmode = MDB2_FETCHMODE_DEFAULT])

Fetch a row and insert the data into an existing array.

Return: data array on success, a MDB2 error on failure
Access: public

Overrides MDB2_Result_Common::fetchRow() (Fetch and return a row of data)

Parameters:

int $fetchmode — how the array data should be indexed

[ Top ]

free [line 721]

boolean free(
)

Free the internal resources associated with $result.

Return: true on success, false if $result is invalid
Access: public

Overrides MDB2_Result_Common::free() (Free the internal resources associated with result.)

[ Top ]

getColumnNames [line 653]

mixed getColumnNames(
resource
$result)

Retrieve the names of columns returned by the DBMS in a query result.

Return: associative array variable that holds the names of columns. The indexes of the array are the column names mapped to lower case and the values are the respective numbers of the columns starting from 0. Some DBMS may not return any columns when the result set does not contain any rows.
Access: public

Overrides MDB2_Result_Common::getColumnNames() (Retrieve the names of columns returned by the DBMS in a query result.)

Parameters:

resource $result — result identifier

[ Top ]

nextResult [line 703]

true nextResult(
)

Move the internal result pointer to the next available result Currently not supported

Return: if a result is available otherwise return false
Access: public

Overrides MDB2_Result_Common::nextResult() (Move the internal result pointer to the next available result)

[ Top ]

numCols [line 680]

mixed numCols(
)

Count the number of columns returned by the DBMS in a query result.

Return: integer value with the number of columns, a MDB2 error on failure
Access: public

Overrides MDB2_Result_Common::numCols() (Count the number of columns returned by the DBMS in a query result.)

[ Top ]