Function queryRow
Executes a one-off SQL command and returns the first row received, or null if none. Useful for the case where you expect a (possibly empty) result set, and you're either only expecting one row, or only care about the first row.
Use this method when you are not going to be using the same command repeatedly. This method will throw if the SQL command does not produce a result set.
If there are long data items among the expected result columns you can specify that they are to be subject to chunked transfer via a delegate.
Prototype
std
Connection conn,
string sql,
ColumnSpecialization[] csa = null
);
Parameters
| Name | Description |
|---|---|
| csa | An optional array of ColumnSpecialization structs. |
Returns
Nullable!Row: This will be null (check via Nullable.isNull) if the query resulted in an empty result set.