## Apache Zeta Components Manual :: Package Database Element Index

## Element index for package Database

#### Package indexes

- Document
- NoPackageName
- SystemInformation
- File
- UserInput
- PersistentObjectDatabaseSchemaTiein
- ConsoleTools
- Cache
- UnitTest
- Feed
- Base
- AuthenticationDatabaseTiein
- TemplateTranslationTiein
- MvcMailTiein
- MvcTools
- MvcTemplateTiein
- Reflection
- Authentication
- Execution
- TranslationCacheTiein
- Archive
- Url
- PhpGenerator
- WorkflowDatabaseTiein
- SignalSlot
- DatabaseSchema
- TreePersistentObjectTiein
- EventLog
- Tree
- Workflow
- ImageConversion
- PersistentObject
- Graph
- EventLogDatabaseTiein
- Translation
- WorkflowSignalSlotTiein
- Template
- Webdav
- Debug
- GraphDatabaseTiein
- MvcAuthenticationTiein
- MvcFeedTiein
- Mail
- TreeDatabaseTiein
- ImageAnalysis
- Search
- Configuration
- WorkflowEventLogTiein

[ a ] [ b ] [ c ] [ d ] [ e ] [ f ] [ g ] [ h ] [ i ] [ l ] [ m ] [ n ] [ o ] [ p ] [ q ] [ r ] [ s ] [ t ] [ u ] [ v ] [ w ] [ _ ]

### Letter '_'

__construct
  in file query_insert.php, method ezcQueryInsert::__construct()
  Constructs a new ezcQueryInsert that works on the database $db and with the aliases $aliases.
__construct
  in file query_select.php, method ezcQuerySelect::__construct()
  Constructs a new ezcQuery object.
__construct
  in file query_exception.php, method ezcQueryException::__construct()
  Constructs an ezcQueryException with the highlevel error message $message and the errorcode $code.
__construct
  in file query_delete.php, method ezcQueryDelete::__construct()
  Constructs a new ezcQueryDelete that works on the database $db and with the aliases $aliases.
__construct
  in file query.php, method ezcQuery::__construct()
  Constructs a new ezcQuery that works on the database $db and with the aliases $aliases.
__construct
  in file query_select_oracle.php, method ezcQuerySelectOracle::__construct()
  Constructs a new ezcQueryOracle object working on the database $db.
__construct
  in file query_select_sqlite.php, method ezcQuerySelectSqlite::__construct()
  Constructs a new ezcQuerySelectSqlite object.
__construct
  in file transaction.php, method ezcDbTransactionException::__construct()
  Constructs a new exception with the message $msg.
__construct
  in file variable_parameter.php, method ezcQueryVariableParameterException::__construct()
  Constructs an ezcQueryVariableParameterException with the method $method and the arguments $numProvided and $numExpected.
__construct
  in file sqlite.php, method ezcDbHandlerSqlite::__construct()
  Constructs a handler object from the parameters $dbParams.
__construct
  in file query_update.php, method ezcQueryUpdate::__construct()
  Constructs a new ezcQueryUpdate that works on the database $db and with the aliases $aliases.
__construct
  in file query_subselect.php, method ezcQuerySubSelect::__construct()
  Constructs a new ezcQuerySubSelect object.
__construct
  in file exception.php, method ezcDbException::__construct()
  Constructs an ezcDbAstractionException with the highlevel error message $message and the errorcode $code.
__construct
  in file pgsql.php, method ezcDbHandlerPgsql::__construct()
  Constructs a handler object from the parameters $dbParams.
__construct
  in file handler.php, method ezcDbHandler::__construct()
  Constructs a handler object.
__construct
  in file handler_not_found.php, method ezcDbHandlerNotFoundException::__construct()
  Constructs a new exception.
__construct
  in file expression_pgsql.php, method ezcQueryExpressionPgsql::__construct()
  Constructs an pgsql expression object using the db $db.
__construct
  in file expression_oracle.php, method ezcQueryExpressionOracle::__construct()
  Constructs an empty ezcQueryExpression
__construct
  in file expression.php, method ezcQueryExpression::__construct()
  Constructs an empty ezcQueryExpression
__construct
  in file identifiers.php, method ezcDbMssqlOptions::__construct()
  Creates an ezcDbMssqlOptions object with default option values.
__construct
  in file invalid.php, method ezcQueryInvalidException::__construct()
  Constructs a QueryInvalid exception with the type $type and the additional information $message.
__construct
  in file mssql.php, method ezcDbHandlerMssql::__construct()
  Constructs a handler object from the parameters $dbParams.
__construct
  in file mysql.php, method ezcDbHandlerMysql::__construct()
  Constructs a handler object from the parameters $dbParams.
__construct
  in file oracle.php, method ezcDbHandlerOracle::__construct()
  Constructs a handler object from the parameters $dbParams.
__construct
  in file missing_parameter.php, method ezcDbMissingParameterException::__construct()
  Constructs a new exception.
__construct
  in file invalid_parameter.php, method ezcQueryInvalidParameterException::__construct()
  Constructs an ezcQueryVariableParameterException.
__toString
  in file query.php, method ezcQuery::__toString()
  Return SQL string for query.
__toString
  in file query_subselect.php, method ezcQuerySubSelect::__toString()
  Returns the SQL string for the subselect.

