how from an Access Currency field I populate a hidden field

**lse123** · 12-30-2009, 09:01 PM

Java Code:

//out.println("<input type=\"hidden\" name=\"price" + plantNo + "\" value=\"" + rs.getString(5) + "\">");

The above found to give errors... how from Access Currency field like price=
rs.getString(5)
I populate a hidden field ? How do it in MySQL ?

Servlets upon compilation(or update) needed server restart to rerun (updated) ?

**lse123** · 12-31-2009, 12:17 PM

if I insert
rs.getString(5) // field5 = currency field MS-Access DB
it doesn't work, but if insert
"8.9"
work in value of hidden field , where error ?
out.println("<input type=\"hidden\" name=\"price" + plantNo + "\" value=\"" + rs.getString(5) + "\">"); // "8.9"

**r035198x** · 12-31-2009, 12:27 PM

Don't try to output HMTL from servlets like that.
Use a JSP for the presentation. After collecting the results from a helper class whose methods are called from the servlet, set the results as request attributes in the servlets and let the servlet route to a JSP. You would then retrieve these attributes in the JSP and present the values.

**lse123** · 12-31-2009, 04:59 PM

may problem above be in the DATA, I have:
total+=Double.parseDouble(request.getParameter("pr ice"+i))*Integer.parseInt(request.getParameter("pl antQuantity"+i));
somewhere in the doPost executed after submit form with hidden:
out.println("<input type=\"hidden\" name=\"price" + plantNo + "\" value=\"" + rs.getString(5) + "\">"); // "8.9"

As you say SOLUTION: how transfer from servlet to JSP request attributes/data ? Also how in servlet forward or transfer control to JSP...?

**lse123** · 01-17-2010, 11:13 PM

Please answer asap.... this is textbook problem (self solve not instructed)...

I include[attach] whole servlet, get data from:

<body>
<form action="/Webdbt/flowerpower" method="get">
<p>
<h3>Choose your favorite color and click Submit Answer!!</h3>
<select name="choiceColor">
<option value="Peach">Peach</option>
<option value="Pink">Pink</option>
...............................................

MS-ACCESS DATABASE and field:5, is of currency type. UNDER TOMCAT.