While one could debate the merits of having Internet-deployed web
applications
accessing a backend database, this doesn't answer the original poster's
question.
He asked how to do partial string matching using SQL. I would direct
Jeetandra
to the SQL 'LIKE' operator:
select ... from ... where name LIKE '%AB%";
Stan Bailes
Quadcap Software
Pradeep Shekade writes:
> It is but obvious that an SQL query will get executed every time a key is
pressed. The logic
> needs to be built around this. On a desktop this feature will be very
attractive. But on the
> net you will start having serious performance issues.
>
> Regards,
>
> Pradeep Shekade
>
> Jeetandra Mahtani wrote:
>
> > Hello,
> > I have a table in a db that stores the names of several companies. Now
on a form, a user
> > can enter the name of the company partially or completely, and the
results should display
> > accordingly. For example, I have two records "abc co" and "ab co". If a
user enters only
> > "ab", both the records should be retrieved, but if "abc" or "abc co" is
entered, then only
> > the first record is retrieved. Any idea on how to implement this query ?
The company names
> > are stored in a field of 100 character length.
> > Thanks,
> > JM
___________________________________________________________________________
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
