IFA

1. Browse to www.sawmac.com/dw8/.

2. Go to tutorial page and download chapters 20-24:Dynamic Dreamweaver Tutorials

3. Unzip the file and move the nationalEx_root folder to c:\inetpub\wwwroot

Creating Site

1. Choose Site->New Site

2. Use Basic Tab

3. Type Exasperator Store in the first box and http://www.nationalExasperator.com

4. Click Next

5. Select server technology and ASP VBScript

6. Select Edit and test locally

7. Click the folder and select the nationalEx_root that you had copied to wwwroot earlier

8. Type the URL and Test

9. Click Next

10. Click No and Next followed by Done


Creating Dynamic Page at site (results.asp)

1. Open databases panel by choosing window->databases

2. Click the + sign at top right panel, choose connection string

3. In the connection Name box, type connNationalEx.

4. In the connection String box, type Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\nationalEx.mdb

5. Make sure Using driver on this machine is selected and Test

Creating Recordsets with Search function (results.asp)

1. In Name field, type rsProducts

2. Connection select the connection made earlier on

3. Choose Products table

4. Select Product Name, description and price

5. Select Filter -> prodPrice

6. Choose <>select Form Variable and key in prodPrice

8. Sort by Price


9. Create table and repeat region and drag the appropriate records to the appropriate columns

Creating a search page (search.asp)
1. Create a form
2. In the form include a menu and submit button
3. Action property of form to set as Post and point to results.asp created earlier on.
4. Name the menu as prodPrice and make sure values are keyed in. e.g below

5. Test the search page