Thanks for the prompt reply, here is the JSP that I am having problems
with,
as I say it is not returning any more than a certain amount of the page, if
I decrease the amount of data per line the output becomes more but still
hits the limit, I have a screen shot if it will make it clearer,
<%@ page import="java.sql.*" %>
<%! protected String driver="sun.jdbc.odbc.JdbcOdbcDriver";
protected String url="jdbc:odbc:ian";
protected String userid="system";
protected String password="manager"; %>
<%! public static String FIRST_QUERY =
"SELECT row_id, " +
"timesheet, " +
"emp_no, " +
"expense_date, " +
"customer_no, " +
"rechargeable, " +
"receipt_no, " +
"expense_type, " +
"expense_amount, " +
"foreign_exchange_rate_type, " +
"foreign_exchange_rate, " +
"actual_amount, " +
"vat, " +
"vat_rate_type, " +
"vat_rate, " +
"amount_vatable, " +
"amount_of_vat, " +
"oracle_work, " +
"mileage_from, " +
"mileage_to, " +
"mileage_rate_ee, " +
"mileage_rate_er, " +
"description " +
"FROM expenses " +
"WHERE emp_no=? and timesheet=? " +
"ORDER BY expense_date, customer_no, to_number(receipt_no)";
%>
<%! public static String SECOND_QUERY =
"SELECT customer_no, customer_description " +
"FROM customer_no " +
"ORDER BY customer_no";
%>
<%! public static String THIRD_QUERY =
"SELECT expense_type " +
"FROM expense_type " +
"ORDER BY expense_type";
%>
<%! public static String FORTH_QUERY =
"SELECT rate_type, rate_value " +
"FROM foreign_exchange_rate " +
"ORDER BY rate_type";
%>
<%! public static String FIFTH_QUERY =
"SELECT vat_type, vat_rate_value " +
"FROM vat_rate " +
"ORDER BY vat_type";
%>
<%
String empNo = (String) session.getAttribute("empNo");
String Timesheet = request.getParameter("Timesheet");
String _template = (String) session.getAttribute("_template");
String customerNo = "";
String customerDesc = "";
String expenseType = "";
String foreignExchangeRateType = "";
String foreignExchangeRateValue = "";
String vatType = "";
String vatRateValue = "";
String comment = "";
String mileageFrom = "";
String mileageTo = "";
%>
<%
PreparedStatement stmt;
ResultSet rs;
PreparedStatement stmt1;
ResultSet rs1;
PreparedStatement stmt2;
ResultSet rs2;
PreparedStatement stmt3;
ResultSet rs3;
PreparedStatement stmt4;
ResultSet rs4;
%>
<html>
<head>
<title>Symatrix Ltd.</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1\">
<script language="JavaScript">
</script>
</head>
<FORM name="ConfirmDeleteForm" method="POST"
action="/symatrix/update_row_ex.jsp" target="mainFrame">
<%
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, userid, password);
stmt = conn.prepareStatement(FIRST_QUERY);
stmt.setString(1, empNo);
stmt.setString(2, Timesheet);
rs = stmt.executeQuery();
%>
<table width="%" border="0"
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt">
<tr bgcolor="#99CCCC">
<td align="center" nowrap>Update</td>
<td align="center" nowrap>Date</td>
<td align="center" nowrap>Customer</td>
<td align="center" nowrap>Rechargeable</td>
<td align="center" nowrap>Receipt No</td>
<td align="center" nowrap>Type</td>
<td align="center" nowrap>Net Amount</td>
<td align="center" nowrap>Exchange Rate</td>
<td align="center" nowrap>VAT</td>
<td align="center" nowrap>VAT Rate Type</td>
<td align="center" nowrap>VATable Amount</td>
<td align="center" nowrap>Oracle Work</td>
<td align="center" nowrap>Mileage From</td>
<td align="center" nowrap>Mileage To</td>
<td align="center" nowrap>Mileage Rate EE</td>
<td align="center" nowrap>Mileage Rate ER</td>
<td align="center" nowrap>Comment</td>
</tr>
<% String currentCustomerNo = "";
String currentExpenseType = "";
String currentForeignExchangeRateType = "";
String currentVatType = "";
String daydate = "";
int day = 0;
int month = 0;
int year = 0;
String rowColour = "#99CCCC";
int checkBoxCount = 1;
while (rs.next()) {
if (rowColour.equalsIgnoreCase("#99CCCC"))
{
rowColour = "#FFFFCC";
%>
<tr bgcolor="#FFFFCC">
<% }
else
{
rowColour = "#99CCCC";
%>
<tr bgcolor="#99CCCC">
<% }
%>
<td align="center" nowrap><INPUT
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt" SIZE="1"
TYPE="checkbox" name="SelectRow<%=checkBoxCount%>"
value="<%=rs.getString(1)%>"></td>
<% daydate = rs.getString(4);
currentCustomerNo = rs.getString(5);
day = Integer.parseInt(daydate.substring(8,10));
month = Integer.parseInt(daydate.substring(6,7));
year = Integer.parseInt(daydate.substring(0,4));
%>
<td align="center" nowrap><select
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt"
name="dayDateDay<%=checkBoxCount%>">
<OPTION <% if (day == 1){%>SELECTED <%}%> VALUE="01">01
<OPTION <% if (day == 2){%>SELECTED <%}%> VALUE="02">02
<OPTION <% if (day == 3){%>SELECTED <%}%> VALUE="03">03
<OPTION <% if (day == 4){%>SELECTED <%}%> VALUE="04">04
<OPTION <% if (day == 5){%>SELECTED <%}%> VALUE="05">05
<OPTION <% if (day == 6){%>SELECTED <%}%> VALUE="06">06
<OPTION <% if (day == 7){%>SELECTED <%}%> VALUE="07">07
<OPTION <% if (day == 8){%>SELECTED <%}%> VALUE="08">08
<OPTION <% if (day == 9){%>SELECTED <%}%> VALUE="09">09
<OPTION <% if (day == 10){%>SELECTED <%}%>
VALUE="10">10
<OPTION <% if (day == 11){%>SELECTED <%}%>
VALUE="11">11
<OPTION <% if (day == 12){%>SELECTED <%}%>
VALUE="12">12
<OPTION <% if (day == 13){%>SELECTED <%}%>
VALUE="13">13
<OPTION <% if (day == 14){%>SELECTED <%}%>
VALUE="14">14
<OPTION <% if (day == 15){%>SELECTED <%}%>
VALUE="15">15
<OPTION <% if (day == 16){%>SELECTED <%}%>
VALUE="16">16
<OPTION <% if (day == 17){%>SELECTED <%}%>
VALUE="17">17
<OPTION <% if (day == 18){%>SELECTED <%}%>
VALUE="18">18
<OPTION <% if (day == 19){%>SELECTED <%}%>
VALUE="19">19
<OPTION <% if (day == 20){%>SELECTED <%}%>
VALUE="20">20
<OPTION <% if (day == 21){%>SELECTED <%}%>
VALUE="21">21
<OPTION <% if (day == 22){%>SELECTED <%}%>
VALUE="22">22
<OPTION <% if (day == 23){%>SELECTED <%}%>
VALUE="23">23
<OPTION <% if (day == 24){%>SELECTED <%}%>
VALUE="24">24
<OPTION <% if (day == 25){%>SELECTED <%}%>
VALUE="25">25
<OPTION <% if (day == 26){%>SELECTED <%}%>
VALUE="26">26
<OPTION <% if (day == 27){%>SELECTED <%}%>
VALUE="27">27
<OPTION <% if (day == 28){%>SELECTED <%}%>
VALUE="28">28
<OPTION <% if (day == 29){%>SELECTED <%}%>
VALUE="29">29
<OPTION <% if (day == 30){%>SELECTED <%}%>
VALUE="30">30
<OPTION <% if (day == 31){%>SELECTED <%}%>
VALUE="31">31
</select>
<select STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt"
name="dayDateMonth<%=checkBoxCount%>">
<OPTION <% if (month == 1){%>SELECTED <%}%>
VALUE="JAN">January
<OPTION <% if (month == 2){%>SELECTED <%}%>
VALUE="FEB">February
<OPTION <% if (month == 3){%>SELECTED <%}%>
VALUE="MAR">March
<OPTION <% if (month == 4){%>SELECTED <%}%>
VALUE="APR">April
<OPTION <% if (month == 5){%>SELECTED <%}%>
VALUE="MAY">May
<OPTION <% if (month == 6){%>SELECTED <%}%>
VALUE="JUN">June
<OPTION <% if (month == 7){%>SELECTED <%}%>
VALUE="JUL">July
<OPTION <% if (month == 8){%>SELECTED <%}%>
VALUE="AUG">August
<OPTION <% if (month == 9){%>SELECTED <%}%>
VALUE="SEP">September
<OPTION <% if (month == 10){%>SELECTED <%}%>
VALUE="OCT">October
<OPTION <% if (month == 11){%>SELECTED <%}%>
VALUE="NOV">November
<OPTION <% if (month == 12){%>SELECTED <%}%>
VALUE="DEC">December
</select>
<select STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt"
name="dayDateYear<%=checkBoxCount%>">
<OPTION <%=year-1%> VALUE="<%=year-1%>"><%=year-1%>
<OPTION <%=year%> SELECTED VALUE="<%=year%>"><%=year%>
<OPTION <%=year+1%> VALUE="<%=year+1%>"><%=year+1%>
</select></td>
<td align="center" nowrap><select
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt"
name="customerNumber<%=checkBoxCount%>">
<%
stmt1 = conn.prepareStatement(SECOND_QUERY);
rs1 = stmt1.executeQuery();
while (rs1.next())
customerNo = rs1.getString(1);
customerDesc = rs1.getString(2);
%>
<OPTION <% if (customerNo.equalsIgnoreCase(currentCustomerNo))
{%>SELECTED <%}%>VALUE="<%=customerNo%>"><%=customerNo%>-<%=customerDesc%>
<% }%>
</td>
<td align="center" nowrap><INPUT
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt" SIZE="1"
TYPE="checkbox" NAME="rechargeable<%=checkBoxCount%>" VALUE="Y" <%if
(rs.getString(6).equalsIgnoreCase("Y")) {%>CHECKED<%}%>></td>
<td align="center" nowrap><INPUT
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt" TYPE="text"
NAME="receiptNo<%=checkBoxCount%>" value="<%=rs.getString(7)%>"></td>
<td align="center" nowrap><select
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt"
name="expenseType<%=checkBoxCount%>">
<% currentExpenseType = rs.getString(8);
%>
<%
stmt2 = conn.prepareStatement(THIRD_QUERY);
rs2 = stmt2.executeQuery();
%>
<% while (rs2.next())
expenseType = rs2.getString(1);
%>
<OPTION <% if
(expenseType.equalsIgnoreCase(currentExpenseType)) {%>SELECTED
<%}%>VALUE="<%=expenseType%>"><%=expenseType%>
<% }
%>
</select></td>
<td align="center" nowrap><INPUT
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt" TYPE="text"
NAME="expenseAmount<%=checkBoxCount%>" value="<%=rs.getString(9)%>"></td>
<td align="center" nowrap><select
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt"
name="foreignExchangeRateType<%=checkBoxCount%>">
<% currentForeignExchangeRateType = rs.getString(10);
%>
<%
stmt3 = conn.prepareStatement(FORTH_QUERY);
rs3 = stmt3.executeQuery();
%>
<% while (rs3.next())
foreignExchangeRateType = rs3.getString(1);
foreignExchangeRateValue = rs3.getString(2);
%>
<OPTION <% if
(foreignExchangeRateType.equalsIgnoreCase(currentForeignExchangeRateType))
{%>SELECTED
<%}%>VALUE="<%=foreignExchangeRateType%>"><%=foreignExchangeRateType%> -
<%=foreignExchangeRateValue%>
<% }
%>
</select></td>
<td align="center" nowrap><INPUT
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt" SIZE="1"
TYPE="checkbox" NAME="vat<%=checkBoxCount%>" VALUE="Y" <%if
(rs.getString(13).equalsIgnoreCase("Y")) {%>CHECKED<%}%>></td>
<td align="center" nowrap><select
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt"
name="vatType<%=checkBoxCount%>">
<% currentVatType = rs.getString(14);
%>
<%
stmt4 = conn.prepareStatement(FIFTH_QUERY);
rs4 = stmt4.executeQuery();
%>
<% while (rs4.next())
vatType = rs4.getString(1);
vatRateValue = rs4.getString(2);
%>
<OPTION <% if (vatType.equalsIgnoreCase(currentVatType))
{%>SELECTED <%}%>VALUE="<%=vatType%>"><%=vatType%> - <%=vatRateValue%>
<% }
%>
</select></td>
<td align="center" nowrap><INPUT
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt" TYPE="text"
NAME="vatableAmount<%=checkBoxCount%>" value="<%=rs.getString(16)%>"></td>
<td align="center" nowrap><INPUT
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt" SIZE="1"
TYPE="checkbox" NAME="oracleWork<%=checkBoxCount%>" VALUE="Y" <%if
(rs.getString(18).equalsIgnoreCase("Y")) {%>CHECKED<%}%>></td>
<% mileageFrom = rs.getString(19);
mileageTo = rs.getString(20);
if (mileageFrom == null)
{
mileageFrom = " ";
}
if (mileageTo == null)
{
mileageTo = " ";
}
%>
<td align="center" nowrap><INPUT
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt" TYPE="text"
NAME="mileageFrom<%=checkBoxCount%>" value="<%=mileageFrom%>"></td>
<td align="center" nowrap><INPUT
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt" TYPE="text"
NAME="mileageTo<%=checkBoxCount%>" value="<%=mileageTo%>"></td>
<td align="center" nowrap><INPUT
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt" TYPE="text"
NAME="mileageRateEE<%=checkBoxCount%>" value="<%=rs.getString(21)%>"></td>
<td align="center" nowrap><INPUT
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt" TYPE="text"
NAME="mileageRateER<%=checkBoxCount%>" value="<%=rs.getString(22)%>"></td>
<% comment = rs.getString(23);
if (comment == null)
{
comment = " ";
}
%>
<td align="center" nowrap><INPUT
STYLE="font-family:Verdana,Helvetica,Arial;font-size:7pt" TYPE="text"
NAME="comment<%=checkBoxCount%>" value="<%=comment%>"></td>
</tr>
<%
checkBoxCount = checkBoxCount + 1;
}
%>
</table>
<INPUT VALUE="Confirm Update" STYLE="color:#ffffff;
font-family:Verdana,Helvetica,Arial;font-size:7pt; font-weight:normal;
background:#3E92B7;cursor:hand" TYPE="submit"></td>
<INPUT NAME="checkBoxTotal" TYPE="hidden" VALUE="<%=checkBoxCount-1%>">
</html>
Ian Hilliard
[EMAIL PROTECTED]
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
