error in jsp: select1 cannot be resovled
[nobr]Please check the repost
Trying to resolve the error which is select1 cannot be resolved on every line where select1 has been used.
As far as i know, the syntax is correct but it is not able to create select1 id and not able to execute the select query
Brijesh Shah
<%@ page language="java" info="AMSX Submit Audit Page" %>
<HTML>
<HEAD><TITLE>AMSX</TITLE></HEAD>
<BODY BGCOLOR="#FDF5E6">
<H1>Asset Management System (AMSX) </H1>
<x:driverManagerSpec id="conn1" driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://10.187.33.159:49408/AMSX"
userid='<%= request.getParameter("userid") %>'
password='<%= request.getParameter("password") %>' />
<x:select id="select1" scope="session" connectionSpec="conn1">
<%-- Set the parameter using the input value from the HTML page --%>
<x:sql>
SELECT ap_WorkforceID, ap_FullName, ap_PersonOUC FROM t_amsx_people WHERE ap_WorkforceID ='802018661'
</x:sql>
<%-- x:parameter parmName="DEPT" type="SMALLINT"
value='<%= request.getParameter("deptnumber") %>' / --%>
</x:select>
<form method="POST" action="ChangeByRow.jsp">
<h3>Employee Number <%= request.getParameter("EIN") %></h3>
<h3>Row <%=select1.getRow() %> of <%=select1.getRowCount() %> </h3>
<%if (select1.first()){ %>
<table border="1"><tbody>
<tr>
<td>Employee Number:</td>
<td><INPUT size="40" type="text" name="ap_WorkforceID"
value='<x:getColumn name="select1" colName="ap_WorkforceID" />'>
</td>
</tr>
<tr>
<td>Employee Name:</td>
<td><INPUT size="40" type="text" name="ap_FullName"
value='<x:getColumn name="select1" colName="ap_FullName" />'>
</td>
</tr>
<tr>
<td>Employee OUC:</td>
<td><INPUT size="40" type="text" name="ap_PersonOUC"
value='<x:getColumn name="select1" colName="ap_PersonOUC" />'>
</td>
</tr>
</tbody></table>
<br>
<INPUT type="submit" name="previous" value="Previous row">
<INPUT type="submit" name="next" value="Next row">
<INPUT type="submit" name="update" value="Update row">
<INPUT type="submit" name="delete" value="Delete row">
<INPUT type="submit" name="insert" value="Insert another row">
<%} %>
</form>
</BODY>
</HTML>
Message was edited by:
BrijeshShah[/nobr]
