Article ID: 190621 - Last Review: October 3, 2001 - Revision: 1.0

FP97: How to Search Using LIKE In SQL Statement For IDC or ASP

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
This article was previously published under Q190621

For a Microsoft FrontPage 2000 and 2002 version of this article, see 205231  (http://support.microsoft.com/kb/205231/EN-US/ ) .
For a Microsoft FrontPage 98 version of this article, see 194677  (http://support.microsoft.com/kb/194677/EN-US/ ) .
Expand all | Collapse all

SUMMARY

This article describes how to search a database using the LIKE parameter in a Structured Query Language (SQL) statement in either the Internet Database Connector (IDC) Wizard or the Database Region Wizard of FrontPage.

This article assumes that you have a basic knowledge of how to query a database using Active Server Pages (ASP), Internet Database Connector (IDC) or Hypertext Markup Language Extension (HTX) technologies in FrontPage.

For additional information about database connectivity with ASP or IDC/HTX, please see the following articles in the Microsoft Knowledge Base:
180405  (http://support.microsoft.com/kb/180405/EN-US/ ) FP98: Sample ASP Wizard Available for Download
175770  (http://support.microsoft.com/kb/175770/EN-US/ ) FP98: How to Post Information to a Database Using ASP
174407  (http://support.microsoft.com/kb/174407/EN-US/ ) FP98: How to Create IDC/HTX Files in FrontPage 98
161155  (http://support.microsoft.com/kb/161155/EN-US/ ) FP97: How to Make a Web Page Display Data from a Database

MORE INFORMATION

When used in a search, the LIKE parameter generates a result set based on a minimum amount of information typed into the form field of a HyperText Markup Language (HTML) form. For example, if you type mic in the form field, the results may include Microsoft, microphone, microwave, and so forth.

To use the LIKE parameter in a SQL statement in FrontPage, start the IDC wizard or the Database Region Wizard, and use the following syntax in the SQL statement 
   SELECT * FROM <Table Name> WHERE <Database Field> LIKE '%%%<HTML
   Field>%%%'
where <Table Name> is the name of a table in the database, <Database Field> is a field in that table, and <HTML Field> is the name of an HTML form field on an HTML document (usually a text box).

The extra percentage signs around the HTML form field name act as wild cards so that the LIKE string can match multiple records. For example, if you entered this SQL code 
   SELECT * FROM Employees WHERE Email Like '%%%Email%%%'
And type volcano in the form field, all records that contain volcano.com in the email field are returned.

NOTE: This example works with the Volcano.mdb file that is included with the ASP Sample Web. For additional information please see the following article in the Microsoft Knowledge Base:
180405  (http://support.microsoft.com/kb/180405/EN-US/ ) FP98: Sample ASP Wizard Available for Download
If you use this query and the form field is blank when you submit the form, all records in the database will be returned. However, you can require that a value be entered before the form is submitted by using form field validation.
APPLIES TO
  • Microsoft FrontPage 97 Standard Edition
Back to the top
Keywords: 
kbinfo KB190621
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations