I have written a servlet that reads in variables from a database and spits
out a drop down box and a table. I am getting very inconsistent results.
Sometimes it works fine, but most of the time I get a function sequence
error and it garbles the html it is supposed to be writing... any ideas why
this is happening? I am using a jdbc:odbc bridge to connect to MS SQL Server
7.
here is a code snippet...
//put together the HTML form and table from the result set
Form = "<FORM Action='http://127.0.0.1:8000/servlet/Fields'
Method='GET'><Select Name='Table'>\n";
Table = "<TABLE Border='0' width='80%'>\n";
while(rs.next()) {
Option = rs.getString("Name").trim();
Description = rs.getString("Description").trim();
Form = Form + "<Option Value='" + Option + "'>" + Option +
"</OPTION>\n";
Table = Table + "<TR><TD><B>" + Option + "</B></TD><TD>" +
Description + "</TD></TR>\n";
} //end while
Form = Form + "</Select></Form>\n";
Table = Table + "</TABLE>\n";
Thanks,
Jeff Dillon
___________________________________________________________________________
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