### Letter 'a'

add
  in file expression.php, method ezcQueryExpression::add()
  Returns the SQL to add values or expressions together.
addImplementation
  in file factory.php, method ezcDbFactory::addImplementation()
  Adds a database implementation to the list of known implementations.
alias
  in file query_select_oracle.php, method ezcQuerySelectOracle::alias()
  Returns SQL to create an alias.
alias
  in file query_select.php, method ezcQuerySelect::alias()
  Returns SQL to create an alias
arrayFlatten
  in file query.php, method ezcQuery::arrayFlatten()
  Returns all the elements in $array as one large single dimensional array.
ASC
  in file query_select.php, class constant ezcQuerySelect::ASC
  Sort the result ascending.
avg
  in file expression.php, method ezcQueryExpression::avg()
  Returns the average value of a column

### Letter 'b'

beginTransaction
  in file handler.php, method ezcDbHandler::beginTransaction()
  Begins a transaction.
beginTransaction
  in file mssql.php, method ezcDbHandlerMssql::beginTransaction()
  Begins a transaction.
between
  in file expression.php, method ezcQueryExpression::between()
  Returns SQL that checks if an expression evaluates to a value between two values.
bindParam
  in file query_subselect.php, method ezcQuerySubSelect::bindParam()
  Binds the parameter $param to the specified variable name $placeHolder.
bindParam
  in file query.php, method ezcQuery::bindParam()
  Binds the parameter $param to the specified variable name $placeHolder..
bindValue
  in file query_subselect.php, method ezcQuerySubSelect::bindValue()
  Binds the value $value to the specified variable name $placeHolder.
bindValue
  in file query.php, method ezcQuery::bindValue()
  Binds the value $value to the specified variable name $placeHolder.
bitAnd
  in file expression_oracle.php, method ezcQueryExpressionOracle::bitAnd()
  Returns the SQL that performs the bitwise AND on two values.
bitAnd
  in file expression.php, method ezcQueryExpression::bitAnd()
  Returns the SQL that performs the bitwise AND on two values.
bitOr
  in file expression_oracle.php, method ezcQueryExpressionOracle::bitOr()
  Returns the SQL that performs the bitwise OR on two values.
bitOr
  in file expression.php, method ezcQueryExpression::bitOr()
  Returns the SQL that performs the bitwise OR on two values.
bitXor
  in file expression_pgsql.php, method ezcQueryExpressionPgsql::bitXor()
  Returns the SQL that performs the bitwise XOR on two values.
bitXor
  in file expression.php, method ezcQueryExpression::bitXor()
  Returns the SQL that performs the bitwise XOR on two values.
bitXor
  in file expression_oracle.php, method ezcQueryExpressionOracle::bitXor()
  Returns the SQL that performs the bitwise XOR on two values.
bitXor
  in file expression_sqlite.php, method ezcQueryExpressionSqlite::bitXor()
  Returns the SQL that performs the bitwise XOR on two values.

### Letter 'c'

ceil
  in file expression_mssql.php, method ezcQueryExpressionMssql::ceil()
  Returns the SQL to calculate the next highest integer value from the number.
ceil
  in file expression.php, method ezcQueryExpression::ceil()
  Returns the SQL to calculate the next highest integer value from the number.
ceilImpl
  in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::ceilImpl()
  Returns the next highest integer value from the number
chooseDefault
  in file instance.php, method ezcDbInstance::chooseDefault()
  Sets the database $identifier as default database instance.
commit
  in file mssql.php, method ezcDbHandlerMssql::commit()
  Commits a transaction.
commit
  in file handler.php, method ezcDbHandler::commit()
  Commits a transaction.
concat
  in file expression_pgsql.php, method ezcQueryExpressionPgsql::concat()
  Returns a series of strings concatinated
concat
  in file expression_oracle.php, method ezcQueryExpressionOracle::concat()
  Returns a series of strings concatinated
concat
  in file expression_mssql.php, method ezcQueryExpressionMssql::concat()
  Returns a series of strings concatinated
concat
  in file expression.php, method ezcQueryExpression::concat()
  Returns a series of strings concatinated
concatImpl
  in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::concatImpl()
  Returns a concattenation of the data that SQLite's concat() function receives.
count
  in file expression.php, method ezcQueryExpression::count()
  Returns the number of rows (without a NULL value) of a column
create
  in file factory.php, method ezcDbFactory::create()
  Creates and returns an instance of the specified ezcDbHandler implementation.
createDeleteQuery
  in file handler.php, method ezcDbHandler::createDeleteQuery()
  Returns a new ezcQueryDelete derived object for the correct database type.
createExpression
  in file pgsql.php, method ezcDbHandlerPgsql::createExpression()
  Returns a new ezcQueryExpression derived object with PostgreSQL implementation specifics.
createExpression
  in file sqlite.php, method ezcDbHandlerSqlite::createExpression()
  Returns a new ezcQueryExpression derived object with SQLite implementation specifics.
createExpression
  in file oracle.php, method ezcDbHandlerOracle::createExpression()
  Returns a new ezcQueryExpression derived object with Oracle implementation specifics.
createExpression
  in file handler.php, method ezcDbHandler::createExpression()
  Returns a new ezcQueryExpression derived object for the correct database type.
