Accessing a database
An application server lets you work with server side resources such as 
databases. For example, a dynamic page may instruct the application server 
to extract data from a database and insert it into the page's HTML. For 
more information, see 
Appendix A,  Beginner's Guide to Databases 
 in 
Using Dreamweaver.
The instruction to extract data from a database is called a database query. A 
query consists of search criteria expressed in a database language called 
SQL (Structured Query Language). The SQL query is written into the 
page's server side scripts or tags. 
An application server cannot communicate directly with a database because 
the database's proprietary format renders the data undecipherable in much 
the same way that a Microsoft Word document opened in Notepad or 
BBEdit may be undecipherable. The application server can communicate 
with the database only through the intermediary of a database driver: 
software that acts like an interpreter between the application server and the 
database. 
After the driver establishes communication, the query is executed against 
the database and a recordset is created. A recordset is a set of data extracted 
from one or more tables in a database. The recordset is returned to the 
application server, which uses the data to complete the page.
Here's a simple database query written in SQL:
SELECT lastname, firstname, fitpoints
FROM employees
This statement creates a three column recordset and fills it with rows 
containing the last name, first name, and fitness points of all employees in 
the database. For more information, see 
Appendix B,  SQL Primer 
 in 
Using Dreamweaver. 
222 Understanding Web Applications






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

dreamweaver web hosting

 

Our partners: PHP: Hypertext Preprocessor Best Web Hosting Java Web Hosting Jsp Web Hosting Cheapest Web Hosting

Visionwebhosting.net Business web hosting division of Web Design Plus. All rights reserved