into the text field is passed along with the URL in the address bar. Figure 27.3. Enter a value in the search text box and click Search. The value is passed along with the URL in the address bar. [View full size image]   Figure 27.3 shows the value being searched on displayed in the address bar as a parameter appended to the URL string. As you can see, the page isn't returning a result just yet. Let's do that next. Creating the Dorknozzle Search Results Page Now that the search page has been created, you'll want some way of collecting the value of the user's input and processing the result of the search. The search results page is where all the work is done. The search results page must contain the following components for the search to be processed correctly: The recordset or DataSet that represents the table being searched. The proper variables/parameters to capture the user's input from the search page. Dynamic text to display the result of the search to the user. Remember that a recordset/DataSet is always used to capture the results of the table information. To create a new recordset or DataSet for the search results page, follow these steps: 1. Create a new page by selecting File, New. Select the Templates tab, choose the Dorknozzle template titled "template," and click Create. 2. Immediately save the page as search_results.asp, search_results.aspx, search_results.cfm, or search_results.php, depending on the server model you're using. 3. Select the recordset (or DataSet if you're working in ASP.NET) option from the Bindings panel's Add (+) menu. The Recordset/DataSet dialog box appears. 4. Click the Advanced button. Name the recordset/DataSet rsSearch (or dsSearch if you're working in ASP.NET). 5. Select the connDorknozzle option from the Connection menu. 6. You can either manually construct your SQL query by typing the code directly into the SQL text box or you can select the appropriate fields from the Database Items selection box. For now, simply add the following code to the SQL text box:   SELECT * FROM EmployeeStore WHERE ItemName = 'Dorknozzle Shirt'   Notice that the value we're appending to the WHERE clause of the SQL statement is the text Dorknozzle Shirt. The completely formatted Recordset/DataSet dialog resembles Figure 27.4. Figure 27.4. Create the hardcoded query to extract a single record from the database. [View full size image] 7. Click the Test button. The results, as shown in Figure 27.5, show the data for the Dorknozzle Shirt. Figure 27.5. The result for the Dorknozzle Shirt is shown in the Test SQL Statement window. [View full size image] Although the query seems to work perfectly, it's still not dynamic to the user. As things stand now, the Dorknozzle Shirt value always appears as the searched item. The next section introduces you to working with variables (also known as parameters if you're working in ASP.NET or ColdFusion). Variables/parameters