Ultradev JSP tutorial

tomjo11 · May 24, 2001

Hi I have a problem. Can somebody help me. I have done the jsp tutorial in Ultradev 4 and cannot diplay the detail page. I get an error saying no data found. Everything else works besides that.

Microbe · May 24, 2001

Show us the code.

Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au

bironman · Jun 20, 2001

What page r u testing? the listings? Are u genrating asp, jsp o cf?

Guest_imported · Jul 11, 2001

I'm having this problem too. Has anyone successfully done a troubleshoot on it for you?

Microbe · Jul 11, 2001

I say again...show us the code...I have no problem with getting this working.

Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au

Guest_imported · Jul 12, 2001

Ok, I'll attempt to paste below. thanks.

<%@page language="java" import="java.sql.*"%>
<%@ include file="Connections/connCompassTravel.jsp" %>
<%
Driver DriverDetails = (Driver)Class.forName(MM_connCompassTravel_DRIVER).newInstance();
Connection ConnDetails = DriverManager.getConnection(MM_connCompassTravel_STRING,MM_connCompassTravel_USERNAME,MM_connCompassTravel_PASSWORD);
PreparedStatement StatementDetails = ConnDetails.prepareStatement("SELECT * FROM EMPLOYEES&quot

;
ResultSet Details = StatementDetails.executeQuery();
boolean Details_isEmpty = !Details.next();
boolean Details_hasData = !Details_isEmpty;
Object Details_data;
int Details_numRows = 0;
%>
<%
// *** Recordset Stats, Move To Record, and Go To Record: declare stats variables

int Details_first = 1;
int Details_last = 1;
int Details_total = -1;

if (Details_isEmpty) {
Details_total = Details_first = Details_last = 0;
}

//set the number of rows displayed on this page
if (Details_numRows == 0) {
Details_numRows = 1;
}
%>
<% String MM_paramName = ""; %>
<%
// *** Move To Record and Go To Record: declare variables

ResultSet MM_rs = Details;
int MM_rsCount = Details_total;
int MM_size = Details_numRows;
String MM_uniqueCol = "EMPLOYEEID";
MM_paramName = "id";
int MM_offset = 0;
boolean MM_atTotal = false;
boolean MM_paramIsDefined = (MM_paramName.length() != 0 && request.getParameter(MM_paramName) != null);
%>
<%
// *** Move To Specific Record: handle detail parameter

if (MM_paramIsDefined && MM_rsCount != 0) {

// get the value of the parameter
String param = request.getParameter(MM_paramName);

// find the record with the unique column value equal to the parameter value
String colVal;
while (Details_hasData) {
colVal = ((MM_rs.getObject(MM_uniqueCol)!=null)?MM_rs.getObject(MM_uniqueCol).toString():"&quot

;
if (colVal.equals(param)) break;
Details_hasData = MM_rs.next();
MM_offset++;
}

// if not found, set the number of records and reset the cursor
if (!Details_hasData) {
if (MM_rsCount < 0) MM_rsCount = MM_offset;
if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount;
MM_offset = 0;

// reset the cursor to the beginning
Details.close();
Details = StatementDetails.executeQuery();
Details_hasData = Details.next();
MM_rs = Details;
}
}
%>
<%
// *** Move To Record: if we dont know the record count, check the display range

if (MM_rsCount == -1) {

// walk to the end of the display range for this page
int i;
for (i=MM_offset; Details_hasData && (MM_size < 0 || i < MM_offset + MM_size); i++) {
Details_hasData = MM_rs.next();
}

// if we walked off the end of the recordset, set MM_rsCount and MM_size
if (!Details_hasData) {
MM_rsCount = i;
if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount;
}

// if we walked off the end, set the offset based on page size
if (!Details_hasData && !MM_paramIsDefined) {
if (MM_offset > MM_rsCount - MM_size || MM_offset == -1) { //check if past end or last
if (MM_rsCount % MM_size != 0) //last page has less records than MM_size
MM_offset = MM_rsCount - MM_rsCount % MM_size;
else
MM_offset = MM_rsCount - MM_size;
}
}

// reset the cursor to the beginning
Details.close();
Details = StatementDetails.executeQuery();
Details_hasData = Details.next();
MM_rs = Details;

// move the cursor to the selected record
for (i=0; Details_hasData && i < MM_offset; i++) {
Details_hasData = MM_rs.next();
}
}
%>
<%
// *** Move To Record: update recordset stats

// set the first and last displayed record
Details_first = MM_offset + 1;
Details_last = MM_offset + MM_size;
if (MM_rsCount != -1) {
Details_first = Math.min(Details_first, MM_rsCount);
Details_last = Math.min(Details_last, MM_rsCount);
}

// set the boolean used by hide region to check if we are on the last record
MM_atTotal = (MM_rsCount != -1 && MM_offset + MM_size >= MM_rsCount);
%>
<html>
<head>
<title>Details about the employee</title>
<link rel="stylesheet" href="master.css">
</head>
<body bgcolor="#FFFFFF" topmargin=0 leftmargin=0 marginwidth=0 marginheight=0 background="images/bkg_detail.gif" onLoad="">
<FORM>
<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD VALIGN=TOP ALIGN=LEFT>
<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD VALIGN=TOP ALIGN=LEFT><IMG SRC="images/spacer_clear.gif" WIDTH=481 HEIGHT=55></TD>
<TD VALIGN=TOP ALIGN=LEFT><img src="images/mast_topimage.jpg" width="279" height="55"></TD>
</TR>
</TABLE>
</TD>
</TR>
<TR>
<TD VALIGN=TOP ALIGN=LEFT><IMG SRC="images/spacer_clear.gif" WIDTH=10 HEIGHT=20></TD>
</TR>
<TR>
<TD VALIGN=TOP ALIGN=LEFT>
<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD VALIGN=TOP ALIGN=LEFT><IMG SRC="images/spacer_clear.gif" WIDTH=278 HEIGHT=60><BR>
<img src="images/detail_title.gif" width="221" height="18"></TD>
<TD VALIGN=TOP ALIGN=LEFT><img src="images/mast_topimages.jpg" width="461" height="49"><BR>
<img src="images/mast_discovering.gif" width="284" height="22"></TD>
</TR>
</TABLE>
</TD>
</TR>
<TR>
<TD VALIGN=TOP ALIGN=LEFT><IMG SRC="images/spacer_clear.gif" WIDTH=80 HEIGHT=20></TD>
</TR>
<TR>
<TD VALIGN=TOP ALIGN=LEFT>
<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD VALIGN=TOP ALIGN=LEFT><IMG SRC="images/spacer_clear.gif" WIDTH=95 HEIGHT=353></TD>
<TD VALIGN=TOP ALIGN=LEFT>
<table border=0 cellpadding=0 cellspacing=0 width=455>
<tr>
<td valign=TOP align=LEFT colspan=3 BGCOLOR="#993300"><img src="images/spacer_brown.gif" width=455 height=1></td>
</tr>
<tr>
<td valign=TOP align=LEFT width=1 bgcolor="#993300"><img src="images/spacer_brown.gif" width=1 height=23></td>
<td valign=MIDDLE align=RIGHT width=453 bgcolor="#006699" class="username"><IMG SRC="images/spacer_clear.gif" WIDTH=446 HEIGHT=2><BR>
<%=(((Details_data = Details.getObject("LASTNAME&quot