To work around this problem, create a search option for the Database Editor page. To do this, follow these steps:
- Open the Web site in FrontPage 2003.
- After you create the database interface pages, double-click the database1_Interface folder under Folder List, double-click the Results folder, double-click the editor folder, and then double-click the List.asp file.
Note "database1" is the name of the Web site database. - Click File, and then click Save As.
- Type a file name to back up the List.asp file in a location of your choice.
- Open the List.asp file again.
- Select the <table> and </table> tags that display the results. Then, drag the table outside the <form> and </form> tags.
- Double-click the database results region, and then click Next four times.
- If Split records into groups is selected, click Display all records together instead, and then click Finish.
- Double-click the database results region again.
- In the Database Results Wizard window, click the appropriate language option (ASP or ASP.NET) and the appropriate database connection.
- Click Next, click Custom query, and then click Edit.
- In the SQL Statement box, type the following string:
SELECT * FROM TableName WHERE ColumnName LIKE
Note In this string, replace TableName with the actual name of the table. Then, replace ColumnName with the actual name of the column on which you want to filter. - Click Insert Parameter, type the parameter name that you must pass to the query, and then click OK two times. For example, type sName, and then click OK two times.
Note The SQL statement should then look similar to the following:SELECT * FROM TableName WHERE ColumnName LIKE ::sName::
- Add "%" before and after the "::sName::" parameter in the Custom Query dialog box. The result should then look similar to the following:
%::sName::%
- Click OK, click Next, click More Options, and then click Defaults.
- Click the parameter name, click Edit, and then type a default value in the Value box. Then, click OK two times.
- Click to clear the Limit number of returned records to check box, and then click OK.
- Click Next two times, and then click Display all records together.
- Click to select the Add search form check box, and then click Finish.
- Double-click the key that must be hyperlinked from the database results region. You must create a hyperlink for this key to send information to the details page.
- Click to select the Display as hyperlink check box, and then click Hyperlink Parameters.
- In the Path box, type the details page name.
Note By default, the details page name is Detail.asp. - Click Add, and then click Key in the Name list. Then, click OK three times.
- Drag the <table> and </table> tags that display the results to between the <form> and </form> tags.
Note The <table> and </table> tags are created for the search option. - Right-click the hyperlink that you created, and then click Hyperlink Properties.
- In the Edit Hyperlink dialog box, click Target Frame.
- In the Target Frame dialog box, type detail in the Target setting box. Then, click OK two times.
- Insert a column to the left of the hyperlink that you created. Then, click Insert, click Form, and then click Checkbox.
- Double-click the check box. Then, in the Name box, type the following string:
%=FP_FieldURL(fp_rs,Key)%
Note In this string, replace Key with the table field name that must be passed to the details page. - Click OK.
Notes- You can test whether this search option works by using the backup page that you created in step 3.
- The format of the Database Results Wizard changes when you change options for the database results region.