createExpression
  in file mssql.php, method ezcDbHandlerMssql::createExpression()
  Returns a new ezcQueryExpression derived object with SQL Server implementation specifics.
createInsertQuery
  in file handler.php, method ezcDbHandler::createInsertQuery()
  Returns a new ezcQueryInsert derived object for the correct database type.
createSelectQuery
  in file sqlite.php, method ezcDbHandlerSqlite::createSelectQuery()
  Returns a new ezcQuerySelect derived object with SQLite implementation specifics.
createSelectQuery
  in file handler.php, method ezcDbHandler::createSelectQuery()
  Returns a new ezcQuerySelect derived object for the correct database type.
createSelectQuery
  in file mssql.php, method ezcDbHandlerMssql::createSelectQuery()
  Returns a new ezcQuerySelectMssql derived object with SQL Server implementation specifics.
createSelectQuery
  in file oracle.php, method ezcDbHandlerOracle::createSelectQuery()
  Returns a new ezcQuerySelect derived object with Oracle implementation specifics.
createUpdateQuery
  in file handler.php, method ezcDbHandler::createUpdateQuery()
  Returns a new ezcQueryUpdate derived object for the correct database type.
createUtilities
  in file sqlite.php, method ezcDbHandlerSqlite::createUtilities()
  Returns a new ezcUtilities derived object with SQLite implementation specifics.
createUtilities
  in file handler.php, method ezcDbHandler::createUtilities()
  Returns a new ezcUtilities derived object for the correct database type.
createUtilities
  in file mysql.php, method ezcDbHandlerMysql::createUtilities()
  Returns a new ezcUtilities derived object for this database instance.
createUtilities
  in file oracle.php, method ezcDbHandlerOracle::createUtilities()
  Returns a new ezcUtilities derived object with Oracle implementation specifics.
createUtilities
  in file pgsql.php, method ezcDbHandlerPgsql::createUtilities()
  Returns a new ezcUtilities derived object with PostgreSQL implementation specifics.

### Letter 'd'

$db
  in file query.php, variable ezcQuery::$db
  A pointer to the database handler to use for this query.
$db
  in file expression.php, variable ezcQueryExpression::$db
  A pointer to the database handler to use for this query.
dateAdd
  in file expression_sqlite.php, method ezcQueryExpressionSqlite::dateAdd()
  Returns the SQL that adds an interval to a timestamp value.
dateAdd
  in file expression_oracle.php, method ezcQueryExpressionOracle::dateAdd()
  Returns the SQL that adds an interval to a timestamp value.
dateAdd
  in file expression_mssql.php, method ezcQueryExpressionMssql::dateAdd()
  Returns the SQL that adds an interval to a timestamp value.
dateAdd
  in file expression_pgsql.php, method ezcQueryExpressionPgsql::dateAdd()
  Returns the SQL that adds an interval to a timestamp value.
dateAdd
  in file expression.php, method ezcQueryExpression::dateAdd()
  Returns the SQL that adds an interval to a timestamp value.
dateExtract
  in file expression_pgsql.php, method ezcQueryExpressionPgsql::dateExtract()
  Returns the SQL that extracts parts from a timestamp value.
dateExtract
  in file expression_oracle.php, method ezcQueryExpressionOracle::dateExtract()
  Returns the SQL that extracts parts from a timestamp value.
dateExtract
  in file expression_mssql.php, method ezcQueryExpressionMssql::dateExtract()
  Returns the SQL that extracts parts from a timestamp value from a column.
dateExtract
  in file expression_sqlite.php, method ezcQueryExpressionSqlite::dateExtract()
  Returns the SQL that extracts parts from a timestamp value.
dateExtract
  in file expression.php, method ezcQueryExpression::dateExtract()
  Returns the SQL that extracts parts from a timestamp value.
dateSub
  in file expression_sqlite.php, method ezcQueryExpressionSqlite::dateSub()
  Returns the SQL that subtracts an interval from a timestamp value.
dateSub
  in file expression_oracle.php, method ezcQueryExpressionOracle::dateSub()
  Returns the SQL that subtracts an interval from a timestamp value.
dateSub
  in file expression_pgsql.php, method ezcQueryExpressionPgsql::dateSub()
  Returns the SQL that subtracts an interval from a timestamp value.
dateSub
  in file expression.php, method ezcQueryExpression::dateSub()
  Returns the SQL that subtracts an interval from a timestamp value.
dateSub
  in file expression_mssql.php, method ezcQueryExpressionMssql::dateSub()
  Returns the SQL that subtracts an interval from a timestamp value.
deleteFrom
  in file query_delete.php, method ezcQueryDelete::deleteFrom()
  Opens the query and sets the target table to $table.
DESC
  in file query_select.php, class constant ezcQuerySelect::DESC
  Sort the result descending.
div
  in file expression.php, method ezcQueryExpression::div()
  Returns the SQL to divide values or expressions by eachother.
doBind
  in file query.php, method ezcQuery::doBind()
  Performs binding of variables bound with bindValue and bindParam on the statement $stmt.
doJoin
  in file query_select.php, method ezcQuerySelect::doJoin()
  Returns the SQL for a join or prepares $fromString for a join.

