When I click the link "Modify", allthe fields in update2.jsp show null,
please what's wrong whith my files ? Thanks
pager-jdbc.jsp :
.....
<td><a href='update2.jsp?ipaddress = <sql:getColumn position="1"/> &
user = <sql:getColumn position="2"/> &
newname = <sql:getColumn position="3"/> &
domain = <sql:getColumn position="4"/> &
jacknumber = <sql:getColumn position="5"/> &
os = <sql:getColumn position="6"/> &
pc = <sql:getColumn position="7"/> &
processor = <sql:getColumn position="8"/> &
memory = <sql:getColumn position="9"/>
'>Modify</a></td>
..........
update2.jsp :
<%@ taglib uri="http://jakarta.apache.org/taglibs/jdbc"; prefix="sql" %>
<% String update = request.getParameter("update"); %>
<% System.out.println("update = " + update );%>
<% if ( update!=null)
{
%>
<sql:connection id="conn1">
<sql:url>jdbc:mysql://mil2wwds10:3306/test</sql:url>
<sql:driver>org.gjt.mm.mysql.Driver</sql:driver>
</sql:connection>
<sql:statement id="stmt1" conn="conn1">
<sql:query>
update pcinfo SET IP_Address ='<%=request.getParameter("ipaddress")%>',
User = '<%=request.getParameter("user")%>',
New_Name = '<%=request.getParameter("newname")%>',Domain =
'<%=request.getParameter("domain")%>', Jack_number =
'<%=request.getParameter("jack")%>',
OS ='<%=request.getParameter("os")%>', PC =
'<%=request.getParameter("pc")%>', Processor =
'<%=request.getParameter("processor")%>', Memory =
'<%=request.getParameter("memory")%>'
where New_Name = '<%=request.getParameter("newname")%>'
</sql:query>
<sql:execute/>
</sql:statement>
<sql:closeConnection conn="conn1"/>
<% response.sendRedirect("wasDeleted.jsp"); %>
<%
} %>
<html>
<head>
<title>Untitled</title>
</head>
<body>
<form method="POST" action="update2.jsp">
<table border="0" cellpadding="4" width="90%">
<tr>
<td valign="top" bgcolor="#AFD0D1"><font size="3" face="arial,helvetica"><b>
Update this entry</b></font></td>
</tr>
<tr>
<td valign="top" bgcolor="#FFCC66"><font size="2"
face="Verdana"><b></b></font></td>
</tr>
<tr>
<td valign="top" bgcolor="#CCCCCC">
<font size="2" face="arial,helvetica">
<input type="hidden" name="update" value="yes">
<input type="text" size="45" name="ipaddress"
value="<%=request.getParameter("ipaddress")%>">IP Address<br>
<input type="text" size="45" name="user"
value="<%=request.getParameter("user")%>"> User<br>
<input type="text" size="45" name="newname"
value="<%=request.getParameter("newname")%>"> New Name<br>
<input type="text" size="45" name="domain"
value="<%=request.getParameter("domain")%>"> Domain<br>
<input type="text" size="45" name="jack"
value="<%=request.getParameter("jack")%>"> Jack#<br>
<SELECT NAME="os" value="<%=request.getParameter("os")%>">
<OPTION VALUE=" "> Select OS </OPTION>
<OPTION VALUE="Win2k">Win2k</OPTION>
<OPTION VALUE="Win98">Win98</OPTION>
<OPTION VALUE="Win95">Win95</OPTION>
<OPTION VALUE="NT4">NT4</OPTION>
<OPTION VALUE="LINUX">LINUX</OPTION>
</SELECT> OS<br>
<input type="text" size="45" name="pc"
value="<%=request.getParameter("pc")%>"> PC<br>
<input type="text" size="45" name="processor"
value="<%=request.getParameter("processor")%>"> Processor<br>
<input type="text" size="45" name="memory"
value="<%=request.getParameter("memory")%>"> Memory
</font>
</td>
</tr>
<tr>
<td valign="top" bgcolor="#FFCC66"><font size="2"
face="Verdana"><b></b></font></td>
</tr>
<tr><td>
<p align="center"><input type="submit" name="Submit" value="Insert New
Entry">
<input type="reset" name="Reset" value="Start Over"></p>
<p align="center"><font size="1" face="Verdana"><b>Please press the Submit
button ONCE.</b></font></p>
</td>
</tr>
</table>
</form>
</body>
</html>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
