Search results for query: *

Hi Libaax, port# is not nescessary since I use the default. First I declared result just once, but then I got the error that it was not found. I'll try your advice. Thnx, Menno.

Thanks for your responses vbkris and libaax, the line: String Countresultaat = resultaat.getString(&quot;count(messageNr)&quot;); is not a problem, it delivers the data from the MySQL-database fine, I can use it in the same page perfectly. The declaration of <%! String resultaat; %> works...

Basically I use this: { Class.forName(&quot;com.mysql.jdbc.Driver&quot;); Connection myConn=DriverManager.getConnection(&quot;jdbc:mysql://localhost/test?user=root&password=root&quot;); Statement stmt = myConn.createStatement(); String query = &quot;SELECT count(messageNr) FROM...

Hi, COUNT FROM messages (or COUNT messageNr FROM messages) won't work since I use MySQL. (I tried it anyway). When I use the following code in another file it works fine: { Class.forName(&quot;com.mysql.jdbc.Driver&quot;); Connection...

Thanks for replying so fast, AR1982! That was a silly typo :) Still, when i change CountResultaat to something else (like 'a') it still gives me the same error. It looks like the variable just doesn't come out of the ResultSet. I still get the error (only then with 'a' instead of...

Hi, I have a question regarding Resultsets in JSP. I have a HTML form that gives 2 variables from textfields to another JSP page, which adds it to the database using the given variables in a query. Now i want the form to also include the messagenumber (this number is the primary key of the table...