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

form. The new vote tally appears below the form in the page. ( Hint : If you are shar-
ing a database with classmates, you might see additional entries in the database.)
16. 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 Cowboy Charlie site you modifi ed in Tutorial 8, and then open the
index.html page in Design view.
2. After the existing content in the content div, insert a form into the page, enter
voteform as the form name, and then, in the form, insert a table with 3 rows, 1 col-
umn, 40 percent table width, 0 border thickness, 2 cell padding, 2 cell spacing, and
no header cells.
3. In the top row, type Select your favorite painting , and then align the text to the Left
and Top.
4. Add a radio group in the second row, name the radio group vote , replace “Radio”
with The Bucker in the fi rst row of both the Label and Value columns, replace
“Radio” with Grubpile in the second row of both the Label and Value columns, click
the Plus (+) button to add a new row, replace “Radio” with A Quiet Day in Utica in
the third row of both the Label and the Value columns, and then click the OK button.
5. Add a Submit button in the third row of the table, typing Submit as the button name
and the value if necessary, and then save the page.
6. Connect to an existing database or upload the database to your remote server using
an FTP program and the cowboy_db.mdb fi le located in the Tutorial.09\Case2 folder
included with your Data Files. ( Hint : Obtain the information you need from your
instructor or technical support person.)
7. In the Server Behaviors panel, click the document type link in Step 2, click ASP
VBScript in the list, click the OK button, update the links in the fi les, click the OK
button to confi rm that the index.asp page could not be updated, save the index.asp
page, update the link for the hotspot that covers the banner at the top of the page to
the index.asp page, and then save the page again.
8. Click the testing server link in Step 3, in the Servers tab, check the Testing check box
for the Cowboy Charlie web server, edit the server profi le and check to insure that
the fi le path information from the Web URL prefi x box is the URL for your posted
site, and then click the Save button twice. Click OK to recreate the cache.
9. In the Server Behaviors panel, add the Recordset behavior, name the record-
set charlie_record , click the Defi ne button, click the New button, click
Custom Connection String, type charlie_connect as the connection name, type
Provider=Microsoft.Jet.OLEDB.4.0; Data Source= and the exact fi le path to your
database in the Connection String box, click the Using Driver on Testing Server
option button if necessary, click the Test button, click the OK button to close the
dialog box stating that the connection was made successfully, click the OK button
to close the Custom Connection String dialog box, click the Done button, click the
Simple button, if necessary, click charlie_connect in the Connection list, click vote
in the Table list, click the Test button, and then click the OK button. ( Hint : If you do
not know the exact path to your database, ask your instructor or technical 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.)
10. Click the Advanced button, delete all the text in the SQL box, type the following
code exactly as it appears, click the Test button, click the OK button, and then click
the OK button to enter a query that will enable the vote tally to be displayed in a
dynamic table.
SELECT vote AS Painting, count(vote) AS Votes
FROM vote