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'" />
<sql:query connection="$connection" table="myschema.mytable" column="HANDLER_TID" where="TID='$vTID" row-tag="user" column-tag="col" />