jan frank

Hi again,

I have this piece of login code for a webpage that words like a charm IF there's only one username in the database table that the website is connected to.

If there are 3 usernames in the database table AND the username & password of the website is incorrect, then the error message is replicated THREE times!!

"Login Failed.Please try Again Login Failed.Please try Again Login Failed.Please try Again."

If there are 4 usernames in the database table and the username and password on trying to log in from the website is incorrect, then the error message is replicated FOUR times...and so on.

Any ideas?

<% String user=request.getParameter("t1"); String pass=request.getParameter("t2"); Connection c; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); c = DriverManager.getConnection("jdbc :-o dbc:RADIO","",""); Statement st=c.createStatement(); ResultSet rs=st.executeQuery("select username,password from tblAdmin"); while(rs.next()) { String username=rs.getString(1); String password=rs.getString(2); if(user.equals(username) && pass.equals(password)) { %> <jsp:forward page="adminactions.jsp" /> <%} else out.println("Login Failed.Please try Again"); %> <% } }catch(Exception e1) {} %>

I spent some time at it and I DID get it in the format I wanted. Yeaaaah!

oops! the resultset should have been rs1 not rs.
I resolved the problem

Hi,

Any suggestions & solutions about this elusive error message? [Microsoft][ODBC Driver Manager] Invalid cursor state.
This is the bit of code that gives that error:

<table border ="3" width = "50%"> <tr> <td width = "20%"> <img src="images/multipic.jpg" width="227" height="170"></td> <td width = "80%"> <% String sql1 = "SELECT tblHomePage.welcome_note FROM tblHomePage"; Connection con1 = null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con1 = DriverManager.getConnection("jdbc :-o dbc:IVES","",""); Statement stmt1 = con1.createStatement(); ResultSet rs1 = stmt1.executeQuery(sql1); %> <% while (rs.next()) { System.out.println(rs1.getString("welcome_note")); } %> <% rs1.close(); //close the resultset }//end of try catch(SQLException e) { out.println(e.getMessage()); } %> </td> </tr> </table>

Thanks

Hi,

I'm building a page using jsp that pulls data from a database. The page should look a bit like this :

Name:ABC
Date: 12/12/2004
Description rogramming is fun!
Cost:$100.00


Name:XYZ
Date:1/8/2005
Description:Fruits are yummy!
Cost:$30.05

Name: QRS
Date:8/8/2005
Description:A great tv show!
Cost:$50.90

etc...etc...

Basically, the sql query loops through the db and displays the results like that with the same sub headings. I don't want to do it where the sub headings go horizontally across the page (won't have the same visual effect).

I was thinking part of the code may have something like this:
<table border="1"> <tr> <th><font color="#0000A0">Name</font></th> </tr> <tr> <th><font color="#0000A0">Date</font></th> </tr> ... ... ... while (rs.next()) { <tr> <td><%=rs.getString("name")%> </td> <td><%=rs.getString("date")%> </td> ... ...

I'd like to keep things simple as can be. Beans and servlets confuse me.

Any suggestions please?