### Letter 'e'

$expr
  in file query.php, variable ezcQuery::$expr
  The expression object for this class.
exception.php
  procedural page exception.php
expression.php
  procedural page expression.php
expression_mssql.php
  procedural page expression_mssql.php
expression_oracle.php
  procedural page expression_oracle.php
expression_pgsql.php
  procedural page expression_pgsql.php
expression_sqlite.php
  procedural page expression_sqlite.php
eq
  in file expression.php, method ezcQueryExpression::eq()
  Returns the SQL to check if two values are equal.
ezcDbException
  in file exception.php, class ezcDbException
  This class provides exception for misc errors that may occur in the component, such as errors parsing database parameters and connecting to the database.
ezcDbFactory
  in file factory.php, class ezcDbFactory
  ezcDbFactory manages the list of known database drivers and is used to create their instances.
ezcDbHandler
  in file handler.php, class ezcDbHandler
  Defines interface for all the database drivers implementations.
ezcDbHandlerMssql
  in file mssql.php, class ezcDbHandlerMssql
  MS SQL Server driver implementation.
ezcDbHandlerMysql
  in file mysql.php, class ezcDbHandlerMysql
  MySQL driver implementation
ezcDbHandlerNotFoundException
  in file handler_not_found.php, class ezcDbHandlerNotFoundException
  This exceptions is used when a database handler could not be found.
ezcDbHandlerOracle
  in file oracle.php, class ezcDbHandlerOracle
  Oracle driver implementation
ezcDbHandlerPgsql
  in file pgsql.php, class ezcDbHandlerPgsql
  PostgreSQL driver implementation
ezcDbHandlerSqlite
  in file sqlite.php, class ezcDbHandlerSqlite
  SQLite driver implementation
ezcDbInstance
  in file instance.php, class ezcDbInstance
  Holds database instances for global access throughout an application.
ezcDbMissingParameterException
  in file missing_parameter.php, class ezcDbMissingParameterException
  This exception is thrown when a database handler misses a required parameter.
ezcDbMssqlOptions
  in file identifiers.php, class ezcDbMssqlOptions
  Class containing the options for MS SQL Server connections
ezcDbTransactionException
  in file transaction.php, class ezcDbTransactionException
  This class provides exception for misc errors that may occur in the component, such as errors parsing database parameters and connecting to the database.
ezcQuery
  in file query.php, class ezcQuery
  The ezcQuery class provides the common API for all Query objects.
ezcQueryDelete
  in file query_delete.php, class ezcQueryDelete
  Class to create select database independent DELETE queries.
ezcQueryException
  in file query_exception.php, class ezcQueryException
  Base class for exceptions related to the SQL abstraction.
ezcQueryExpression
  in file expression.php, class ezcQueryExpression
  The ezcQueryExpression class is used to create database independent SQL expression.
ezcQueryExpressionMssql
  in file expression_mssql.php, class ezcQueryExpressionMssql
  The ezcQueryExpressionMssql class is used to create SQL expression for SQL Server.
ezcQueryExpressionOracle
  in file expression_oracle.php, class ezcQueryExpressionOracle
  The ezcQueryExpressionOracle class is used to create SQL expression for Oracle.
ezcQueryExpressionPgsql
  in file expression_pgsql.php, class ezcQueryExpressionPgsql
  The ezcQueryExpressionPgsql class is used to create SQL expression for PostgreSQL.
ezcQueryExpressionSqlite
  in file expression_sqlite.php, class ezcQueryExpressionSqlite
  The ezcQueryExpressionSqlite class is used to create SQL expression for SQLite.
ezcQueryInsert
  in file query_insert.php, class ezcQueryInsert
  Class to create select database independent INSERT queries.
ezcQueryInvalidException
  in file invalid.php, class ezcQueryInvalidException
  Base class for exceptions related to the SQL abstraction.
ezcQueryInvalidParameterException
  in file invalid_parameter.php, class ezcQueryInvalidParameterException
  Exception thrown when a method does not the receive correct variables it requires.
ezcQuerySelect
  in file query_select.php, class ezcQuerySelect
  Class to create select database independent SELECT queries.
ezcQuerySelectMssql
  in file query_select_mssql.php, class ezcQuerySelectMssql
  SQL Server specific implementation of ezcQuery.
ezcQuerySelectOracle
  in file query_select_oracle.php, class ezcQuerySelectOracle
  Oracle specific implementation of ezcQuery.
ezcQuerySelectSqlite
  in file query_select_sqlite.php, class ezcQuerySelectSqlite
  SQLite specific implementation of ezcQuery.
ezcQuerySqliteFunctions
  in file query_sqlite_function_implementations.php, class ezcQuerySqliteFunctions
  The ezcQueryExpressionSqlite class is used to create SQL expression for SQLite.
ezcQuerySubSelect
  in file query_subselect.php, class ezcQuerySubSelect
  This class is used to contain subselects
ezcQueryUpdate
  in file query_update.php, class ezcQueryUpdate
  Class to create select database independent UPDATE queries.
ezcQueryVariableParameterException
  in file variable_parameter.php, class ezcQueryVariableParameterException
  Exception thrown when a method does not receive the variables it requires.

### Letter 'f'

