Executes the SQL and retuns a subset of the rows selected.
TList
executeQueryForList
(
IDbConnection $connection,
mixed $parameter, [
TList $result =
null], [
integer $skip =
-1], [
integer $max =
-1])
-
IDbConnection
$connection: database connection to execute the query
-
mixed
$parameter: The object used to set the parameters in the SQL.
-
TList
$result: A list to populate the result with.
-
integer
$skip: The number of rows to skip over.
-
integer
$max: The maximum number of rows to return.
Executes the SQL and retuns all rows selected in a map that is keyed on
the property named in the <tt>$keyProperty</tt> parameter. The value at each key will be the value of the property specified in the <tt>$valueProperty</tt> parameter. If <tt>$valueProperty</tt> is <tt>null</tt>, the entire result object will be entered.
TMap
executeQueryForMap
(
IDbConnection $connection,
mixed $parameter,
string $keyProperty, [
string $valueProperty =
null])
-
IDbConnection
$connection: database connection to execute the query
-
mixed
$parameter: The object used to set the parameters in the SQL.
-
string
$keyProperty: The property of the result object to be used as the key.
-
string
$valueProperty: The property of the result object to be used as the value (or null)
Executes an SQL statement that returns a single row as an object of the type of the <tt>$result</tt> passed in as a parameter.
object result.
executeQueryForObject
(IDbConnection $connection, mixed $parameter, [object The $result = null])
-
IDbConnection
$connection: database connection to execute the query
-
mixed
$parameter: The object used to set the parameters in the SQL.
-
object The
$result: result object.
Execute an update statement. Also used for delete statement. Return the number of row effected.
integer
executeUpdate
(IDbConnection $connection, mixed $parameter)
-
IDbConnection
$connection: database connection to execute the query
-
mixed
$parameter: The object used to set the parameters in the SQL.