What's the query you're trying to run -- please print it our from your java
app and pass that exactly. Your code below doesn't include any ' marks to
delimit the search and is different to code samples further down. It's
almost certain you're trying to execute a query like
select * from table where name=big
when it should be
select * from table where name='big'
Clayton
-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of sufi malak
Sent: 18 April 2001 17:46
To: [EMAIL PROTECTED]
Subject: Re: Unknown column ??
The same query from the command line is working fine.
>From: Nishit Trivedi <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Unknown column ??
>Date: Wed, 18 Apr 2001 12:36:01 -0400
>
>error is EXACTLY as stated...
>"Unknown column 'Big' in where clause..
>
>Please try to print query before executing it...
>or try to execute same query through command line..
>
>Nishit
>
>-----Original Message-----
>From: sufi malak [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, April 18, 2001 12:15 PM
>To: [EMAIL PROTECTED]
>Subject: Unknown column ??
>
>
>I am still struggling with the same problem, could you please tell me why
>is
>this error :
>javax.servlet.ServletException: java.sql.SQLException: Column not found:
>Unknown column 'Big' in 'where clause'
>
>The code is like this :
><sql:query>
> select * from description where name = <%=
>request.getParameter("name")
>%>
> </sql:query>
>
>Thanks
>
>
> >From: sufi malak <[EMAIL PROTECTED]>
> >Reply-To: A mailing list about Java Server Pages specification and
> > reference <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: jdbc taglib question ?? No rows selected
> >Date: Wed, 18 Apr 2001 14:52:58 -0000
> >
> >Hi, I just read the documentation again, from apache site :
> >http://jakarta.apache.org/taglibs/doc/jdbc-doc/index.html#escapeSql
> >And I changed the sql quer to :
> >
> ><sql:query>
> > select * from description where name =
> >'<sql:escapeSql><%=request.getParameter("name")%></sql:escapeSql>'
> > </sql:query>
> >BUT STILL DOES NOT WORK, ALWAYS I get no rows selected.
> >
> >
> >
> >
> >>From: sufi malak <[EMAIL PROTECTED]>
> >>Reply-To: A mailing list about Java Server Pages specification and
> >> reference <[EMAIL PROTECTED]>
> >>To: [EMAIL PROTECTED]
> >>Subject: Re: jdbc taglib question ???
> >>Date: Wed, 18 Apr 2001 12:59:47 -0000
> >>
> >>Hi,
> >>1)
> >><sql:query>
> >> select * from description where name like <%= "'" +
> >>request.getParameter("name") + "'"%>
> >> </sql:query>
> >>2)
> >><sql:query>
> >> select * from description where name like '<%=
> >>request.getParameter("name") %>'
> >> </sql:query>
> >>
> >>Both (1) and (2) don't work.
> >>
> >>
> >>>From: Richard Yee <[EMAIL PROTECTED]>
> >>>Reply-To: A mailing list about Java Server Pages specification and
> >>> reference <[EMAIL PROTECTED]>
> >>>To: [EMAIL PROTECTED]
> >>>Subject: Re: jdbc taglib question ?????
> >>>Date: Tue, 17 Apr 2001 13:26:57 -0700
> >>>
> >>>Sufi,
> >>>You need single quotes around the string in your like clause.
> >>>select * from description where name like '<%=
> >>>request.getParameter("name")
> >>>%>'
> >>>
> >>>If that doesn't work you might have to do
> >>>select * from description where name like <%= "'" +
> >>>request.getParameter("name") + "'" %>
> >>>
> >>>
> >>>-Richard
> >>>
> >>>-----Original Message-----
> >>>From: sufi malak [mailto:[EMAIL PROTECTED]]
> >>>Sent: Tuesday, April 17, 2001 1:16 PM
> >>>To: [EMAIL PROTECTED]
> >>>Subject: jdbc taglib question ?????
> >>>
> >>>
> >>>could you please tell me what's wrong in this line:
> >>>select * from description where name like <%=
> >>>request.getParameter("name")
> >>>%>
> >>>
> >>>
> >>>the file is like this :
> >>>..........
> >>><%@ taglib uri="http://jakarta.apache.org/taglibs/jdbc" prefix="sql" %>
> >>>
> >>><% String name = request.getParameter("name"); %>
> >>><% out.println(" The name is >>>>>:" + name); %>
> >>>
> >>><sql:connection id="conn1">
> >>> <sql:url>jdbc:mysql://localhost/test</sql:url>
> >>> <sql:driver>org.gjt.mm.mysql.Driver</sql:driver>
> >>></sql:connection>
> >>>
> >>><sql:preparedStatement id="stmt2" conn="conn1">
> >>> <sql:query>
> >>> select * from description where name like <%=
> >>>request.getParameter("name") %>
> >>> </sql:query>
> >>> <sql:resultSet id="rset1">
> >>> <pg:item>
> >>> <sql:getColumn position="1"/><br>
> >>> <sql:getColumn position="2"/><br>
> >>>..............
> >>>_________________________________________________________________
> >>>Get your FREE download of MSN Explorer at http://explorer.msn.com
> >>>
>
>>>=========================================================================
>==
> >>>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> >>>JSP-INTEREST".
> >>>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> >>>DIGEST".
> >>>Some relevant FAQs on JSP/Servlets can be found at:
> >>>
> >>> http://java.sun.com/products/jsp/faq.html
> >>> http://www.esperanto.org.nz/jsp/jspfaq.html
> >>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >>>
>
>>>=========================================================================
>==
> >>>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> >>>JSP-INTEREST".
> >>>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> >>>DIGEST".
> >>>Some relevant FAQs on JSP/Servlets can be found at:
> >>>
> >>> http://java.sun.com/products/jsp/faq.html
> >>> http://www.esperanto.org.nz/jsp/jspfaq.html
> >>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >>
> >>_________________________________________________________________
> >>Get your FREE download of MSN Explorer at http://explorer.msn.com
> >>
>
>>==========================================================================
>=
> >>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> >>JSP-INTEREST".
> >>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> >>DIGEST".
> >>Some relevant FAQs on JSP/Servlets can be found at:
> >>
> >>http://java.sun.com/products/jsp/faq.html
> >>http://www.esperanto.org.nz/jsp/jspfaq.html
> >>http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >>http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
> >_________________________________________________________________
> >Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
>
>===========================================================================
> >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> >JSP-INTEREST".
> >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> >DIGEST".
> >Some relevant FAQs on JSP/Servlets can be found at:
> >
> >http://java.sun.com/products/jsp/faq.html
> >http://www.esperanto.org.nz/jsp/jspfaq.html
> >http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
>DIGEST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
>DIGEST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