$fromString
  in file query_select.php, variable ezcQuerySelect::$fromString
  Stores the FROM part of the SQL.
$fromTables
  in file query_select_sqlite.php, variable ezcQuerySelectSqlite::$fromTables
  Store tables that appear in FROM clause.
factory.php
  procedural page factory.php
floor
  in file expression.php, method ezcQueryExpression::floor()
  Returns the SQL to calculate the next lowest integer value from the number.
floorImpl
  in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::floorImpl()
  Returns the next lowest integer value from the number
from
  in file query_select.php, method ezcQuerySelect::from()
  Select which tables you want to select from.
from
  in file query_select_sqlite.php, method ezcQuerySelectSqlite::from()
  Select which tables you want to select from.

### Letter 'g'

$groupString
  in file query_select.php, variable ezcQuerySelect::$groupString
  Stores the GROUP BY part of the SQL.
get
  in file instance.php, method ezcDbInstance::get()
  Returns the database instance $identifier.
getDummyTableName
  in file query_select.php, method ezcQuerySelect::getDummyTableName()
  Returns dummy table name.
getDummyTableName
  in file query_select_oracle.php, method ezcQuerySelectOracle::getDummyTableName()
  Returns dummy table name 'dual'.
getIdentifier
  in file expression.php, method ezcQueryExpression::getIdentifier()
  Returns the correct identifier for the alias $alias.
getIdentifier
  in file query.php, method ezcQuery::getIdentifier()
  Returns the correct identifier for the alias $alias.
getIdentifiers
  in file query.php, method ezcQuery::getIdentifiers()
  Returns the correct identifiers for the aliases found in $aliases.
getIdentifiers
  in file expression.php, method ezcQueryExpression::getIdentifiers()
  Returns the correct identifiers for the aliases found in $aliases.
getIdentifiers
  in file instance.php, method ezcDbInstance::getIdentifiers()
  Returns the identifiers of the registered database instances.
getImplementations
  in file factory.php, method ezcDbFactory::getImplementations()
  Returns a list with supported database implementations.
getName
  in file sqlite.php, method ezcDbHandlerSqlite::getName()
  Returns 'sqlite'.
getName
  in file pgsql.php, method ezcDbHandlerPgsql::getName()
  Returns 'pgsql'.
getName
  in file mysql.php, method ezcDbHandlerMysql::getName()
  Returns 'mysql'.
getName
  in file oracle.php, method ezcDbHandlerOracle::getName()
  Returns 'oracle'.
getName
  in file mssql.php, method ezcDbHandlerMssql::getName()
  Returns 'mssql'.
getQuery
  in file query_select_oracle.php, method ezcQuerySelectOracle::getQuery()
  Transforms the query from the parent to provide LIMIT functionality.
getQuery
  in file query_subselect.php, method ezcQuerySubSelect::getQuery()
  Returns the SQL string for the subselect.
getQuery
  in file query_select_mssql.php, method ezcQuerySelectMssql::getQuery()
  Transforms the query from the parent to provide LIMIT functionality.
getQuery
  in file query_update.php, method ezcQueryUpdate::getQuery()
  Returns the query string for this query object.
getQuery
  in file query_insert.php, method ezcQueryInsert::getQuery()
  Returns the query string for this query object.
getQuery
  in file query_delete.php, method ezcQueryDelete::getQuery()
  Returns the query string for this query object.
getQuery
  in file query_select.php, method ezcQuerySelect::getQuery()
  Returns the complete select query string.
getQuery
  in file query.php, method ezcQuery::getQuery()
  Returns the query string for this query object.
groupBy
  in file query_select.php, method ezcQuerySelect::groupBy()
  Returns SQL that groups the result set by a given column.
gt
  in file expression.php, method ezcQueryExpression::gt()
  Returns the SQL to check if one value is greater than another value.
gte
  in file expression.php, method ezcQueryExpression::gte()
  Returns the SQL to check if one value is greater than or equal to another value.

### Letter 'h'

$havingString
  in file query_select.php, variable ezcQuerySelect::$havingString
  Stores the HAVING part of SQL
handler_not_found.php
  procedural page handler_not_found.php
handler.php
  procedural page handler.php
hasAliases
  in file query.php, method ezcQuery::hasAliases()
  Returns true if this object has aliases.
hasAliases
  in file expression.php, method ezcQueryExpression::hasAliases()
  Returns true if this object has aliases.
having
  in file query_select.php, method ezcQuerySelect::having()
  Returns SQL that set having by a given expression.

### Letter 'i'

$identifierQuoteChars
  in file mysql.php, variable ezcDbHandlerMysql::$identifierQuoteChars
  Characters to quote identifiers with. Should be overwritten in handler implementation, if different for a specific handler. In some cases the quoting start and end characters differ (e.g. ODBC), but mostly they are the same.
$identifierQuoteChars
  in file handler.php, variable ezcDbHandler::$identifierQuoteChars
  Characters to quote identifiers with. Should be overwritten in handler implementation, if different for a specific handler. In some cases the quoting start and end characters differ (e.g. ODBC), but mostly they are the same.
$intervalMap
  in file expression_sqlite.php, variable ezcQueryExpressionSqlite::$intervalMap
  Contains an interval map from generic intervals to SQLite native intervals.
