Class JDatabaseQuerySQLSrv

Description

Query Building Class.

  • since: 11.1

Located in /libraries/joomla/database/database/sqlsrvquery.php (line 19)

JDatabaseQuery
   |
   --JDatabaseQuerySQLSrv
Direct descendents
Class Description
JDatabaseQuerySQLAzure Query Building Class.
Variable Summary
string $name_quotes
string $null_date
Method Summary
string castAsChar (string $value)
string charLength (string $field)
string concatenate (array $values, [string $separator = null])
string currentTimestamp ()
integer length (string $value)
string __toString ()
Variables
string $name_quotes = '`' (line 31)

The character(s) used to quote SQL statement names such as table names or field names, etc. The child classes should define this as necessary. If a single character string the same character is used for both sides of the quoted name, else the first character will be used for the opening quote and the second for the closing quote.

  • since: 11.1
  • access: protected

Redefined in descendants as:
  • JDatabaseQuerySQLAzure::$name_quotes : The character(s) used to quote SQL statement names such as table names or field names, etc. The child classes should define this as necessary. If a single character string the same character is used for both sides of the quoted name, else the first character will be used for the opening quote and the second for the closing quote.
string $null_date = '1900-01-01 00:00:00' (line 41)

The null or zero representation of a timestamp for the database driver. This should be defined in child classes to hold the appropriate value for the engine.

  • since: 11.1
  • access: protected

Inherited Variables

Inherited from JDatabaseQuery

JDatabaseQuery::$autoIncrementField
JDatabaseQuery::$columns
JDatabaseQuery::$db
JDatabaseQuery::$delete
JDatabaseQuery::$element
JDatabaseQuery::$from
JDatabaseQuery::$group
JDatabaseQuery::$having
JDatabaseQuery::$insert
JDatabaseQuery::$join
JDatabaseQuery::$order
JDatabaseQuery::$select
JDatabaseQuery::$set
JDatabaseQuery::$type
JDatabaseQuery::$union
JDatabaseQuery::$update
JDatabaseQuery::$values
JDatabaseQuery::$where
Methods
castAsChar (line 111)

Casts a value to a char.

Ensure that the value is properly quoted before passing to the method.

  • return: Returns the cast value.
  • since: 11.1
  • access: public
string castAsChar (string $value)
  • string $value: The value to cast as a char.

Redefinition of:
JDatabaseQuery::castAsChar()
Casts a value to a char.
charLength (line 125)

Gets the function to determine the length of a character string.

  • return: The required char length call.
  • since: 11.1
  • access: public
string charLength (string $field)
  • string $field: A value.

Redefinition of:
JDatabaseQuery::charLength()
Gets the number of characters in a string.
concatenate (line 140)

Concatenates an array of column names or values.

  • return: The concatenated values.
  • since: 11.1
  • access: public
string concatenate (array $values, [string $separator = null])
  • array $values: An array of values to concatenate.
  • string $separator: As separator to place between each value.

Redefinition of:
JDatabaseQuery::concatenate()
Concatenates an array of column names or values.
currentTimestamp (line 159)

Gets the current date and time.

  • since: 11.1
  • access: public
string currentTimestamp ()

Redefinition of:
JDatabaseQuery::currentTimestamp()
Gets the current date and time.
length (line 173)

Get the length of a string in bytes.

  • since: 11.1
  • access: public
integer length (string $value)
  • string $value: The string to measure.

Redefinition of:
JDatabaseQuery::length()
Get the length of a string in bytes.
__toString (line 50)

Magic function to convert the query to a string.

  • return: The completed query.
  • since: 11.1
  • access: public
string __toString ()

Redefinition of:
JDatabaseQuery::__toString()
Magic function to convert the query to a string.

Inherited Methods

Inherited From JDatabaseQuery

JDatabaseQuery::__construct()
JDatabaseQuery::castAsChar()
JDatabaseQuery::charLength()
JDatabaseQuery::clear()
JDatabaseQuery::columns()
JDatabaseQuery::concatenate()
JDatabaseQuery::currentTimestamp()
JDatabaseQuery::dateFormat()
JDatabaseQuery::delete()
JDatabaseQuery::dump()
JDatabaseQuery::escape()
JDatabaseQuery::from()
JDatabaseQuery::group()
JDatabaseQuery::having()
JDatabaseQuery::innerJoin()
JDatabaseQuery::insert()
JDatabaseQuery::join()
JDatabaseQuery::leftJoin()
JDatabaseQuery::length()
JDatabaseQuery::nullDate()
JDatabaseQuery::order()
JDatabaseQuery::outerJoin()
JDatabaseQuery::quote()
JDatabaseQuery::quoteName()
JDatabaseQuery::rightJoin()
JDatabaseQuery::select()
JDatabaseQuery::set()
JDatabaseQuery::union()
JDatabaseQuery::unionDistinct()
JDatabaseQuery::update()
JDatabaseQuery::values()
JDatabaseQuery::where()
JDatabaseQuery::__call()
JDatabaseQuery::__clone()
JDatabaseQuery::__get()
JDatabaseQuery::__toString()

Documentation generated on Mon, 25 Jun 2012 13:59:46 -0500 by phpDocumentor 1.4.4