What do you mean by " i store the id number as an HttpSession object" -- using
session.putValue or using the session id itself.
First, you should have a column( id numbers ) in users table.
second, check the datatype of the column
third, in the WHERE condition, id must either equal to session.getValue or
session.getID(), rather than
the session object itself.
Hope this helps
roopa
Duke Martin wrote:
> Hi,
>
> I have a servlet that communicates with a database. When a user logs in,
> they enter an id number. I store the id number as an HttpSession object.
> The problem I am having is that I want to use the value in the object as
> part of a query statement. For example, SELECT id_numbers FROM users WHERE
> id = HttpSession object.
> The above statement does not work properly. I receive a column not found
> error. Any help appreciated?
>
> Duke
>
> ___________________________________________________________________________
> 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
