How to use DHTML to add wildcard characters to a database query in FrontPage 2003 (825519)

MORE INFORMATION

Step 1 - Prepare to Use the ASP Features in FrontPage

Step 2 - Create a Database Results Page

1. In FrontPage 2003, open a Web site on a Web server that supports Microsoft Active Server Pages (ASP).
2. On the Standard toolbar, click the New Page button.
3. Create a Database Results Region.
   
   To do this, point to Database on the Insert menu, and then click Results.
4. Click Use a sample database connection (Northwind), and then click Next.
5. For record source, click the Products table, and then click Next.
6. Click More Options.
7. Click Criteria.
8. Click Add.
9. In the Add Criteria dialog box, set the following options:
   • Set the field name to ProductName.
   • Set the comparison to Like.
   • Use the default, ProductName, for the value.
   • Click to select the Use this search form field check box if you have to.
10. Click OK to close the Add Criteria dialog box.
11. Click OK to close the Criteria dialog box.
12. Click OK to close the More Options dialog box.
13. Click Next.
14. Click Next.
15. Click Finish.
16. Save the page to your Web and name it ProductName.asp.

Step 3 - Add DHTML to the Page

1. Switch to HTML view.
2. Add the following DHTML code before the closing

   </head>

   tag:

   		<script language="javascript">
   		function FixMe(tmpForm,tmpField)
   		{
   		  var strTemp = tmpField.value.toString();
   		  if (strTemp.substring(0,1) != '%')
   		    strTemp = '%' + strTemp;
   		  if (strTemp.substring(strTemp.length-1,strTemp.length) != '%')
   		    strTemp = strTemp + '%';
   		  tmpField.value = strTemp;
   		  tmpForm.submit();
   		}
   		</script>

3. Locate and delete the following code:

   <form BOTID="0" METHOD="POST" ACTION="productname.asp">

   and replace it with this code:

   <form BOTID="0" METHOD="POST" ACTION="productname.asp" onSubmit="FixMe(this,this.ProductName)">

4. Switch back to normal view.
5. Save the page to your Web.

Step 4 - Test the Page

1. On the Standard toolbar, click the Preview in Browser button.
   
   No form fields should appear on the page.
2. Do not type any text.
   
   Click Submit. The search form field should contain a single percent sign (%) and all the records are returned.
3. Clear the input field on the search form, type Bob's, and then click Submit.
   
   %Bob's% appears in the input field and all the fields that contain that text string are displayed.