Zrinity is the leader in enterprise-class email marketing
management solutions and content management solutions for marketing professionals and developers worldwide.
QueryBrowse is a ColdFusion Custom tag allows a developer to easily
display the contents of the query in a table, with a "click for next n" browsing features.
Attributes
Attribute Name
Required
Data Type
Notes
QUERY
yes
query
The name of a query containing data
FIELDS
no
list
Specifies the fields you want to display in the table. If no fields are passed in all columns in the query will be used.
ROWS
no
numeric
How many rows to display on one page, default is 25
LINKFIELD
no
string
The name of a field that will contain a hyperlink
LINKURL
if LINKFIELD is specified
url
The url prefix to the next page, don't worry about dynamic values thats what the rest of the link attributes are for.
LINKPARAMS
if LINKFIELD is specified
list
A list of fields that will be used in the link, for instance if you have linkurl="page.cfm" and linkparams="PageID" then QueryBrowse will generate a link that looks like page.cfm?PageID=n where n is the value of page ID for the current row.
LINKATTRIBUTES
no
string
Used to specify attributes other than HREF for the A tag. Possible value might be linkattributes="target='_blank' style='mylinkstyle'"
TABLEATTRIBUTES
no
string
Used to specify attributes in the TABLE tag generated by QueryBrowse, example values might be tableattributes="border=0 class='myTableStyle'"
SHOWHEADER
no
boolean
Toggles whether or not to show a header row with the names of each column. Default is true
HEADERROWATTRIBUTES
no
string
Used to specify TR attributes for the header row. Eg. headerrowattributes="class='header'"
HEADERCELLATTRIBUTES
no
string
Used to specify TD attributes for the header row. Eg. headercellattributes="bgcolor='silver'"
ROWATTRIBUTES
no
string
Used to specify the TR attributes of a dynamic row.
ALTROWATTRIBUTES
no
string
If specified these attributes will be applied to every other row, this is typically used for alternating colors EG: altrowattributes="bgcolor='silver'"
CELLATTRIBUTES
no
string
Used to specify the TD attributes of a dynamic cell.
SHOWLINENUMBERS
no
boolean
Toggles whether or not it will display line numbers. Default is true
NUMBERHEADERVALUE
no
string
A string of text that will show up in the header cell for the line number column
LINENUMBERCELLATTRIBUTES
no
string
Used to specify the TD attributes of the cell displaying the line numbers. Default is the value of the CELLATTRIBUTES attribute.
PAGELINKATTRIBUTES
no
string
Used to specify A tag attributes for the page number links at the bottom
Example
SELECT ContactID, Name, Email, Address, Phone, City, State, Zip
FROM contacts
Might generate code that looks like... Â Â Â (depending on how you define the style classes)
Print this page
