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()
•QueryResult object: fetchNumeric()