Will somebody tell me How Will I unsubscribe?
I have done it twice..please remove me..
It is pain to delte 100 odd mail daily.
CHEERS
Jeet
On Tue, 23 Feb 1999 07:30:45 Vyas Vemu wrote:
>There is syntax error in your code. You forgot the single quotes around
>the data field info1. Wrap it this way: The semi colon is really not
>necessary for odbc connection.
>
>ResultSet rs ............... WHERE ename= ' " + info1 + " ' ");
>
>
>Vyas
>
>mahesh wrote:
>
>> HiI am getting runtime error while executing an sql query using
>> variable name with WHERE clause. But if i am using some value instead
>> of var name it is working and fetching data from database.here is the
>> code.ResultSet rs = stmt.executeQuery ("SELECT * FROM sample1 WHERE
>> ename = 'mahesh' ");this is working butResultSet rs =
>> stmt.executeQuery ("SELECT * FROM sample1 WHERE ename = "+ info1
>> +";");it is giving java131 runtime error. where info1 =
>> request.getParameter("acct"); acct is the name of the text
>> field. please point out the fault in it...thanks in
>> advanceregardsMahesh
>
>
Get your FREE Email at http://mailcity.lycos.com
Get your PERSONALIZED START PAGE at http://personal.lycos.com
___________________________________________________________________________
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
