About the Authors |
|
xiv | |
About the Technical Reviewer |
|
xv | |
Acknowledgments |
|
xvi | |
Introduction |
|
xvii | |
|
Dreamweaver and Dynamic Sites |
|
|
1 | (18) |
|
|
2 | (5) |
|
Dynamic takes over static |
|
|
7 | (1) |
|
Dreamweaver server models |
|
|
7 | (2) |
|
The ASP VBScript server model |
|
|
7 | (2) |
|
What Dreamweaver 8 offers you as an ASP developer |
|
|
9 | (1) |
|
|
9 | (1) |
|
|
9 | (1) |
|
Where is ASP in Dreamweaver? |
|
|
10 | (7) |
|
ASP features supported by Dreamweaver |
|
|
10 | (1) |
|
|
11 | (1) |
|
|
12 | (2) |
|
The Insert bar's Application tab |
|
|
14 | (2) |
|
|
16 | (1) |
|
|
16 | (1) |
|
|
16 | (1) |
|
|
17 | (2) |
|
The Dreamweaver Environment |
|
|
19 | (26) |
|
|
19 | (1) |
|
The Multiple Document Interface |
|
|
20 | (12) |
|
|
21 | (1) |
|
The Application panel group |
|
|
22 | (1) |
|
|
22 | (1) |
|
|
23 | (1) |
|
The Server Behaviors panel |
|
|
24 | (1) |
|
The Tag Inspector panel group |
|
|
25 | (1) |
|
|
26 | (1) |
|
|
26 | (1) |
|
|
27 | (1) |
|
|
27 | (1) |
|
|
28 | (1) |
|
|
28 | (1) |
|
|
29 | (1) |
|
|
30 | (1) |
|
|
30 | (1) |
|
|
30 | (1) |
|
The Target Browser Check panel |
|
|
31 | (1) |
|
|
31 | (1) |
|
|
31 | (1) |
|
|
31 | (1) |
|
|
32 | (1) |
|
|
32 | (1) |
|
|
32 | (7) |
|
The Insert toolbar/panel group |
|
|
32 | (1) |
|
|
33 | (2) |
|
|
35 | (1) |
|
The Style Rendering toolbar |
|
|
35 | (1) |
|
|
36 | (1) |
|
|
37 | (1) |
|
|
37 | (1) |
|
|
37 | (1) |
|
|
37 | (1) |
|
|
37 | (2) |
|
Defining an ASP VBScript site in Dreamweaver |
|
|
39 | (4) |
|
|
39 | (1) |
|
|
40 | (1) |
|
|
41 | (1) |
|
|
42 | (1) |
|
|
43 | (2) |
|
|
45 | (38) |
|
Specify your language: VBScript |
|
|
46 | (1) |
|
|
46 | (1) |
|
|
47 | (1) |
|
|
48 | (9) |
|
Declaring and printing variables |
|
|
49 | (3) |
|
Letting VBScript declare variables implicitly |
|
|
52 | (1) |
|
Syntax rules for variables |
|
|
52 | (1) |
|
Data types: string, integer, and Boolean |
|
|
52 | (2) |
|
|
54 | (1) |
|
Watching out for ``adding'' numbers |
|
|
55 | (1) |
|
Variable naming conventions |
|
|
56 | (1) |
|
|
56 | (1) |
|
Using Understandable variable names |
|
|
56 | (1) |
|
|
57 | (1) |
|
VBScript's house of built-in functions |
|
|
58 | (3) |
|
|
58 | (1) |
|
|
59 | (2) |
|
|
61 | (7) |
|
|
62 | (1) |
|
|
62 | (1) |
|
|
62 | (1) |
|
|
63 | (1) |
|
|
64 | (1) |
|
|
65 | (1) |
|
|
66 | (2) |
|
|
68 | (3) |
|
|
68 | (1) |
|
The If . . . Then . . . Else statement |
|
|
69 | (1) |
|
The If . . . Then . . . Elself statement |
|
|
69 | (2) |
|
|
71 | (1) |
|
The Do . . . Loop statement |
|
|
71 | (1) |
|
The While . . . Wend statement |
|
|
72 | (1) |
|
Cookies (ASP cookies, not chocolate chip!) |
|
|
72 | (4) |
|
Response.Cookies and Request.Cookies |
|
|
73 | (2) |
|
|
75 | (1) |
|
|
75 | (1) |
|
|
76 | (1) |
|
A word of warning about the use of cookies |
|
|
76 | (1) |
|
|
76 | (3) |
|
Setting the session timeout interval |
|
|
77 | (1) |
|
Creating and retrieving session variables |
|
|
77 | (1) |
|
Updating session variables |
|
|
78 | (1) |
|
Deleting session variables |
|
|
78 | (1) |
|
|
79 | (1) |
|
|
79 | (2) |
|
|
81 | (2) |
|
|
83 | (50) |
|
|
84 | (4) |
|
|
84 | (1) |
|
Inside Microsoft SQL Server |
|
|
85 | (3) |
|
Preparing a SQL Server database for Internet use |
|
|
88 | (3) |
|
Creating the IUSR account in SQL Server |
|
|
89 | (2) |
|
|
91 | (6) |
|
Object naming conventions |
|
|
91 | (1) |
|
|
92 | (1) |
|
Creating tables in Access |
|
|
93 | (2) |
|
Creating tables in SQL Server |
|
|
95 | (2) |
|
Relational databases and referential integrity |
|
|
97 | (6) |
|
Creating a relationship in Access |
|
|
98 | (2) |
|
Creating a relationship in SQL Server |
|
|
100 | (2) |
|
SQL Server views and Access queries |
|
|
102 | (1) |
|
|
103 | (3) |
|
Selecting all records from a table |
|
|
104 | (1) |
|
Selecting all records that meet one criterion |
|
|
104 | (1) |
|
Selecting all records that meet several criteria (using And) |
|
|
105 | (1) |
|
Selecting records that meet one or more of several criteria (using OR) |
|
|
105 | (1) |
|
|
106 | (7) |
|
|
107 | (1) |
|
|
107 | (1) |
|
|
108 | (1) |
|
|
108 | (1) |
|
|
109 | (1) |
|
|
110 | (1) |
|
|
111 | (1) |
|
|
112 | (1) |
|
|
113 | (1) |
|
|
113 | (3) |
|
Setting up a DSN to an Access database |
|
|
114 | (1) |
|
Setting up a DSN to a SQL Server database |
|
|
114 | (1) |
|
Connecting from Dreamweaver |
|
|
115 | (1) |
|
The Simple Recordset builder |
|
|
116 | (3) |
|
The Advanced Recordset builder |
|
|
119 | (3) |
|
|
122 | (9) |
|
|
124 | (1) |
|
|
125 | (2) |
|
Updating multiple records (a simple example) |
|
|
127 | (1) |
|
|
128 | (1) |
|
Deleting multiple records (simple example) |
|
|
129 | (2) |
|
|
131 | (2) |
|
|
133 | (42) |
|
Form attributes: Action and Method |
|
|
134 | (1) |
|
|
134 | (1) |
|
|
135 | (1) |
|
Retrieving form values with Request.Form |
|
|
135 | (1) |
|
Creating sample login forms |
|
|
135 | (8) |
|
Forms with text box elements |
|
|
136 | (1) |
|
Forms with list/menu elements |
|
|
137 | (1) |
|
Menu element selection form with conditional logic |
|
|
138 | (1) |
|
Forms with check box elements |
|
|
139 | (2) |
|
Receiving data from a URL parameter |
|
|
141 | (1) |
|
Retrieving URL parameters with Request.QueryString |
|
|
141 | (2) |
|
Sending form values to e-mail |
|
|
143 | (13) |
|
Setting up your SMTP server |
|
|
143 | (3) |
|
|
146 | (1) |
|
General requirements for mail components |
|
|
147 | (1) |
|
Sending e-mail with mail components |
|
|
148 | (1) |
|
|
148 | (3) |
|
Sending mail with AspEmail |
|
|
151 | (3) |
|
Sending e-mail with JMail |
|
|
154 | (2) |
|
Dynamic e-mail interaction |
|
|
156 | (11) |
|
Sending e-mail by hyperlink |
|
|
156 | (2) |
|
Sending e-mail via a form button |
|
|
158 | (2) |
|
Making e-mail property values dynamic |
|
|
160 | (1) |
|
Sending e-mail with dynamic values |
|
|
160 | (2) |
|
Sending e-mail with dynamic form field values |
|
|
162 | (2) |
|
Sending a page to a friend |
|
|
164 | (3) |
|
Real-world examples using forms |
|
|
167 | (6) |
|
Sending a user a forgotten password |
|
|
167 | (3) |
|
|
170 | (3) |
|
|
173 | (2) |
|
Building a Random Quote Generator |
|
|
175 | (20) |
|
Creating the quotes database table |
|
|
176 | (1) |
|
|
177 | (2) |
|
The Insert Record server behavior |
|
|
179 | (3) |
|
|
180 | (2) |
|
The Repeat Region server behavior |
|
|
182 | (4) |
|
The Update Record server behavior |
|
|
186 | (3) |
|
The Delete Record server behavior |
|
|
189 | (3) |
|
|
192 | (3) |
|
Completing the Quotes Administration System |
|
|
195 | (28) |
|
Updating the quotes database table |
|
|
196 | (3) |
|
|
199 | (2) |
|
Building the Insert Author page |
|
|
199 | (2) |
|
|
201 | (2) |
|
Building the Insert Category page |
|
|
201 | (2) |
|
Updating the Insert Quote page |
|
|
203 | (4) |
|
|
203 | (1) |
|
Building the Authors recordset |
|
|
203 | (1) |
|
Building the Categories recordset |
|
|
204 | (1) |
|
Building dynamic select lists |
|
|
204 | (3) |
|
Updating the Insert server behavior |
|
|
207 | (1) |
|
|
208 | (6) |
|
|
208 | (2) |
|
Adding authors and categories to the edit page |
|
|
210 | (1) |
|
Updating the Quotes recordset |
|
|
211 | (1) |
|
Binding dynamic select lists with a selected item |
|
|
211 | (2) |
|
Updating the Update server behavior |
|
|
213 | (1) |
|
The random quote generator |
|
|
214 | (6) |
|
Creating a join in the database |
|
|
214 | (2) |
|
Displaying a random quote |
|
|
216 | (1) |
|
Building the Quotes recordset |
|
|
217 | (3) |
|
|
220 | (3) |
|
|
223 | (22) |
|
Creating the administrators database table |
|
|
224 | (1) |
|
Creating the login system |
|
|
225 | (8) |
|
|
225 | (2) |
|
Adding the Log In User server behavior |
|
|
227 | (2) |
|
|
229 | (2) |
|
Adding the Log Out User server behavior |
|
|
231 | (2) |
|
|
233 | (3) |
|
Checking the new username |
|
|
235 | (1) |
|
Creating a user-friendly login |
|
|
236 | (1) |
|
Expanding the Log In User server behavior code |
|
|
237 | (2) |
|
Implementing the ``remember me'' feature |
|
|
239 | (4) |
|
|
239 | (2) |
|
|
241 | (2) |
|
|
243 | (2) |
|
|
245 | (42) |
|
Blogging application overview |
|
|
246 | (1) |
|
|
246 | (1) |
|
|
246 | (1) |
|
|
247 | (1) |
|
Administrative login/logout |
|
|
247 | (1) |
|
|
247 | (1) |
|
Creating your blog database |
|
|
247 | (6) |
|
Creating the database tables |
|
|
249 | (1) |
|
|
249 | (1) |
|
|
250 | (1) |
|
Populating the database tables |
|
|
250 | (1) |
|
|
251 | (1) |
|
|
251 | (1) |
|
Setting user permissions for tables |
|
|
251 | (2) |
|
Connecting Dreamweaver to your database |
|
|
253 | (2) |
|
|
253 | (1) |
|
|
254 | (1) |
|
|
255 | (11) |
|
|
255 | (1) |
|
|
256 | (1) |
|
|
257 | (4) |
|
Creating onews_details.asp |
|
|
261 | (1) |
|
Designing onews_details.asp |
|
|
262 | (1) |
|
Wiring up onews_details.asp |
|
|
262 | (2) |
|
Creating onews_archives.asp |
|
|
264 | (1) |
|
Designing onews_archives.asp |
|
|
264 | (1) |
|
Wiring up onews_archives.asp |
|
|
265 | (1) |
|
|
266 | (10) |
|
Creating onews_admin_archives.asp |
|
|
266 | (1) |
|
Designing onews_admin_archives.asp |
|
|
267 | (1) |
|
Wiring up onews_admin_archives.asp |
|
|
268 | (2) |
|
Creating onews_admin_details.asp |
|
|
270 | (1) |
|
Designing onews_admin_details.asp |
|
|
271 | (2) |
|
Wiring up onews_admin_details.asp |
|
|
273 | (3) |
|
Securing the blog administration pages and creating login/logout functionality |
|
|
276 | (5) |
|
|
277 | (1) |
|
|
278 | (1) |
|
|
279 | (2) |
|
|
281 | (4) |
|
|
281 | (1) |
|
Creating the results page |
|
|
281 | (2) |
|
Designing onews_searchresults.asp |
|
|
283 | (1) |
|
Wiring up onews_searchresults.asp |
|
|
283 | (2) |
|
|
285 | (2) |
|
|
287 | (40) |
|
Overview of the image gallery application |
|
|
287 | (2) |
|
Storing information in the database |
|
|
288 | (1) |
|
Inserting, editing, and displaying albums |
|
|
288 | (1) |
|
Uploading and displaying photos |
|
|
288 | (1) |
|
Editing captions and deleting photos |
|
|
288 | (1) |
|
Creating the database for the image gallery |
|
|
289 | (5) |
|
|
289 | (1) |
|
|
290 | (2) |
|
The relationship between tbl_photos and tbl_photoalbums |
|
|
292 | (2) |
|
Connecting Dreamweaver to your database |
|
|
294 | (1) |
|
|
294 | (1) |
|
|
295 | (1) |
|
Inserting, editing, and displaying albums in the image gallery |
|
|
295 | (12) |
|
Creating myphotos_main.asp |
|
|
295 | (2) |
|
Designing the main web page |
|
|
297 | (1) |
|
Implementing the dynamic features of the main web page |
|
|
298 | (3) |
|
|
301 | (1) |
|
Designing the Add Album page |
|
|
301 | (1) |
|
Wiring up the Add Album page |
|
|
302 | (2) |
|
Creating edit_photo_album.asp |
|
|
304 | (1) |
|
Implementing the dynamic features |
|
|
304 | (3) |
|
Creating pages for uploading and displaying photos |
|
|
307 | (15) |
|
|
307 | (1) |
|
|
308 | (1) |
|
|
309 | (3) |
|
Creating upload_action.asp |
|
|
312 | (4) |
|
Creating the Edit Caption and Delete Photo pages |
|
|
316 | (1) |
|
Creating edit_caption.asp |
|
|
317 | (3) |
|
Creating delete_action.asp |
|
|
320 | (2) |
|
|
322 | (5) |
Index |
|
327 | |