<xsql:set-stylesheet-param>

Sets the value of a top-level XSLT stylesheet parameter.

XSQL Syntax

<xsql:set-stylesheet-param
  name="string"
  [ ignore-empty-value="boolean" ]
  [ value="string" ]
>
SQL
</xsql:set-stylesheet-param>

Examples

The following example sets the stylesheet parameter to the value of the parameter named cat:

<xsql:set-stylesheet-param name="current_category" value="{@cat}"/>

This example sets the stylesheet parameter to a value selected from the database:

<xsql:set-stylesheet-param name="security_level">
  SELECT role_name
  FROM user_profile
  WHERE userid = {@userid}
</xsql:set-stylesheet-param>

Description

Sets the value of a top-level XSLT stylesheet parameter.

The value of the stylesheet parameter can be set on the wizard's Value Selector page by either of the following:

• Clicking the String button and specifying the optional value attribute.
• Clicking the SQL button and including a SQL statement as the element content. If the SQL statement is provided, the value of the first column of the first row retrieved is used as the parameter value.

Only the value attribute or the SQL statement can appear in the Set Stylesheet Param tag; they cannot be used together.

Attributes

• name—(Required, String value) Name of the session-level parameter whose value you want to set.
• ignore-empty-value—(Optional, Boolean value) Indicates whether the stylesheet parameter assignment should be ignored if the value to which it is being assigned is an empty string. Valid values are yes and no. Default value is no.
• value—(Optional, string value) Value to assign to the session parameter. Enter this value by clicking the String button in the wizard's Value Selector page and entering a value in the editable field.