If you are using the JDBC-ODBC bridge with JDBC2.0 you have a problem since
they are not compatible. It's fine if u use JDBC1.0 instead
Cheers,
Pol.
----- Original Message -----
From: Jeff Dillon <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 05, 1999 4:15 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