$intervalMap
  in file expression_mssql.php, variable ezcQueryExpressionMssql::$intervalMap
  Contains an interval map from generic intervals to MS SQL native intervals.
$intervalMap
  in file expression.php, variable ezcQueryExpression::$intervalMap
  Contains an interval map from generic intervals to MySQL native intervals.
invalid.php
  procedural page invalid.php
invalid_parameter.php
  procedural page invalid_parameter.php
instance.php
  procedural page instance.php
identifiers.php
  procedural page identifiers.php
in
  in file expression_oracle.php, method ezcQueryExpressionOracle::in()
  Returns the SQL to check if a value is one in a set of given values.
in
  in file expression.php, method ezcQueryExpression::in()
  Returns the SQL to check if a value is one in a set of given values..
innerJoin
  in file query_select.php, method ezcQuerySelect::innerJoin()
  Returns the SQL for an inner join or prepares $fromString for an inner join.
insertInto
  in file query_insert.php, method ezcQueryInsert::insertInto()
  Opens the query and sets the target table to $table.
isNull
  in file expression.php, method ezcQueryExpression::isNull()
  Returns SQL that checks if a expression is null.

### Letter 'l'

$lastInvokedMethod
  in file query_select.php, variable ezcQuerySelect::$lastInvokedMethod
  Stores the name of last invoked SQL clause method.
$limitString
  in file query_select.php, variable ezcQuerySelect::$limitString
  Stores the LIMIT part of the SQL.
lAnd
  in file expression.php, method ezcQueryExpression::lAnd()
  Returns the SQL to bind logical expressions together using a logical and.
leftJoin
  in file query_select.php, method ezcQuerySelect::leftJoin()
  Returns the SQL for a left join or prepares $fromString for a left join.
length
  in file expression.php, method ezcQueryExpression::length()
  Returns the length of text field $column
length
  in file expression_mssql.php, method ezcQueryExpressionMssql::length()
  Returns the length of a text field.
like
  in file expression.php, method ezcQueryExpression::like()
  Match a partial string in a column.
limit
  in file query_select.php, method ezcQuerySelect::limit()
  Returns SQL that limits the result set.
limit
  in file query_select_oracle.php, method ezcQuerySelectOracle::limit()
  Returns SQL that limits the result set.
limit
  in file query_select_mssql.php, method ezcQuerySelectMssql::limit()
  Returns SQL that limits the result set.
lOr
  in file expression.php, method ezcQueryExpression::lOr()
  Returns the SQL to bind logical expressions together using a logical or.
lower
  in file expression.php, method ezcQueryExpression::lower()
  Returns the SQL to change all characters to lowercase
lt
  in file expression.php, method ezcQueryExpression::lt()
  Returns the SQL to check if one value is less than another value.
lte
  in file expression.php, method ezcQueryExpression::lte()
  Returns the SQL to check if one value is less than or equal to another value.

### Letter 'm'

missing_parameter.php
  procedural page missing_parameter.php
mssql.php
  procedural page mssql.php
mysql.php
  procedural page mysql.php
max
  in file expression.php, method ezcQueryExpression::max()
  Returns the highest value of a column
md5
  in file expression_pgsql.php, method ezcQueryExpressionPgsql::md5()
  Returns the md5 sum of the field $column.
md5
  in file expression.php, method ezcQueryExpression::md5()
  Returns the md5 sum of $column.
md5
  in file expression_mssql.php, method ezcQueryExpressionMssql::md5()
  Returns the md5 sum of a field.
md5Impl
  in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::md5Impl()
  Returns the md5 sum of the data that SQLite's md5() function receives.
min
  in file expression.php, method ezcQueryExpression::min()
  Returns the lowest value of a column
mod
  in file expression_mssql.php, method ezcQueryExpressionMssql::mod()
  Returns the remainder of the division operation $expression1 / $expression2.
mod
  in file expression.php, method ezcQueryExpression::mod()
  Returns the remainder of the division operation $expression1 / $expression2.
modImpl
  in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::modImpl()
  Returns the modules of the data that SQLite's mod() function receives.
mul
  in file expression.php, method ezcQueryExpression::mul()
  Returns the SQL to multiply values or expressions by eachother.

### Letter 'n'

neq
  in file expression.php, method ezcQueryExpression::neq()
  Returns the SQL to check if two values are unequal.
not
  in file expression.php, method ezcQueryExpression::not()
  Returns the SQL for a logical not, negating the $expression.
now
  in file expression_pgsql.php, method ezcQueryExpressionPgsql::now()
  Returns the current system date and time in the database internal format.
now
  in file expression_sqlite.php, method ezcQueryExpressionSqlite::now()
  Returns the current system date and time in the database internal format.
now
  in file expression_mssql.php, method ezcQueryExpressionMssql::now()
  Returns the current system date and time in the database internal format.
now
  in file expression.php, method ezcQueryExpression::now()
  Returns the current system date and time in the database internal format.
now
  in file expression_oracle.php, method ezcQueryExpressionOracle::now()
  Returns the current system date and time in the database internal format.

### Letter 'o'

$options
  in file mssql.php, variable ezcDbHandlerMssql::$options
  Contains the options that are used to set up handler.
$orderString
  in file query_select.php, variable ezcQuerySelect::$orderString
  Stores the ORDER BY part of the SQL.
