Please enable JavaScript to view this site.

Navigation: Advanced topics > Programming topics > Database API > Methods

Database API:Query()

Scroll Prev Next More

 

Executes an SQL Query that returns data, i.e., SELECT * FROM TableName.

Syntax

DB_Query(SQL)

Arguments

SQL

an SQL query.

Return value

A QueryResult object.

Example

Dim rs,data
set rs = DB_Query("select * from carsmake")
do while bValue(doAssignmentByRef(data,rs.fetchAssoc()))
  ResponseWrite ArrayElement(data,"id")
  ResponseWrite ArrayElement(data,"make")
loop

See also:

QueryResult object: fetchAssoc()

Database API: Exec()

Database API: Select()

QueryResult object: fetchNumeric()

QueryResult object: value()

Using SQL variables

About Database API