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
