Now I try to add a selection option to select sorting sequence of retrieved records. Some
JSP statements are shown :
:
<table border="0">
<tr>
<td bgcolor="#D5D5D5">Sorted by :
<select name="opt_sort" >
<option value="Asc ">Ascending</option>
<option value="Desc">Descending</option>
</select>
String sort_by = opt_sort.value;
</td>
</tr>
</table>
<table border="1">
<tr>
<td><b>Mark:</b></td>
<td><b>Name:</b></td>
<td><b>Description:</b></td>
</tr>
<% bb.connect();
if (sort_by.equals("Asc")) {
String qry_smt = "SELECT * FROM Bookmarks";}
else {
String qry_smt = "SELECT * FROM Bookmarks ORDER BY 1 DESC";}
ResultSet rs = bb.viewBookmarks(qry_smt);
while (rs.next()) {
String url = rs.getString("URL");
%>
:
:
It didn't work and Error page prompt out. as follows :
C:\Tomcat 4.1\work\Standalone\localhost\jspad\my_bookmarks_jsp.java:115: cannot resolve symbol
symbol : variable sort_by
location: class org.apache.jsp.my_bookmarks_jsp
if (sort_by.equals("Asc")) {
^
HELP ! THANKS !