You can connect to virtually
any data source??”databases, spreadsheets, and even standard text files??”in a
number of different ways. Dreamweaver offers a variety of connection types, ranging
from the simplest with the highest overhead, DSN (Data Source Name), to the
more complex, but most efficient, OLE DB. This chapter explains how the connections
are made in Dreamweaver and why some are more robust than others.
After you have established a connection and your Web page is ready to communicate
with your data source, you must create a recordset. You can think of a
recordset as the key topic of conversation in a dialogue between a Web application
and a data source. It is the result of a query made to the database based on
your specifications.
For most basic recordsets, Dreamweaver provides a point-and-click interface. You
can also construct more advanced recordsets that make extensive use of
Structured Query Language (SQL) within Dreamweaver. Both methods are
detailed in this chapter; if you are a beginner unfamiliar with database concepts,
be sure to read the following section.
Data Source Basics
Data sources store information systematically. Here, the crucial word is systematically.
Many other technologies, both low end and high end, store information??”
a shelf of books, a shoebox full of receipts, even a collection of Web pages.
Pages:
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135