The DatabaseQuery object provides executing database queries.
The following table lists the members provided by the DatabaseQuery object.
||Opens a query that returns a result.
||Closes an opened query.
||Executes a query that does not return a result.
||Queries for a single value.
||Queries for a single row.
||Returns a column of the currently opened query.
||Returns a row of the currently opened query.
||Moves to the first row of the currently opened query.
||Moves to the last row of the currently opened query.
||Moves to the next row of the currently opened query.
||Moves to the previous row of the currently opened query.
This object is returned by the CreateDatabaseQuery method.
Use the DatabaseQuery object to execute database queries.
The following example opens a database query and displays the last returned row.
dbquery = SiteCafe.Server.CreateDatabaseQuery();
dbquery.Open("SELECT * FROM users");
SiteKiosk v6.2 (and later versions).
Back to top