Deprecated
This function is deprecated and we recommend using the DB:Query() function from Database API.
Selects all records from the table.
Syntax
QueryAll()
Arguments
No arguments.
Return value
Returns the recordset on success or FALSE on error.
Example
Send mass email to all users:
Response.Flush
set data = dal.Table("users").QueryAll()
while not data.eof
' send the email
rmail("to")=data("email")
rmail("subject")="Sample subject"
rmail("body")="Sample body"
set result = runner_mail(rmail)
' if error happened print a message on the web page
if not result("mailed") then
response.write result("message") & "<br>"
response.flush
end if
data.MoveNext
wend
data.close: data=nothing
See also: