The QUERY tag sends a datasource query through to the specified resource. The
QUERY tag supports access to any ODBC compliant database, FTP servers, HTTP servers,
POP3 servers, NNTP servers and variables containing HTML text.
A heighten security, a user context can be applied to the tag.
Attributes:
NAME
variable to receive result
DATASOURCE
datasource to query
DETAILS
variable to receive debugging details about this query
CACHE
cache this queries result; YES or NO
USERNAME
variable or string representing username
PASSWORD
variable or string representing password
IDENTITY
variable to accept the identity value
MAXTEXTSIZE
maximum text size (of a field) to receive (overrides default)
The following is an example of QUERY;
<!--- Access to ODBC ---> <SAQUERY NAME=DbQuery DATASOURCE="SomeDNS">
SELECT * FROM table </SAQUERY>
<!--- Access to FTP (returns directory listing) --->
<!--- See FTP tag for format of listing ---> <SAQUERY NAME=ftpQuery DATASOURCE="ftp://server.com/dir/subDir"
USERNAME="user" PASSWORD="pass"> </SAQUERY>
<!--- Access to HTTP ---> <SAQUERY NAME=htQuery DATASOURCE="http://server.com">
SELECT * FROM P{3} </SAQUERY>
<!--- Access to HTML text ---> <SAQUERY NAME=htQuery DATASOURCE="html:" & htQuery>
SELECT P{2} FROM
(SELECT TR{1} FROM table{3}) </SAQUERY>
