Mastering these two
skills gives your Dreamweaver Web applications the access they require and the data they need. As you are
laying the foundation for your Dreamweaver pages, keep the following points in mind:
n A Dreamweaver connection??”after it is defined??”is available site-wide. Dreamweaver uses one
server-side include per page for each connection, but the connection file itself needs to be
uploaded to the site only once.
n Although DSN connections are the most straightforward, they also carry the greatest overhead.
Whenever possible, use OLE DB connections for the runtime connection.
n ASP developers may use the Server.MapPath() function to determine the physical location of
their database on a remote system. Dreamweaver allows Server.MapPath() to be used in a
custom connection string as well.
n Dreamweaver offers two entirely different interfaces for creating recordsets. The simple Recordset
dialog box can create recordsets relying on a single table and a single criterion, whereas the
advanced Recordset dialog box offers unlimited options, permitting you to write your own SQL
query.
n Recordsets can be copied from one page to another. You can modify the copy to receive a different
set of data with a minimum of effort.
In the next chapter, you learn how dynamic text is inserted, edited, and styled in Dreamweaver, as well as
how to link to dynamic images and flash elements.
Pages:
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187