are u using SQL Server 7.0 ?
-----Original Message-----
From: Jeff Dillon <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, October 05, 1999 5:27 PM
Subject: Function sequence error
>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...
>
> file://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";
>
> } file://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
___________________________________________________________________________
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