$outerQuery
  in file query_subselect.php, variable ezcQuerySubSelect::$outerQuery
  Holds the outer query.
oracle.php
  procedural page oracle.php
orderBy
  in file query_select.php, method ezcQuerySelect::orderBy()
  Returns SQL that orders the result set by a given column.
orderBy
  in file query_select_mssql.php, method ezcQuerySelectMssql::orderBy()
  Saves the ordered columns in an internal array so we can invert that order if we need to in the limit() workaround

### Letter 'p'

pgsql.php
  procedural page pgsql.php
parseDSN
  in file factory.php, method ezcDbFactory::parseDSN()
  Returns the Data Source Name as a structure containing the various parts of the DSN.
position
  in file expression_mssql.php, method ezcQueryExpressionMssql::position()
  Returns the SQL to locate the position of the first occurrence of a substring
position
  in file expression.php, method ezcQueryExpression::position()
  Returns the SQL to locate the position of the first occurrence of a substring
position
  in file expression_oracle.php, method ezcQueryExpressionOracle::position()
  Returns the SQL to locate the position of the first occurrence of a substring
position
  in file expression_pgsql.php, method ezcQueryExpressionPgsql::position()
  Returns the SQL to locate the position of the first occurrence of a substring
positionImpl
  in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::positionImpl()
  Returns the SQL to locate the position of the first occurrence of a substring
prepare
  in file query_select_oracle.php, method ezcQuerySelectOracle::prepare()
  Handles preparing query.
prepare
  in file query.php, method ezcQuery::prepare()
  Returns a prepared statement from this query which can be used for execution.
processLimitOffset
  in file oracle.php, method ezcDbHandlerOracle::processLimitOffset()
  Returns an SQL query with LIMIT/OFFSET functionality appended.

### Letter 'q'

$quoteValues
  in file expression.php, variable ezcQueryExpression::$quoteValues
  The flag that switch quoting mode for values provided by user in miscelaneous SQL functions.
query_exception.php
  procedural page query_exception.php
query_select_mssql.php
  procedural page query_select_mssql.php
query_select_oracle.php
  procedural page query_select_oracle.php
query_select_sqlite.php
  procedural page query_select_sqlite.php
query_sqlite_function_implementations.php
  procedural page query_sqlite_function_implementations.php
query.php
  procedural page query.php
query_delete.php
  procedural page query_delete.php
query_insert.php
  procedural page query_insert.php
query_select.php
  procedural page query_select.php
query_subselect.php
  procedural page query_subselect.php
query_update.php
  procedural page query_update.php
quote
  in file oracle.php, method ezcDbHandlerOracle::quote()
  Returns $str quoted for the Oracle database.
quoteIdentifier
  in file handler.php, method ezcDbHandler::quoteIdentifier()
  Returns the quoted version of an identifier to be used in an SQL query.
QUOTES_COMPLIANT
  in file identifiers.php, class constant ezcDbMssqlOptions::QUOTES_COMPLIANT
  Constant represents mode of identifiers quoting that compliant to SQL92.
QUOTES_GUESS
  in file identifiers.php, class constant ezcDbMssqlOptions::QUOTES_GUESS
  Recommended ( and default ) mode for identifiers quoting.
QUOTES_LEGACY
  in file identifiers.php, class constant ezcDbMssqlOptions::QUOTES_LEGACY
  Constant represents mode of identifiers quoting that corresponds to QUOTE_IDENTIFIERS OFF for MS SQL Server connection.
QUOTES_UNTOUCHED
  in file identifiers.php, class constant ezcDbMssqlOptions::QUOTES_UNTOUCHED
  Constant represents mode of identifiers quoting that not touch any settings related to quoting identifiers.

### Letter 'r'

$rightJoins
  in file query_select_sqlite.php, variable ezcQuerySelectSqlite::$rightJoins
  Store info for building emulation of right joins in FROM clause.
reset
  in file query_select_oracle.php, method ezcQuerySelectOracle::reset()
  Resets the query object for reuse.
reset
  in file query_select_sqlite.php, method ezcQuerySelectSqlite::reset()
  Resets the query object for reuse.
reset
  in file query_select_mssql.php, method ezcQuerySelectMssql::reset()
  Resets the query object for reuse.
reset
  in file query_select.php, method ezcQuerySelect::reset()
  Resets the query object for reuse.
reset
  in file instance.php, method ezcDbInstance::reset()
  Resets this object to its initial state.
resetBinds
  in file query.php, method ezcQuery::resetBinds()
  Resets the bound values and parameters to empty.
resetDefault
  in file instance.php, method ezcDbInstance::resetDefault()
  Resets the default instance holder.
rightJoin
  in file query_select.php, method ezcQuerySelect::rightJoin()
  Returns the SQL for a right join or prepares $fromString for a right join.
rightJoin
  in file query_select_sqlite.php, method ezcQuerySelectSqlite::rightJoin()
  Returns the SQL for a right join or prepares $fromString for a right join.
rollback
  in file handler.php, method ezcDbHandler::rollback()
  Rollback a transaction.
rollback
  in file mssql.php, method ezcDbHandlerMssql::rollback()
  Rollback a transaction.
