Re: Unable to compile class for JSP
Saturday, June 29, 2002 08:57 AM
1. Shouldn't there be a "WHERE" in the SQL statement to test whether "user" and "pass" are correct?
2. As I read the SQL query, you have asked for a list of ALL user names and passwords. That could make for one hell of a big record set.
3. "user" and "pass" appear to be java variables being used OUTSIDE java blocks. Could that be a problem?
4. For my logins, I throw an exception using "IF rs.next()" ..."else".
Hope this is of some use. Let me know if I'm totally off track.