Please enable JavaScript to view this site.

Navigation: » No topics above this level «

DAL method: QueryAll() (Deprecated)

Scroll Prev Next More

 

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:

runner_mail function

DAL Method: Query

DAL Method: CustomQuery

DB API: Query

Database API

About Data Access Layer