MDB2
[ class tree: MDB2 ] [ index: MDB2 ] [ all elements ]

Class: MDB2_Driver_Function_sqlsrv

Source Location: /MDB2_Driver_sqlsrv-1.5.0b5/MDB2/Driver/Function/sqlsrv.php

Class Overview

MDB2_Driver_Function_Common
   |
   --MDB2_Driver_Function_sqlsrv

MDB2 MSSQL driver for the function modules


Methods


Inherited Variables

Inherited Methods


Class Details

[line 54]
MDB2 MSSQL driver for the function modules


[ Top ]


Method Detail

concat   [line 151]

string concat( string $value1, string $value2, string $values...)

Returns string to concatenate two or more string parameters
  • Return: to concatenate two strings
  • Access: public

Parameters:

string   $value1     
string   $value2     
string   $values...     

[ Top ]

executeStoredProc   [line 70]

mixed executeStoredProc( string $name, [mixed $params = null], [mixed $types = null], [mixed $result_class = true], [mixed $result_wrap_class = false])

Execute a stored procedure and return any results
  • Return: a result handle or MDB2_OK on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $name     string that identifies the function to execute
mixed   $params     array that contains the paramaters to pass the stored proc
mixed   $types     array that contains the types of the columns in the result set
mixed   $result_class     string which specifies which result class to use
mixed   $result_wrap_class     string which specifies which class to wrap results in

[ Top ]

guid   [line 181]

string guid( )

Returns global unique identifier
  • Return: to get global unique identifier
  • Access: public

[ Top ]

length   [line 167]

return length( string $expression)

return string to call a function to get the length of a string expression
  • Return: string to get the string expression length
  • Access: public

Parameters:

string   $expression     

[ Top ]

now   [line 95]

string now( [ $type = 'timestamp'])

Return string to call a variable with the current timestamp inside an SQL statement

There are three special variables for current date and time:

  • CURRENT_TIMESTAMP (date and time, TIMESTAMP type)
  • CURRENT_DATE (date, DATE type)
  • CURRENT_TIME (time, TIME type)

  • Return: to call a variable with the current timestamp
  • Access: public

Parameters:

   $type     

[ Top ]

substring   [line 131]

string substring( $value, [ $position = 1], [ $length = null])

return string to call a function to get a substring inside an SQL statement
  • Return: to call a function to get a substring
  • Access: public

Parameters:

   $value     
   $position     
   $length     

[ Top ]

unixtimestamp   [line 117]

string unixtimestamp( string $expression)

return string to call a function to get the unix timestamp from a iso timestamp
  • Return: to call a variable with the timestamp
  • Access: public

Parameters:

string   $expression     

[ Top ]


Documentation generated on Tue, 23 Oct 2012 18:31:15 +0000 by phpDocumentor 1.4.3. PEAR Logo Copyright © PHP Group 2004.