[SOLVED] Getting the value inside a SQL Query into a String.

[mainy]

Hi,

Fairly simple question I guess to you guys. I have a SQL database and I want to take the value of something inside this database and place it into a string. I know the path to information inside the SQL database, I just have no idea how to get that record stored inside a string.

I have tried:
variable.getString(SQL Location);
variable.getQuery(SQL Location);
String variable = "SQL Location"; (this obviously doesnt work).
+ several other I've forgotten.

I have looked inside the JSP API and online but can't really find the solution.

thank you in advance

[mtyoung]

have you specify jdbc driver in your code?
have you create a connection?
have you use preparedStatement/Statement, executeQuery
and get the resultSet?

[mainy]

Ok,

have you specify jdbc driver in your code?
have you create a connection?
have you use preparedStatement/Statement, executeQuery
and get the resultSet?

My jdbc driver is located inside my web.xml document on the server. The connection works fine as I am able to display on the webpage tables of information from the server.

What I am trying to do is this (only part of my code):

<sql:query var="sqlPass" sql="SQL LOCATION" /> (Sql Location contains a real sql query.)

<%
    String password = request.getParameter("passWord");
    if (password.equals(sqlPass)) {
%>
++ More code

Basically, I am trying to compare a password inputted from the user with a password inside the sql database, if they are the same, do something.

[mainy]

Hey,

Just to let you know that I've sorted out the problem. I tried something else and got it working. :rolleyes:

Thanks anyway.