# DatabaseQuery Object The DatabaseQuery object provides executing database queries. Members Table The following table lists the members provided by the DatabaseQuery object.
Members
Methods | Description
Open | Opens a query that returns a result.
Close | Closes an opened query.
Execute | Executes a query that does not return a result.
GetValue | Queries for a single value.
GetValueArray | Queries for a single row.
GetColumnData | Returns a column of the currently opened query.
GetRowData | Returns a row of the currently opened query.
MoveFirst | Moves to the first row of the currently opened query.
MoveLast | Moves to the last row of the currently opened query.
MoveNext | Moves to the next row of the currently opened query.
MovePrev | Moves to the previous row of the currently opened query.
Remarks This object is returned by the CreateDatabaseQuery method. Use the DatabaseQuery object to execute database queries. Examples The following example opens a database query and displays the last returned row.
    <SCRIPT TYPE="text/javascript">
    window.external.InitScriptInterface();
    dbquery = SiteCafe.Server.CreateDatabaseQuery();
    dbquery.Open("SELECT * FROM users");
    dbquery.MoveLast();
    alert(dbquery.GetRowData());
    </SCRIPT>
Applies to SiteKiosk v6.2 (and later versions). Back to top