[Top]
Sql
Sql.Sql
|
Method Sql.Sql()->big_typed_query()
- Method
big_typed_query
int|object big_typed_query(object|string q, mixed ... extraargs)
- Description
Sends an SQL query synchronously to the underlying SQL-server and
returns the results in typed mode.
For the arguments, please see the query() function.
The result is returned as an Sql.sql_result object in typed
mode. This allows for having some more info about the result as
well as processing the result in a streaming fashion, although the
result itself wasn't obtained streamingly from the server. Returns
0 if the query didn't return any result (e.g. INSERT
or similar).
- Note
Typed mode is not supported by all sql databases. If not
supported, an error is thrown.
- Note
Despite the name, this function is not only useful for "big"
queries. It typically has less overhead than typed_query also
for ones that return only a few rows.
- See also
query , typed_query , big_query , streaming_query
|