Hi
I am trying to get a session variable in a logic sheet AND assign values to variable in esql so if they match I can display extra features
I have a database table with training details in and am displaying all but restricting some of the functions a user can perform according to if the logged on user is the training owner
logic snippet:
<xsl:param name="username"/> this matches session var and I have in sitemap
<xsl:variable name = "loggedonuser" select="$username"/>
<esql:connection>
<esql:pool>xcpt</esql:pool>
<esql:execute-query>
<esql:query>a chunk of sql</esql:query>
<esql:results>
<display>
<esql:row-results>
<xsl:variable name = "userid"><xsl:text>bum</xsl:text><esql:get-string column="courserole.userid" /></xsl:variable>
<tr>
<td width="141" align="center" valign="middle" background=""images/course2.gif"" height="20">
<esql:get-string column="boa.title" />
</td>
<xsl:if test="$userid=$loggedonuser"> I can do the comparison here
show summink here
</xsl:if>
<xsl:if test="not($userid=$loggedonuser)"> I can do the comparison here
show summink else here
</xsl:if>
...
<esql:row-results>
I have seen some articles in the archives but they do not specifically help
I appreciate any help
Cheers
Geoff Parrott
Web Developer
KnowledgePool
42 Bond Street
Brighton BN1 1RD
Tel: 01273 827728
Fax: 01273 321152
Email: [EMAIL PROTECTED]
<http://www.knowledgepool.com/>
This e-mail is intended only for the addressee named above. As this e-mail may contain confidential or privileged information if you are not, or suspect that you are not, the named addressee or the person responsible for delivering the message to the named addressee, please telephone us immediately. Please note that we cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. The views of the author may not necessarily reflect those of the Company.
KnowledgePool Limited, Registered in England no 2478959, Registered Office 26, Finsbury Square, London, EC2A 1SL
Geoff Parrott
Web Developer
KnowledgePool
42 Bond Street
Brighton BN1 1RD
Tel: 01273 827728
Fax: 01273 321152
Email: [EMAIL PROTECTED]
<http://www.knowledgepool.com/>
This e-mail is intended only for the addressee named above. As this e-mail may contain confidential or privileged information if you are not, or suspect that you are not, the named addressee or the person responsible for delivering the message to the named addressee, please telephone us immediately. Please note that we cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. The views of the author may not necessarily reflect those of the Company.
KnowledgePool Limited, Registered in England no 2478959, Registered Office 26, Finsbury Square, London, EC2A 1SL