round
  in file expression.php, method ezcQueryExpression::round()
  Rounds a numeric field to the number of decimals specified.

### Letter 's'

$selectString
  in file query_select.php, variable ezcQuerySelect::$selectString
  Stores the SELECT part of the SQL.
sqlite.php
  procedural page sqlite.php
searchedCase
  in file expression.php, method ezcQueryExpression::searchedCase()
  Returns a searched CASE statement.
select
  in file query_select.php, method ezcQuerySelect::select()
  Opens the query and selects which columns you want to return with the query.
selectDistinct
  in file query_select.php, method ezcQuerySelect::selectDistinct()
  Opens the query and uses a distinct select on the columns you want to return with the query.
set
  in file query_insert.php, method ezcQueryInsert::set()
  The insert query will set the column $column to the value $expression.
set
  in file query_update.php, method ezcQueryUpdate::set()
  The update query will set the column $column to the value $expression.
set
  in file instance.php, method ezcDbInstance::set()
  Adds the database handler $db to the list of known instances.
setAliases
  in file expression.php, method ezcQueryExpression::setAliases()
  Sets the aliases $aliases for this object.
setAliases
  in file query.php, method ezcQuery::setAliases()
  Sets the aliases $aliases for this object.
setOptions
  in file mssql.php, method ezcDbHandlerMssql::setOptions()
  Associates an option object with this handler and changes settings for opened connections.
setValuesQuoting
  in file expression.php, method ezcQueryExpression::setValuesQuoting()
  Sets the mode of quoting for parameters passed to SQL functions and operators.
sub
  in file expression.php, method ezcQueryExpression::sub()
  Returns the SQL to subtract values or expressions from eachother.
subSelect
  in file query_subselect.php, method ezcQuerySubSelect::subSelect()
  Returns ezcQuerySubSelect of deeper level.
subSelect
  in file query.php, method ezcQuery::subSelect()
  Returns the ezcQuerySubSelect query object.
subString
  in file expression.php, method ezcQueryExpression::subString()
  Returns part of a string.
subString
  in file expression_mssql.php, method ezcQueryExpressionMssql::subString()
  Returns part of a string.
subString
  in file expression_sqlite.php, method ezcQueryExpressionSqlite::subString()
  Returns part of a string.
subString
  in file expression_oracle.php, method ezcQueryExpressionOracle::subString()
  Returns part of a string.
subString
  in file expression_pgsql.php, method ezcQueryExpressionPgsql::subString()
  Returns part of a string.
sum
  in file expression.php, method ezcQueryExpression::sum()
  Returns the total sum of a column

### Letter 't'

$transactionErrorFlag
  in file handler.php, variable ezcDbHandler::$transactionErrorFlag
  This flag is set to true when an SQL query has failed.
$transactionNestingLevel
  in file handler.php, variable ezcDbHandler::$transactionNestingLevel
  Stores the transaction nesting level.
transaction.php
  procedural page transaction.php
toUnixTimestampImpl
  in file query_sqlite_function_implementations.php, method ezcQuerySqliteFunctions::toUnixTimestampImpl()
  Returns the unix timestamp belonging to a date/time spec

### Letter 'u'

unixTimestamp
  in file expression_pgsql.php, method ezcQueryExpressionPgsql::unixTimestamp()
  Returns the SQL that converts a timestamp value to a unix timestamp.
unixTimestamp
  in file expression_sqlite.php, method ezcQueryExpressionSqlite::unixTimestamp()
  Returns the SQL that converts a timestamp value to a unix timestamp.
unixTimestamp
  in file expression.php, method ezcQueryExpression::unixTimestamp()
  Returns the SQL that converts a timestamp value to a unix timestamp.
unixTimestamp
  in file expression_oracle.php, method ezcQueryExpressionOracle::unixTimestamp()
  Returns the SQL that converts a timestamp value to a unix timestamp.
unixTimestamp
  in file expression_mssql.php, method ezcQueryExpressionMssql::unixTimestamp()
  Returns the SQL that converts a timestamp value to number of seconds since 1970-01-01 00:00:00-00.
update
  in file query_update.php, method ezcQueryUpdate::update()
  Opens the query and sets the target table to $table.
upper
  in file expression.php, method ezcQueryExpression::upper()
  Returns the SQL to change all characters to uppercase

### Letter 'v'

$values
  in file query_insert.php, variable ezcQueryInsert::$values
  Holds the columns and the values that should inserted into the the table.
variable_parameter.php
  procedural page variable_parameter.php

### Letter 'w'

$whereString
  in file query_update.php, variable ezcQueryUpdate::$whereString
  Stores the WHERE part of the SQL.
$whereString
  in file query_delete.php, variable ezcQueryDelete::$whereString
  Stores the WHERE part of the SQL.
$whereString
  in file query_select.php, variable ezcQuerySelect::$whereString
  Stores the WHERE part of the SQL.
where
  in file query_update.php, method ezcQueryUpdate::where()
  Adds a where clause with logical expressions to the query.
where
  in file query_delete.php, method ezcQueryDelete::where()
  Adds a where clause with logical expressions to the query.
where
  in file query_select.php, method ezcQuerySelect::where()
  Adds a where clause with logical expressions to the query.

Documentation generated by phpDocumentor 1.4.3