thanx it worked
I don't know whether ' works for all the databases or for some we need
double quote.
I think driver must be doing all this conversions, if needed and single
quote must be a convention.
correct me if i am wrong,
----- Original Message -----
From: Tamanna Kher <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 04, 2000 2:24 PM
Subject: Re: why bean can't have a constructor
> the select statement ill b like this
> SELECT *
> FROM emp
> WHERE name like '%a%'
>
> instead of SELECT *
> FROM emp
> WHERE name like " %a%";
>
> Single quotes.
>
>
>
>
> Khem Chand Sachdeva <[EMAIL PROTECTED]> on 07/04/2000 02:35:43
PM
>
> Please respond to A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>
> To: [EMAIL PROTECTED]
> cc: (bcc: Kher Tamanna-SWD-ITIL-UB/Itilmail)
>
> Subject: Re: why bean can't have a constructor
>
>
>
>
> with "%a%" it is not showing any results even if i have the records with
> "a"
> in the column name and it is not accepting it without the double quotes.
> i mean
> SELECT *
> FROM emp
> WHERE name like " %a%";
> is not displaying any results and
> SELECT *
> FROM emp
> WHERE name like %a%
> is giving syntax error while saving.
>
>
> ----- Original Message -----
> From: Gunaseelan Nagarajan <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 04, 2000 1:18 PM
> Subject: Re: why bean can't have a constructor
>
>
> > hi Khem,
> >
> > For ms-access the query should be "%a%"
> >
> > Regards
> > Nagaraj.
> > --- Khem Chand Sachdeva <[EMAIL PROTECTED]>
> > wrote:
> > > Hi All
> > > I tried writing a bean integrated with JSP. IF i
> > > write a no argument
> > > constructor in the bean it(JSP Engine) says that
> > > unable to create an
> > > instance of <Bean Class Name>.
> > > Can't bean have a constructor.
> > > My second doubt is related to using MSAccess with
> > > Jdbc-Odbc Driver.
> > > How do i select some rows based on substrings in the
> > > data like
> > > select * from emp where name like *a*;
> > > this command is not working with the driver provided
> > > for MSAccesss with
> > > JDK.
> > > thanx in advance
> > > bye
> > > khem,
> > >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Kick off your party with Yahoo! Invites.
> > http://invites.yahoo.com/
> >
> >
>
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> > 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".
> 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".
> 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".
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
