QueryRelease Wrapper

Example: /playground/QueryWrapper

Content can be conditionally displayed based on the arithmetic comparison of a stored number with the results of a query or VariableTag. Optionally, a message can be displayed if the result is calculated to not be true.

Warning: Potential for abuse exists in the form of an SQL injection attack.

Comparison order: # > Query ;
Number Operator Query/VariableTag

Usage: Insert the Query Wrapper placeholder and edit the 'content' in the “query release wrapper” style using the xstandard interface.

Edit the style by doubleclick the top left of the orange style OR right-click on the orange box, choose tag list, choose the div tag, and choose edit

The Div has a class of queryrelease.

The Div has Custom attributes:

• inVisibleMessage : Optional Message if query operator number does not evaluate to be true. Can contain escaped HTML.
• number : any non-optional integer number used in evaluation
• value : string or variable tag - must user operators exists, same, or different
• operator : must be ONE of the following < <= > >= = <> (less then, less then or equal to, greater then, greater then or equal to, equal, not equal) stored as escaped HTML
  OR 'exists'. If the operator is 'exists' then then if the query is not blank, the comparison is true.
  same requires value not number.
  different requires value not number.
• query : SQL statement against primary database, where the first row returned, first element returned is used in the evaluation.

  The query (row 1, column 1 returned) compared using the operator to the number (comparison integer) and evaluated. IF the query operator number evaluates to be true, the result of the query can optionally be inserted into the wrapper by putting qAMNT in the wrapped text (which will be replaced).
  OR a VariableTag

This demonstrates the render.

<div class="queryrelease" inVisibleMessage="This content is conditionally visible. - it appears there are less then 100 pages" number="100" operator="&lt;" query="SELECT COUNT(*) as qAMNT FROM web_page">
<p>query release - it appears there are more then 100 pages in this website.</p>
<!-- queryrelease -->
</div>

VariableTag example:

<div class="queryrelease" inVisibleMessage="You're not logged in, or not from washington state" operator="same" query="" value="WA">
<p>I'm from Washington State too!</p>
<!-- queryrelease -->
</div>