Workshop
Just to see whether you were dozing through today's discussion, here are a few quiz questions and exercises. Answers to quiz questions can be found in Appendix A at the back of the text.
Quiz
| 1: | What ColdFusion tags denote the beginning and end of a query section? |
| 2: | In a basic SQL SELECT statement, what follows the word "FROM"? |
| 3: | What are the two types of operators used in a WHERE clause? |
| 4: | Why are single quotes necessary when using a text string in a query? |
| 5: | What is the character that always appears in conjunction with the LIKE operator? |
| 6: | Which SQL command orders output alphabetically or numerically? How is it used? |
Exercises
| 1: | Construct a sample database table with at least five fields. Set it up as a ColdFusion datasource and design a ... |
Get Sams Teach Yourself ColdFusion® in 21 Days now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
