DatabaseQuery Object
The DatabaseQuery object provides executing database queries.
Members Table
The following table lists the members provided by the DatabaseQuery object.
|
| 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