# Io Reference

Databases / DBI / DBIConn

|  | An object that represents a DBI Connection.
|  | 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.