Yes, it works. Thanks so much!
Barb J.
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Jason
Kilgrow
Sent: Thursday, May 31, 2001 2:03 PM
To: [EMAIL PROTECTED]
Subject: Re: Jsp help with database call
How about this:
<%
String queryStr = "SELECT authorid,firstname,lastname FROM author WHERE
authorid LIKE " + authoridnum;
%>
If your authoridnum = 5, you end up with the string:
SELECT authorid,firstname,lastname FROM author WHERE authorid LIKE 5
See if that works.
--- Barbara Johnson <[EMAIL PROTECTED]> wrote:
> Hello to the JSP gurus out there.
>
>
> I am having trouble with making a query to a database with a JSP variable.
>
> I know the variable is ok because I can print it out but I can't seem to
get
> the select statement
> to accept the variable. I am trying to call a particular author's record
and
> if I type in the number in the
> select statement the statement works i.e.. WHERE authorid = 2 but when I
> put the variable in there is always
> an error. I have tried to use "" and '' . What else could I try. I am
> grateful for any help on this.
>
> <%
> String queryStr = "SELECT authorid,firstname,lastname FROM author WHERE
> authorid LIKE authoridnum ";
> %>
> Barb Johnson
> Instructional Programmer
>
>
___________________________________________________________________________
> 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
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.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
___________________________________________________________________________
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
