Home | Classes | Modules | Annotated | Functions | Files

MSSQLCallableStatement Class Reference

Inherits MSSQLPreparedStatement.

List of all members.

Public Member Functions

• MSSQLCallableStatement (&$conn, $stmt)
• getResource ()
• close ()
• & executeQuery ($p1=null, $fetchmode=null)
• getMoreResults ()
• registerOutParameter ($paramIndex, $sqlType)
• setArray ($paramIndex, &$value, $out=false)
• setBoolean ($paramIndex, &$value, $out=false)
• setBlob ($paramIndex, &$blob, $out=false)
• setClob ($paramIndex, &$clob, $out=false)
• setDate ($paramIndex, &$value, $out=false)
• setFloat ($paramIndex, &$value, $out=false)
• setInt ($paramIndex, &$value, $out=false)
• setNull ($paramIndex)
• setString ($paramIndex, &$value, $out=false)
• setTime ($paramIndex, &$value, $out=false)
• setTimestamp ($paramIndex, &$value, $out=false)
• getArray ($paramIndex)
• getBoolean ($paramIndex)
• & getBlob ($paramIndex)
• & getClob ($paramIndex)
• getDate ($paramIndex, $fmt= '%Y-%m-%d')
• getFloat ($paramIndex)
• getInt ($paramIndex)
• getString ($paramIndex)
• getTime ($paramIndex, $format='%X')
• getTimestamp ($paramIndex, $format= 'Y-m-d H:i:s')

Public Attributes

• $boundOutVars = array()
• $stmt
• $result

---

Constructor & Destructor Documentation

MSSQLCallableStatement::MSSQLCallableStatement ( &$  conn,  $  stmt )

Construct new MSSQLCallableStatement. Parameters: Connection  $conn resource  $stmt

---

Member Function Documentation

MSSQLCallableStatement::getResource ()

See also CallableStatement::getResource() Reimplemented from PreparedStatementCommon.

MSSQLCallableStatement::close ()

See also CallableStatement::close() Reimplemented from PreparedStatementCommon.

& MSSQLCallableStatement::executeQuery ( $  p1 = null,  $  fetchmode = null )

See also CallableStatement::executeQuery() Reimplemented from MSSQLPreparedStatement.

MSSQLCallableStatement::getMoreResults ()

See also CallableStatement::getMoreResults() Reimplemented from PreparedStatementCommon.

MSSQLCallableStatement::registerOutParameter ( $  paramIndex,  $  sqlType )

See also CallableStatement::registerOutParameter()

MSSQLCallableStatement::setArray ( $  paramIndex,  &$  value,  $  out = false )

See also CallableStatement::setArray()

MSSQLCallableStatement::setBoolean ( $  paramIndex,  &$  value,  $  out = false )

See also CallableStatement::setBoolean()

MSSQLCallableStatement::setBlob ( $  paramIndex,  &$  blob,  $  out = false )

See also CallableStatement::setBlob()

MSSQLCallableStatement::setClob ( $  paramIndex,  &$  clob,  $  out = false )

See also CallableStatement::setClob()

MSSQLCallableStatement::setDate ( $  paramIndex,  &$  value,  $  out = false )

See also CallableStatement::setDate()

MSSQLCallableStatement::setFloat ( $  paramIndex,  &$  value,  $  out = false )

See also CallableStatement::setFloat()

MSSQLCallableStatement::setInt ( $  paramIndex,  &$  value,  $  out = false )

See also CallableStatement::setInt()

MSSQLCallableStatement::setNull ( $  paramIndex)

See also CallableStatement::setNull() Reimplemented from PreparedStatementCommon.

MSSQLCallableStatement::setString ( $  paramIndex,  &$  value,  $  out = false )

See also CallableStatement::setString()

MSSQLCallableStatement::setTime ( $  paramIndex,  &$  value,  $  out = false )

See also CallableStatement::setTime()

MSSQLCallableStatement::setTimestamp ( $  paramIndex,  &$  value,  $  out = false )

See also CallableStatement::setTimestamp()

MSSQLCallableStatement::getArray ( $  paramIndex)

See also CallableStatement::getArray() Returns mixed array on success, SQLException, if requested variable not bound to output var.

MSSQLCallableStatement::getBoolean ( $  paramIndex)

See also CallableStatement::getBoolean() Returns mixed boolean on success, SQLException, if requested variable not bound to output var.

& MSSQLCallableStatement::getBlob ( $  paramIndex)

See also CallableStatement::getBlob() Returns mixed BLob on success, SQLException, if requested variable not bound to output var.

& MSSQLCallableStatement::getClob ( $  paramIndex)

See also CallableStatement::getClob() Returns mixed CLob on success, SQLException, if requested variable not bound to output var.

MSSQLCallableStatement::getDate ( $  paramIndex,  $  fmt = '%Y-%m-%d' )

See also CallableStatement::getDate() Returns mixed string on success, SQLException, if requested variable not bound to output var.

MSSQLCallableStatement::getFloat ( $  paramIndex)

Parameters: mixed  $paramIndex Column name (string) or index (int). Returns mixed float on success, SQLException, if requested variable not bound to output var.

MSSQLCallableStatement::getInt ( $  paramIndex)

See also CallableStatement::getInt() Returns mixed int on success, SQLException, if requested variable not bound to output var.

MSSQLCallableStatement::getString ( $  paramIndex)

See also CallableStatement::getString() Returns mixed string on success, SQLException, if requested variable not bound to output var.

MSSQLCallableStatement::getTime ( $  paramIndex,  $  format = '%X' )

See also CallableStatement::getTime() Returns mixed string on success, SQLException, if requested variable not bound to output var.

MSSQLCallableStatement::getTimestamp ( $  paramIndex,  $  format = 'Y-m-d H:i:s' )

See also CallableStatement::getTimestamp() Returns mixed string on success, SQLException, if requested variable not bound to output var.

---

Member Data Documentation

MSSQLCallableStatement::$boundOutVars = array()

Output variables

MSSQLCallableStatement::$stmt

MSSQLCallableStatement::$result

---

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