Документация по Joomla 1.7

Joomla.Platform\JDatabaseQuerySQLSrv
libraries/joomla/database/database/sqlsrvquery.php at line 21

Class JDatabaseQuerySQLSrv

JDatabaseQuery
└─JDatabaseQuerySQLSrv

public class JDatabaseQuerySQLSrv
extends JDatabaseQuery

Query Building Class.

Subpackage:
Database
Since:
11.1

Field Summary
protected string

$name_quotes

The character(s) used to quote SQL statement names such as table names or field names, etc.

protected string

$null_date

The null or zero representation of a timestamp for the database driver.

Fields inherited from Joomla.Platform\JDatabaseQuery
columns, db, delete, element, from, group, having, insert, join, order, select, set, type, update, values, where
Method Summary
string

__toString()

Magic function to convert the query to a string.

string

castAsChar(string value)

Casts a value to a char.

string

charLength(string value, mixed field)

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

string

concatenate(array values, string separator)

Concatenates an array of column names or values.

string

currentTimestamp()

Gets the current date and time.

integer

length(string value)

Get the length of a string in bytes.

Methods inherited from Joomla.Platform\JDatabaseQuery
__call, __construct, __get, __toString, castAsChar, charLength, clear, columns, concatenate, currentTimestamp, dateFormat, delete, escape, from, group, having, innerJoin, insert, join, leftJoin, length, nullDate, order, outerJoin, quote, quoteName, rightJoin, select, set, update, values, where

Field Detail

libraries/joomla/database/database/sqlsrvquery.php at line 33

name_quotes

protected string $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.

Since:
11.1

libraries/joomla/database/database/sqlsrvquery.php at line 43

null_date

protected string $null_date = '1900-01-01 00:00:00'

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

Method Detail

libraries/joomla/database/database/sqlsrvquery.php at line 52

__toString

public string __toString()

Magic function to convert the query to a string.

Returns:
The completed query.
Since:
11.1

libraries/joomla/database/database/sqlsrvquery.php at line 102

castAsChar

public string castAsChar(string value)

Casts a value to a char.

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

Parameters:
value - The value to cast as a char.
Returns:
Returns the cast value.
Since:
11.1

libraries/joomla/database/database/sqlsrvquery.php at line 116

charLength

public string charLength(string value, mixed field)

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

Parameters:
value - A value.
Returns:
The required char length call.
Since:
11.1

libraries/joomla/database/database/sqlsrvquery.php at line 131

concatenate

public string concatenate(array values, string separator)

Concatenates an array of column names or values.

Parameters:
values - An array of values to concatenate.
separator - As separator to place between each value.
Returns:
The concatenated values.
Since:
11.1

libraries/joomla/database/database/sqlsrvquery.php at line 148

currentTimestamp

public string currentTimestamp()

Gets the current date and time.

Since:
11.1

libraries/joomla/database/database/sqlsrvquery.php at line 162

length

public integer length(string value)

Get the length of a string in bytes.

Parameters:
value - The string to measure.
Since:
11.1

Документация по Joomla 1.7