Référence de la classe JDatabaseQuerySqlsrv

Graphe d'héritage de JDatabaseQuerySqlsrv:

Fonctions membres publiques
	__toString ()
	castAsChar ($value, $len=null)
	charLength ($field, $operator=null, $condition=null)
	concatenate ($values, $separator=null)
	currentTimestamp ()
	length ($value)
	dateAdd ($date, $interval, $datePart)
	processLimit ($query, $limit, $offset=0)
	setLimit ($limit=0, $offset=0)
	Rand ()
Fonctions membres publiques hérités de JDatabaseQuery
	__call ($method, $args)
	__construct (JDatabaseDriver $db=null)
	__toString ()
	__get ($name)
	call ($columns)
	castAsChar ($value)
	charLength ($field, $operator=null, $condition=null)
	clear ($clause=null)
	columns ($columns)
	concatenate ($values, $separator=null)
	currentTimestamp ()
	dateFormat ()
	dump ()
	delete ($table=null)
	escape ($text, $extra=false)
	exec ($columns)
	from ($tables, $subQueryAlias=null)
	year ($date)
	month ($date)
	day ($date)
	hour ($date)
	minute ($date)
	second ($date)
	group ($columns)
	having ($conditions, $glue='AND')
	innerJoin ($condition)
	insert ($table, $incrementField=false)
	join ($type, $conditions)
	leftJoin ($condition)
	length ($value)
	nullDate ($quoted=true)
	order ($columns)
	outerJoin ($condition)
	quote ($text, $escape=true)
	quoteName ($name, $as=null)
	rightJoin ($condition)
	select ($columns)
	set ($conditions, $glue=',')
	setQuery ($sql)
	update ($table)
	values ($values)
	where ($conditions, $glue='AND')
	extendWhere ($outerGlue, $conditions, $innerGlue='AND')
	orWhere ($conditions, $glue='AND')
	andWhere ($conditions, $glue='OR')
	__clone ()
	union ($query, $distinct=false, $glue='')
	unionDistinct ($query, $glue='')
	format ($format)
	dateAdd ($date, $interval, $datePart)
	unionAll ($query, $distinct=false, $glue='')
	selectRowNumber ($orderBy, $orderColumnAlias)

Fonctions membres protégées
	splitSqlExpression ($string)
	fixSelectAliases ()
	fixGroupColumns ($selectColumns)
Fonctions membres protégées hérités de JDatabaseQuery
	validateRowNumber ($orderBy, $orderColumnAlias)

Attributs protégés
	$name_quotes = '`'
	$null_date = '1900-01-01 00:00:00'
	$limit = 0
	$offset = 0
Attributs protégés hérités de JDatabaseQuery
	$db = null
	$sql = null
	$type = ''
	$element = null
	$select = null
	$delete = null
	$update = null
	$insert = null
	$from = null
	$join = null
	$set = null
	$where = null
	$group = null
	$having = null
	$columns = null
	$values = null
	$order = null
	$autoIncrementField = null
	$call = null
	$exec = null
	$union = null
	$unionAll = null
	$selectRowNumber = null

Description détaillée

Query Building Class.

Depuis

1.7.0

Documentation des fonctions membres

__toString()

__toString

(

)

Magic function to convert the query to a string.

Renvoie

string The completed query.

Depuis

1.7.0

Références $columns, $query, elseif, et null.

castAsChar()

castAsChar	(		$value,
			$len = null
	)

Casts a value to a char.

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

Paramètres

string	$value	The value to cast as a char.
string	$len	The length of the char.

Renvoie

string Returns the cast value.

Depuis

1.7.0

Références $value.

charLength()

charLength	(		$field,
			$operator = null,
			$condition = null
	)

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

Paramètres

string	$field	A value.
string	$operator	Comparison operator between charLength integer value and $condition
string	$condition	Integer value to compare charLength with.

Renvoie

string The required char length call.

Depuis

1.7.0

Références $condition, et $field.

concatenate()

concatenate	(		$values,
			$separator = null
	)

Concatenates an array of column names or values.

Paramètres

array	$values	An array of values to concatenate.
string	$separator	As separator to place between each value.

Renvoie

string The concatenated values.

Depuis

1.7.0

Références $separator.

currentTimestamp()

currentTimestamp

(

)

Gets the current date and time.

Renvoie

string

Depuis

1.7.0

dateAdd()

dateAdd	(		$date,
			$interval,
			$datePart
	)

Add to the current date and time. Usage: $query->select($query->dateAdd()); Prefixing the interval with a - (negative sign) will cause subtraction to be used.

Paramètres

datetime	$date	The date to add to; type may be time or datetime.
string	$interval	The string representation of the appropriate number of units
string	$datePart	The part of the date to perform the addition on

Renvoie

string The string with the appropriate sql for addition of dates

Depuis

3.2.0

Note

Not all drivers support all units. for more information

Références $date.

fixGroupColumns()

fixGroupColumns (   $selectColumns )

protected

Add missing columns names to GROUP BY clause.

Paramètres

array[]

$selectColumns Array of columns from splitSqlExpression method.

Renvoie

JDatabaseQuery Returns this object to allow chaining.

Depuis

3.7.0

Références $i, $name, $type, et elseif.

fixSelectAliases()

fixSelectAliases ( )

protected

Add required aliases to columns for select statement in subquery.

Renvoie

array[] Array of columns with added missing aliases.

Depuis

3.7.0

Références $columns, $i, et elseif.

length()

length

(

$value

)

Get the length of a string in bytes.

Paramètres

string

$value

The string to measure.

Renvoie

integer

Depuis

1.7.0

Références $value.

processLimit()

processLimit	(		$query,
			$limit,
			$offset = 0
	)

Method to modify a query already in string format with the needed additions to make the query limited to a particular number of results, or start at a particular offset.

Paramètres

string	$query	The query in string format
integer	$limit	The limit for the result set
integer	$offset	The offset for the result set

Renvoie

string

Depuis

3.0.0

Implémente JDatabaseQueryLimitable.

Références $limit, $offset, $position, $query, et $total.

Rand()

Rand

(

)

Return correct rand() function for MSSQL.

Ensure that the rand() function is MSSQL compatible.

Usage: $query->Rand();

Renvoie

string The correct rand function.

Depuis

3.5

setLimit()

setLimit	(		$limit = 0,
			$offset = 0
	)

Sets the offset and limit for the result set, if the database driver supports it.

Usage: $query->setLimit(100, 0); (retrieve 100 rows, starting at first record) $query->setLimit(50, 50); (retrieve 50 rows, starting at 50th record)

Paramètres

integer	$limit	The limit for the result set
integer	$offset	The offset for the result set

Renvoie

JDatabaseQuery Returns this object to allow chaining.

Depuis

3.0.0

Implémente JDatabaseQueryLimitable.

Références $limit, et $offset.

splitSqlExpression()

splitSqlExpression (   $string )

protected

Split a string of sql expression into an array of individual columns. Single line or line end comments and multi line comments are stripped off. Always return at least one column.

Paramètres

string

$string

Input string of sql expression like select expression.

Renvoie

array[] The columns from the input string separated into an array.

Depuis

3.7.0

Références $columns, $current, $i, $n, $start, elseif, et null.

Documentation des champs

$limit

$limit = 0

protected

$name_quotes

$name_quotes = '`'

protected

$null_date

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

protected

$offset

$offset = 0

protected

---

La documentation de cette classe a été générée à partir du fichier suivant :

• libraries/joomla/database/query/sqlsrv.php