Adding Database Functionality - New Perspectives on Adobe Dreamweaver CS5, Comprehensive - page 568

your name, and then click the Submit button. The coaching.php page with the topic
entries appears in the browser. ( Hint : If you are sharing a database with classmates,
you might see additional entries in the database.)
19. Submit the fi nished fi les to your instructor.
If you are using Access and ASP on a Windows server, complete the following steps:
1. Open the S uccess With Tess site you modifi ed in Tutorial 8.
2. In the Files panel, duplicate the coaching.html page, rename the copied page as
topics.asp , and then open the topics.asp page in Design view.
3. Change the heading text to Topic Input , replace the word “Coaching” in the page
title with Topic Input , and then delete the content in the page.
4. Insert a form in the page, enter topicform as the form name, and then, in the form,
insert a table with 2 rows, 2 columns, 90 percent table width, 0 border thickness,
3 cell padding, 0 cell spacing, and no header cells.
5. Type input coaching topic in the upper-left cell, and then align the text to the Right
and Top.
6. Insert a Spry Validation Textarea widget in the upper-right cell, close the Input Tag
Accessibility Attributes dialog box, enter topicvalidate as the Spry Textarea name,
and then make sure the fi eld is set as Required. Click the scroll bar twice to select
the text area, enter topic as the fi eld name, set the character width to 80, and then
set the number of lines to 10.
7. Add a Submit button in the lower-right cell, and then save the page. Click the OK
button in the Copy Dependent Files dialog box to add the SpryAssets folder and fi les
to the site.
8. Connect to an existing database or upload the database to your remote server using
an FTP program and the tess_db.mdb fi le located in the Tutorial.09\Case3 folder
included with your Data Files. ( Hint : Obtain the information you need from your
instructor or technical support person.)
9. In the Server Behaviors panel, select ASP VBScript as the document type in Step 2.
10. Set up the testing server in Step 3, check the Testing check box for the Tess Web
Server in the Servers tab, edit the server profi le and enter the Web URL for your
remote site in the URL box, if necessary.
11. In the Server Behaviors panel, add the Recordset behavior, click the Simple but-
ton in the Recordset dialog box if necessary, name the recordset tess_record , click
the Defi ne button, click the New button, click Custom Connection String, type
tess_connect as the connection name, type Provider=Microsoft.Jet.OLEDB.4.0;
Data Source= followed by the exact fi le path to your database and ” (closing quota-
tion mark) as the connection string, click the Using Driver on Testing Server option
button, click the Test button, click the OK button to confi rm the connection was
made successfully, click the OK button, click the Done button, click tess_connect
in the Connection list, click topic in the Table list, click the Selected option button,
click topic_text in the Columns list, and then click the OK button. The Recordset
behavior is added to the page and appears in the Server Behaviors panel. ( Hint :
If you do not know the exact path to your database, ask your instructor or tech-
nical support person. If the test is unsuccessful, double-check the connection
string and fi le path for your database or use an outside FTP program to upload the
_mmServerScripts folder to the root folder on your remote server and your testing
server if you're using a separate testing server.)
12. In the Server Behaviors panel, add the Insert Record behavior, click tess_connect in
the Connection list, click topic in the Insert into table list, type coaching.asp in the
After inserting, go to box, click topicform in the Get values from list, if necessary,
click topic in the Form elements list, then select topic_text in the Column list and
Text in the Submit as list and then click the OK button. The Insert Record behavior is
added to the page and appears in the Server Behaviors panel.