SQL Filters

Do not edit this page! It is auto-generated by reflecting the Denina assembly, and changes will be over-written. To modifiy this documentation, the documentation attributes of the filters should be modified. See Embedded Documentation for more information.

Filter Purpose:
For working with SQL databases.

• GetXml
• GetTable

---

GetXml

Executes SQL against the specified connection string and returns an XML recordset.

Arguments

Name	Required	Description
connection	true	The name of a connection string key from the application configuration. This connection string name must be enabled via a Sql.AllowedConnectionStrings setting. Alternately, this can be a raw connection string.
sql	false	The SQL to execute. If omitted, the input string will be used.

Samples

Input	SELECT * FROM TableName
Command	Sql.GetXml -connection:myConnectionString
Output	An XML string

Input	None
Command	Sql.GetXml -connection:myConnectionString -sql:"SELECT * FROM TableName"
Output	An XML string

---

GetTable

Executes SQL against the specified connection string and returns an HTML table of the results. TH tags contain the field names of the returned dataset and each TD and TH has a CSS class of "column-field-name" for styling.

Arguments

Name	Required	Description
connecton	true	The name of a connection string key from the application configuration. This connection string name must be enabled via a Sql.AllowedConnectionStrings setting. Alternately, this can be a raw connection string.
sql	false	The SQL to execute. If omitted, the input string will be used.
class	false	A CSS class name for the TABLE tag.

Samples

Input	SELECT * FROM TableName
Command	Sql.GetXml -connection:myConnectionString
Output	An HTML table

Input	None
Command	Sql.GetXml -connection:myConnectionString -sql:"SELECT * FROM TableName" -class:table
Output	An HTML table with a "class" attribute of "table"