• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 15. Connecting to Data Sources > Introducing SQL Queries

Introducing SQL Queries

Now that you've configured your database on the server and enabled ColdFusion to see it, you're ready to start using this data in your site. In the last two tasks of this lesson, you'll retrieve data from the database and then output it into a table. To access the data from the database, the ColdFusion document will need to communicate with the database. But there is a catch: Databases don't understand ColdFusion Markup Language (CFML).

The language that modern databases understand is SQL, which is pronounced “sequel,” and stands for Structured Query Language. ColdFusion—like ASP, PHP, and JSP—uses SQL to obtain information from a database, just like a database programmer would. Once that data is obtained, it can be manipulated and/or displayed on the page. Again, serious application developers need to learn quite a bit of SQL to build powerful applications. Thanks to Dreamweaver's dialog-based ways to construct SQL statements (the scripts used to access databases and the information stored in them), nonprogrammers and SQL newbies can still construct SQL queries fairly easily. In this task, you will create a bona fide SQL statement using a Dreamweaver dialog that will mask what you are doing.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint