All my code is below.
I have a database which will be running queries returning between 50 and 150
records.
I have three simple pages: Search, Result, Invoice.
The invoice is working properly, displaying the records chosen from the
results page.
To the invoice, I have added four pull-down list menus which allow the user
to create a complex sort using four sort parameters (listMenuSort 1,2,3,4 in
order of precedence.
I am getting this error:
500 Internal Server Error
/jserv/Invoice.jsp:Exception thrown on line '30' from page
'C:\\Inetpub\\wwwroot\\Beachwear\\jserv\\Invoice.jsp'
java.sql.SQLException: Column not found: Unknown column 'listMenuSort1' in
'order clause'
--------------------------------------------------------------------------
<%@page language="java" import="java.sql.*"%>
<%@ include file="../Connections/connBeachwear.jsp" %>
<%
String rsBeachwear__varCheckbox = "1";
if (request.getParameter ("valueCheckbox") !=null) {rsBeachwear__varCheckbox
= (String)request.getParameter ("valueCheckbox") ;}
%>
<%
Driver DriverrsBeachwear =
(Driver)Class.forName(MM_connBeachwear_DRIVER).newInstance();
Connection ConnrsBeachwear =
DriverManager.getConnection(MM_connBeachwear_STRING,MM_connBeachwear_USERNAM
E,MM_connBeachwear_PASSWORD);
String chkValues[]=request.getParameterValues("valueCheckbox");
StringBuffer prepStr=new StringBuffer("SELECT ID, Item, Color, Size FROM
Beachwear WHERE ID=");
for(int x=0;x<chkValues.length;++x){
prepStr.append( chkValues[x] );
if((x+1)<chkValues.length){
prepStr.append(" OR ID=");
}//end if
}//end for loop
PreparedStatement
StatementrsBeachwear=ConnrsBeachwear.prepareStatement(prepStr.toString());
ResultSet rsBeachwear = StatementrsBeachwear.executeQuery();
boolean rsBeachwear_isEmpty = !rsBeachwear.next();
boolean rsBeachwear_hasData = !rsBeachwear_isEmpty;
Object rsBeachwear_data;
int rsBeachwear_numRows = 0;
%>
<%
int Repeat1__numRows = -1;
int Repeat1__index = 0;
rsBeachwear_numRows += Repeat1__numRows;
%>
<title>Beachwear Title</title>
<body bgcolor="#FFFFFF">
<p> </p>
<p>
//New code attempting to use pull-down List Menu variables to perform
complex sort:
<form name="form1" method="get" action="Invoice.jsp ORDER BY listMenuSort1
", "listMenuSort2", "listMenuSort3", "listMenuSort4">
<p><br>
INVOICE<br>
<br>
</p>
<% while ((rsBeachwear_hasData)&&(Repeat1__numRows-- != 0)) { %>
<table width="75%" border="1">
<tr>
<td width="13%">ID:</td>
<td width="87%"><%=(((rsBeachwear_data = rsBeachwear.getObject("ID"))==null
|| rsBeachwear.wasNull())?"":rsBeachwear_data)%></td>
</tr>
<tr>
<td width="13%">ITEM:</td>
<td width="87%"><%=(((rsBeachwear_data =
rsBeachwear.getObject("Item"))==null ||
rsBeachwear.wasNull())?"":rsBeachwear_data)%></td>
</tr>
<tr>
<td width="13%">COLOR:</td>
<td width="87%"><%=(((rsBeachwear_data =
rsBeachwear.getObject("Color"))==null ||
rsBeachwear.wasNull())?"":rsBeachwear_data)%></td>
</tr>
<tr>
<td width="13%">SIZE:</td>
<td width="87%"><%=(((rsBeachwear_data =
rsBeachwear.getObject("Size"))==null ||
rsBeachwear.wasNull())?"":rsBeachwear_data)%></td>
</tr>
</table>
<%
Repeat1__index++;
rsBeachwear_hasData = rsBeachwear.next();
}
%>
<p> </p>
<br>
<table width="37%" border="1">
<tr>
<td width="16%">Parameter</td>
<td width="11%">
<div align="center">1</div>
</td>
<td width="20%">
<div align="center">2</div>
</td>
<td width="20%">
<div align="center">3</div>
</td>
<td width="33%">
<div align="center">4</div>
</td>
</tr>
//New pull-down list Menus:
<tr>
<td width="16%">
<input type="submit" name="Submit" value="Sort">
</td>
<td width="11%">
<select name="listMenuSort1" size="1">
<option value="ID" selected>ID</option>
<option value="Item">ITEM</option>
<option value="Color">COLOR</option>
<option value="Size">SIZE</option>
</select>
</td>
<td width="20%">
<select name="select" size="1">
<option value="ID">ID</option>
<option value="Item" selected>ITEM</option>
<option value="Color">COLOR</option>
<option value="Size">SIZE</option>
</select>
</td>
<td width="20%">
<select name="select2" size="1">
<option value="ID">ID</option>
<option value="Item">ITEM</option>
<option value="Color" selected>COLOR</option>
<option value="Size">SIZE</option>
</select>
</td>
<td width="33%">
<select name="select3" size="1">
<option value="ID">ID</option>
<option value="Item">ITEM</option>
<option value="Color">COLOR</option>
<option value="Size" selected>SIZE</option>
</select>
</td>
</tr>
</table>
</form>
<%
rsBeachwear.close();
ConnrsBeachwear.close();
%>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
