Returns: A SESAM "result identifier" on success, or FALSE on error.
A "result_id" resource is used by other functions to
retrieve the query results.
sesam_query() sends a query to
the currently active database on the server. It can execute
both "immediate" SQL statements and "select type" queries. If
an "immediate" statement is executed, then no cursor is
allocated, and any subsequent
sesam_fetch_row() or
sesam_fetch_result() call will return an empty result
(zero columns, indicating end-of-result). For "select type"
statements, a result descriptor and a (scrollable or
sequential, depending on the optional boolean scrollable parameter) cursor will be
allocated. If scrollable is
omitted, the cursor will be sequential.
When using "scrollable" cursors, the cursor can be
freely positioned on the result set. For each "scrollable"
query, there are global default values for the scrolling type
(initialized to: SESAM_SEEK_NEXT)
and the scrolling offset which can either be set once by
sesam_seek_row() or each time when fetching a row
using sesam_fetch_row().
For "immediate" statements, the number of affected rows
is saved for retrieval by the
sesam_affected_rows() function.
See also: sesam_fetch_row() and
sesam_fetch_result().