i'm looking for a practical example of using the sql extension with the where clause.  i haven't been able to find an example.


here's my attempt, but it's not working. w/o the where clause, it brings back all rows in the table.  it's a small table, so i could probably run xpath on the results to get the value i want, but it'd be neater to have a where clause.

<xsl:variable name="vTID" select="'T158904'" />

...

<xsl:variable name="user-table">
<sql:query connection="$connection" table="myschema.mytable" column="HANDLER_TID" where="TID='$vTID" row-tag="user" column-tag="col" />
</xsl:variable>