Ok, this may be a rather long winded question for a short answer but I
do not know of any other way of asking it. So here we go....
I have a parent node of sorts called report-name. This is used to group
the different reports that I have. Under the report name I have
parameters. In parameters node I have nodes for each type of parameter
that is needed for the given report. The problem I am having is in my
xsl stylesheet I am unable to see the report-name parameter at a certain
level of the parameters node. I have attached the code to help display
what I am referring to. In the BeginEndDate template I am unable to see
the report-name attribute. Is there a way that I would be able to view
this? I have Michael Kay's xslt book but cannot find anything to
reference.
Xslt:
<xsl:template match="parameters">
<div id="panel_sw{normalize-space(report-name)}" class="dlgPanel"
>
<div class="panelName"><xsl:value-of
select="normalize-space(report-name)"/></div>
<table cellspacing="4" width="100%">
<xsl:apply-templates/>
<tr align="center">
<td colspan="4">
<div class="titleSmall"
nowrap="nowrap">Select output type:</div>
</td>
</tr>
<tr align="center">
<td align="right" colspan="2">
<div class="titleSmall"
nowrap="nowrap"><input type="radio"
name="RadioGroup{normalize-space(report-name)}"
value="excel"/>Excel</div>
</td>
<td align="left" colspan="2">
<div class="titleSmall"
nowrap="nowrap"><input type="radio"
name="RadioGroup{normalize-space(report-name)}" value="pdf"
checked="checked"/>PDF</div>
</td>
</tr>
</table>
</div>
</xsl:template>
<xsl:template match="report-name">
</xsl:template>
<xsl:template match="BeginEndDate">
<tr>
<td width="50%" nowrap="nowrap">
<div class="titleSmall" nowrap="nowrap">Start
date:</div>
<input class="inputLine date" title="Enter task
start date in form MM-DD-YYYY"
id="startDate{normalize-space(report-name)}" size="20"
value="06-01-2003" name="startDate{normalize-space(report-name)}"/>
</td>
<td valign="bottom">
<br/>
<span class="butBlue" id="taskStartDate"
returnId="startDate{normalize-space(report-name)}"
onclick="tdDateCalendar()">
<span class="butSmallMiddle Center">Show<br
/>Calendar</span>
</span>
</td>
<td width="50%" nowrap="nowrap">
<div class="titleSmall" nowrap="nowrap">Finish
date:</div>
<input class="inputLine date" title="Enter task
finish date in form MM-DD-YYYY"
id="endDate{normalize-space(report-name)}" size="20" value="06-01-2003"
name="endDate{normalize-space(report-name)}"/>
</td>
<td valign="bottom">
<br/>
<span class="butBlue" id="taskFinishDate"
returnId="endDate{normalize-space(report-name)}"
onclick="tdDateCalendar()">
<span class="butSmallMiddle Center">Show<br
/>Calendar</span>
</span>
</td>
</tr>
</xsl:template>
XSL:
<?xml version="1.0" encoding="UTF-8"?>
<xsp:page language="java" xmlns:xsp="http://apache.org/xsp";
xmlns:xsp-request="http://apache.org/xsp/request/2.0";
xmlns:esql="http://apache.org/cocoon/SQL/v2";
xmlns:xsp-session="http://apache.org/xsp/session/2.0";
create-session="true">
<page>
<xsp:logic>
String msg = "";
String user = <xsp-request:get-parameter
name="user"/>;
String password =<xsp-request:get-parameter
name="pass"/>;
String role = "";
int login = 999;
</xsp:logic>
<esql:connection>
<esql:pool>vyzo</esql:pool>
<esql:execute-query>
<!-- Call sproc; sproc has one output param
(return code) -->
<esql:call>
{<esql:parameter direction="out"
type="Int"/> = call getLoginResult(<esql:parameter type="String"
direction="in">
<xsp:expr>user</xsp:expr>
</esql:parameter>,<esql:parameter
type="String" direction="in">
<xsp:expr>password</xsp:expr>
</esql:parameter>)}
</esql:call>
<!-- retrieve return code from output
parameter -->
<esql:call-results>
<return>
<xsp:logic>
login = <esql:get-int
column="1" from-call="yes"/>;
if(login == -1)
{
role = "Invalid
Login, Please try again.";
}
if(login == 0)
{
role = "User
Reports";
}
if(login == 1)
{
role = "Manager
Reports";
}
</xsp:logic>
</return>
</esql:call-results>
</esql:execute-query>
<title-page>
<xsp:expr>role</xsp:expr>
</title-page>
<esql:execute-query>
<esql:query>
execute getReportsByRole
<xsp:expr>login</xsp:expr>
</esql:query>
<esql:results>
<reports>
<esql:row-results>
<report>
<report-name>
<esql:get-string column="Name"/>
</report-name>
</report>
<parameters>
<report-name>
<esql:get-string column="Name"/>
</report-name>
<esql:execute-query>
<esql:query>execute getAttributesForReport <esql:get-int column="1"/>
</esql:query>
<esql:results>
<esql:row-results>
<parameter>
<xsp:element>
<xsp:param name="name">
<esql:get-string column="3"/>
</xsp:param>
</xsp:element>
</parameter>
</esql:row-results>
</esql:results>
</esql:execute-query>
</parameters>
</esql:row-results>
</reports>
</esql:results>
</esql:execute-query>
</esql:connection>
</page>
</xsp:page>
Thank you for your help.
Tim Bachta
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
