\JDatabaseQuerySqlsrv

Query Building Class.

Synopsis

class JDatabaseQuerySqlsrv extends JDatabaseQuery implements JDatabaseQueryLimitable {

• // members
• protected  $name_quotes;
• protected  $null_date;
• protected  $limit;
• protected  $offset;
• // Inherited members from JDatabaseQuery
• protected JDatabaseDriver  $db;
• protected  $sql;
• protected  $type;
• protected JDatabaseQueryElement  $element;
• protected JDatabaseQueryElement  $select;
• protected JDatabaseQueryElement  $delete;
• protected JDatabaseQueryElement  $update;
• protected JDatabaseQueryElement  $insert;
• protected JDatabaseQueryElement  $from;
• protected JDatabaseQueryElement  $join;
• protected JDatabaseQueryElement  $set;
• protected JDatabaseQueryElement  $where;
• protected JDatabaseQueryElement  $group;
• protected JDatabaseQueryElement  $having;
• protected JDatabaseQueryElement  $columns;
• protected JDatabaseQueryElement  $values;
• protected JDatabaseQueryElement  $order;
• protected   $autoIncrementField;
• protected JDatabaseQueryElement  $call;
• protected JDatabaseQueryElement  $exec;
• protected JDatabaseQueryElement  $union;
• protected JDatabaseQueryElement  $unionAll;
• // methods
• public string __toString()
• public string castAsChar()
• public string charLength()
• public string concatenate()
• public string currentTimestamp()
• public integer length()
• public string dateAdd()
• public string processLimit()
• public JDatabaseQuery setLimit()
• // Inherited methods from JDatabaseQuery
• public string __call()
• public void __construct()
• public string __toString()
• public mixed __get()
• public JDatabaseQuery call()
• public string castAsChar()
• public string charLength()
• public JDatabaseQuery clear()
• public JDatabaseQuery columns()
• public string concatenate()
• public string currentTimestamp()
• public string dateFormat()
• public string dump()
• public JDatabaseQuery delete()
• public string escape()
• public JDatabaseQuery exec()
• public JDatabaseQuery from()
• public string year()
• public string month()
• public string day()
• public string hour()
• public string minute()
• public string second()
• public JDatabaseQuery group()
• public JDatabaseQuery having()
• public JDatabaseQuery innerJoin()
• public JDatabaseQuery insert()
• public JDatabaseQuery join()
• public JDatabaseQuery leftJoin()
• public int length()
• public string nullDate()
• public JDatabaseQuery order()
• public JDatabaseQuery outerJoin()
• public string quote()
• public mixed quoteName()
• public JDatabaseQuery rightJoin()
• public JDatabaseQuery select()
• public JDatabaseQuery set()
• public JDatabaseQuery setQuery()
• public JDatabaseQuery update()
• public JDatabaseQuery values()
• public JDatabaseQuery where()
• public void __clone()
• public mixed union()
• public mixed unionDistinct()
• public string format()
• public string dateAdd()
• public mixed unionAll()
}


Hierarchy

Extends

• JDatabaseQuery

Extended by

• JDatabaseQuerySqlazure

Implements

• JDatabaseQueryLimitable

Members

protected

• $autoIncrementField —
• $call — JDatabaseQueryElement
• $columns — JDatabaseQueryElement
• $db — JDatabaseDriver
• $delete — JDatabaseQueryElement
• $element — JDatabaseQueryElement
• $exec — JDatabaseQueryElement
• $from — JDatabaseQueryElement
• $group — JDatabaseQueryElement
• $having — JDatabaseQueryElement
• $insert — JDatabaseQueryElement
• $join — JDatabaseQueryElement
• $limit — integer
• $name_quotes — string
  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.
• $null_date — string
  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.
• $offset — integer
• $order — JDatabaseQueryElement
• $select — JDatabaseQueryElement
• $set — JDatabaseQueryElement
• $sql — string
• $type — string
• $union — JDatabaseQueryElement
• $unionAll — JDatabaseQueryElement
• $update — JDatabaseQueryElement
• $values — JDatabaseQueryElement
• $where — JDatabaseQueryElement

Methods

public

• __toString() — Magic function to convert the query to a string.
• castAsChar() — Casts a value to a char.
• charLength() — Gets the function to determine the length of a character string.
• concatenate() — Concatenates an array of column names or values.
• currentTimestamp() — Gets the current date and time.
• dateAdd() — Add to the current date and time.
• length() — Get the length of a string in bytes.
• processLimit() — 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.
• setLimit() — Sets the offset and limit for the result set, if the database driver supports it.

Inherited from JDatabaseQuery

public

• __call() — Magic method to provide method alias support for quote() and quoteName().
• __clone() — Method to provide deep copy support to nested objects and arrays when cloning.
• __get() — Magic function to get protected variable value
• __toString() — Magic function to convert the query to a string.
• call() — Add a single column, or array of columns to the CALL clause of the query.
• castAsChar() — Casts a value to a char.
• charLength() — Gets the number of characters in a string.
• clear() — Clear data from the query or a specific clause of the query.
• columns() — Adds a column, or array of column names that would be used for an INSERT INTO statement.
• concatenate() — Concatenates an array of column names or values.
• currentTimestamp() — Gets the current date and time.
• dateAdd() — Add to the current date and time.
• dateFormat() — Returns a PHP date() function compliant date format for the database driver.
• day() — Used to get a string to extract day from date column.
• delete() — Add a table name to the DELETE clause of the query.
• dump() — Creates a formatted dump of the query for debugging purposes.
• escape() — Method to escape a string for usage in an SQL statement.
• exec() — Add a single column, or array of columns to the EXEC clause of the query.
• format() — Find and replace sprintf-like tokens in a format string.
• from() — Add a table to the FROM clause of the query.
• group() — Add a grouping column to the GROUP clause of the query.
• having() — A conditions to the HAVING clause of the query.
• hour() — Used to get a string to extract hour from date column.
• innerJoin() — Add an INNER JOIN clause to the query.
• insert() — Add a table name to the INSERT clause of the query.
• join() — Add a JOIN clause to the query.
• leftJoin() — Add a LEFT JOIN clause to the query.
• length() — Get the length of a string in bytes.
• minute() — Used to get a string to extract minute from date column.
• month() — Used to get a string to extract month from date column.
• nullDate() — Get the null or zero representation of a timestamp for the database driver.
• order() — Add a ordering column to the ORDER clause of the query.
• outerJoin() — Add an OUTER JOIN clause to the query.
• quote() — Method to quote and optionally escape a string to database requirements for insertion into the database.
• quoteName() — Wrap an SQL statement identifier name such as column, table or database names in quotes to prevent injection risks and reserved word conflicts.
• rightJoin() — Add a RIGHT JOIN clause to the query.
• second() — Used to get a string to extract seconds from date column.
• select() — Add a single column, or array of columns to the SELECT clause of the query.
• set() — Add a single condition string, or an array of strings to the SET clause of the query.
• setQuery() — Allows a direct query to be provided to the database driver's setQuery() method, but still allow queries to have bounded variables.
• union() — Add a query to UNION with the current query.
• unionAll() — Add a query to UNION ALL with the current query.
• unionDistinct() — Add a query to UNION DISTINCT with the current query. Simply a proxy to Union with the Distinct clause.
• update() — Add a table name to the UPDATE clause of the query.
• values() — Adds a tuple, or array of tuples that would be used as values for an INSERT INTO statement.
• where() — Add a single condition, or an array of conditions to the WHERE clause of the query.
• year() — Used to get a string to extract year from date column.