Microsoft KB Archive/907235

= When you use FrontPage 2003, the Database Editor page displays all the database results after you perform a Web search, and it is difficult to quickly find the record that you want =

Article ID: 907235

Article Last Modified on 11/29/2005

-

APPLIES TO


 * Microsoft Office FrontPage 2003

-





SYMPTOMS
When you use Microsoft Office FrontPage 2003, the Database Editor page displays all the database results after you perform a Web search. Therefore, it is difficult to quickly find the record that you want and to select the record for modification or deletion.



CAUSE
This problem occurs because the Database Interface Wizard does not include the search function.



WORKAROUND
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 &quot;database1&quot; 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  tags that display the results. Then, drag the table outside the and tags.</li> Double-click the database results region, and then click Next four times.</li> If Split records into groups is selected, click Display all records together instead, and then click Finish.</li> Double-click the database results region again.</li> In the Database Results Wizard window, click the appropriate language option (ASP or ASP.NET) and the appropriate database connection.</li> Click Next, click Custom query, and then click Edit.</li> In the SQL Statement box, type the following string:

SELECT * FROM  WHERE   LIKE

Note In this string, replace  with the actual name of the table. Then, replace  with the actual name of the column on which you want to filter.</li> 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  WHERE   LIKE ::sName::

</li> Add &quot;%&quot; before and after the &quot;::sName::&quot; parameter in the Custom Query dialog box. The result should then look similar to the following:

%::sName::%

</li> Click OK, click Next, click More Options, and then click Defaults.</li> Click the parameter name, click Edit, and then type a default value in the Value box. Then, click OK two times.</li> Click to clear the Limit number of returned records to check box, and then click OK.</li> Click Next two times, and then click Display all records together.</li> Click to select the Add search form check box, and then click Finish.</li> 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.</li> Click to select the Display as hyperlink check box, and then click Hyperlink Parameters.</li> In the Path box, type the details page name.

Note By default, the details page name is Detail.asp.</li> <li>Click Add, and then click Key in the Name list. Then, click OK three times.</li> <li>Drag the  tags that display the results to between the and tags.

Note The  tags are created for the search option.</li> <li>Right-click the hyperlink that you created, and then click Hyperlink Properties.</li> <li>In the Edit Hyperlink dialog box, click Target Frame.</li> <li>In the Target Frame dialog box, type detail in the Target setting box. Then, click OK two times.</li> <li>Insert a column to the left of the hyperlink that you created. Then, click Insert, click Form, and then click Checkbox.</li> <li>Double-click the check box. Then, in the Name box, type the following string:

%=FP_FieldURL(fp_rs, )%

Note In this string, replace  with the table field name that must be passed to the details page.</li> <li>Click OK.</li></ol>

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.

Additional query words: FPSE FrontPage 2003 Database Editor page search option

Keywords: kbtshoot kbprb KB907235

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.