Deprecated
This function is deprecated, and we recommend using the DB:Query() function from Database API.
Runs a custom SQL query.
Syntax
CustomQuery(sql)
Arguments
sql
a SELECT clause. Example: "select * from UsersTable where ID=32".
Return value
Returns the recordset.
Example 1
A query that doesn't return data:
sql = "update Users set active=0 where id=32"
CustomQuery(sql)
Example 2
A query that returns data:
sql = "select count(*) as c from orders group by customerid"
set rs = CustomQuery(sql)
Response.Write "Number of customers: " & rs("c")
See also:
