close
Close the connection to the database.
connect
Connect to the database server.
driver
Return database driver name.
execute(sql_query)
Perform a database query that expects no results.
Returns the number of rows affected.
option(key)
Retrieve an option value for the connection.
optionClear(key)
Clear a specific option associated with the connection.
optionPut(key,value)
Add an option key, value pair to the connection.
options
Retrieve an option list of the connection.
optionsClear
Clear all options associated with the connection
ping
Ping the database to see if it's alive.
Will return true if it is, otherwise false.
query(sql_query)
Perform a database query returning a DBIResult object.
queryOne([object], sql)
Perform a query and return the first
result.
If [object] is supplied, the object is populated with the contents of the
result, the result is marked done and the object is returned.
quote(value)
Quote a string value according to the database server's specifications.
sequenceLast([name])
Return the last inserted sequence value.
sequenceNext([name])
Return the next sequence that will be used during an INSERT query.
|