Chapter Three Quiz - Page 14

1. What is the difference between the Dim oRS and Set oRS commands?

2. What punctuation (combination of parenthesis, quotes, commas, periods, etc.) is used with the server's CreateObject method?

3. What is the syntax to write on the page the data of the field named "SSN" from the record set oRS6?

4. What is the syntax to use if you have a section of HTML text and want to put into the middle of it the field named "SSN" from the record set oRS6?

5. I've opened a recordset using the simple method but want to print it out in reverse order. But when I use oRS.MovePrevious it fails. Why?

6. Name three steps that should be performed prior to using ASP- ADO.

7. In the connection parameter, how do you separate the DSN, the userID and the password?

8. Write the syntax to stuff the variable named sSSN with the data in the field named "SSN" from the recordset oRS6.

9. What HTML text will prevent table cells from "collapsing" when NULL data is encountered?

10. If you do not have a lot of experience with HTML tables, try writing the tags and text to produce the following table. This does not require ASP-ADO, it is for practice with HTML table tags

11. Again, if you do not have a lot of experience with HTML tables, try writing the tags and text to produce the following table.

Exercises - Page 13
Beginning ASP Databases
Chapter Three Quiz Answers - Page 15