Foundation ASP for Dreamweaver 8

By: Omar Elbaga, Rob Turnbull

Write A Review

Paperback | 1 December 2005

At a Glance

Paperback
364 Pages

Dimensions(cm)
23.5 x 19.05 x 1.91

Paperback

$54.99

or 4 interest-free payments of $13.75 with

Aims to ship in 7 to 10 business days

Do you want to learn about Microsoft's ASP and use it via Dreamweaver 8 to add the power of a database to your website? Use dynamic web forms to exchange data between you and your users? Build complete web applications? This book shows you how to do all that and more.

Dreamweaver 8 takes a lot of the hard work out of performing tasks such as integrating a database into your website, but it can't do everything. That's why this book not only shows you how to use all of Dreamweaver's functions, but also shows you how the underlying code functions, so you can then work around Dreamweaver's shortcomings. There's no attempt to turn you into a code guru, but you'll come away with sufficient knowledge of basic ASP to have the confidence to dive into the Dreamweaver code and tweak it to your own requirements. The emphasis is exclusively on ASP, so you don't waste any time on information that's not relevant to what you want to do.

Omar Elbaga and Rob Turnbull first take you through version 8 of Dreamweaver and how ASP fits into it, then look in-depth at setting up your work environment installing ASP, Access (and SQL Server), and the IIS web server, making sure they are all working together, and setting up a new web site via Dreamweaver. They then get to work, using several tutorials and real world examples, covering topics such as ASP essentials (knowing what ASP code looks like), working with forms, designing and implementing effective databases using Access and SQL Server, debugging and troubleshooting, and creating dynamic navigation, login, and search functionality.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Graphical & Digital Media Applications Web Graphics & Design Computer Programming & Software Development Web Programming Software Engineering Microsoft Programming Digital Lifestyle & Online World: Consumer & User Guides Internet Guides & Online Services

About the Authors	p. xiv
About the Technical Reviewer	p. xv
Acknowledgments	p. xvi
Introduction	p. xvii
Dreamweaver and Dynamic Sites	p. 1
Data exchange	p. 2
Dynamic takes over static	p. 7
Dreamweaver server models	p. 7
The ASP VBScript server model	p. 7
What Dreamweaver 8 offers you as an ASP developer	p. 9
Checking out data	p. 9
Connecting to databases	p. 9
Where is ASP in Dreamweaver?	p. 10
ASP features supported by Dreamweaver	p. 10
Insert bar	p. 11
The Insert bar's ASP tab	p. 12
The Insert bar's Application tab	p. 14
Application panel	p. 16
The Databases tab	p. 16
The Bindings tab	p. 16
Conclusion	p. 17
The Dreamweaver Environment	p. 19
Workspace layout	p. 19
The Multiple Document Interface	p. 20
The CSS panel	p. 21
The Application panel group	p. 22
The Databases panel	p. 22
The Bindings panel	p. 23
The Server Behaviors panel	p. 24
The Tag Inspector panel group	p. 25
The Attributes panel	p. 26
The Behaviors panel	p. 26
The Files panel group	p. 27
The Files panel	p. 27
The Assets panel	p. 28
The Snippets panel	p. 28
The Properties panel	p. 29
The Results panel group	p. 30
The Search panel	p. 30
The Validation panel	p. 30
The Target Browser Check panel	p. 31
The Link Checker panel	p. 31
The Site Reports panel	p. 31
The FTP Log panel	p. 31
The Server Debug panel	p. 32
The Reference panel	p. 32
Toolbars	p. 32
The Insert toolbar/panel group	p. 32
The Document toolbar	p. 33
The Standard toolbar	p. 35
The Style Rendering toolbar	p. 35
The Coding toolbar	p. 36
New tools in Design view	p. 37
Zoom	p. 37
Magnification	p. 37
Hand	p. 37
Guides	p. 37
Defining an ASP VBScript site in Dreamweaver	p. 39
Local Info screen	p. 39
Remote Info screen	p. 40
Testing Server screen	p. 41
Creating the site	p. 42
Conclusion	p. 43
A First Taste of ASP	p. 45
Specify your language: VBScript	p. 46
ASP delimiters	p. 46
Insensitive case!	p. 47
Variables	p. 48
Declaring and printing variables	p. 49
Letting VBScript declare variables implicitly	p. 52
Syntax rules for variables	p. 52
Data types: string, integer, and Boolean	p. 52
Variable concatenation	p. 54
Watching out for "adding" numbers	p. 55
Variable naming conventions	p. 56
Prefixes	p. 56
Using understandable variable names	p. 56
Commenting code	p. 57
VBScript's house of built-in functions	p. 58
Conversion functions	p. 58
String functions	p. 59
Operators	p. 61
Assignment operators	p. 62
Logical operators	p. 62
AND, OR	p. 62
NOT	p. 63
Comparison operators	p. 64
Mathematical operators	p. 65
Operator precedence	p. 66
Conditional logic	p. 68
The If statement	p. 68
The If ... Then ... Else statement	p. 69
The If ... Then ... Elself statement	p. 69
Looping logic	p. 71
The Do ... Loop statement	p. 71
The While ... Wend statement	p. 72
Cookies (ASP cookies, not chocolate chip!)	p. 72
Response.Cookies and Request.Cookies	p. 73
Cookie expiration	p. 75
Updating cookies	p. 75
Deleting cookies	p. 76
A word of warning about the use of cookies	p. 76
Session variables	p. 76
Setting the session timeout interval	p. 77
Creating and retrieving session variables	p. 77
Updating session variables	p. 78
Deleting session variables	p. 78
Note on sessions	p. 79
Environment variables	p. 79
Conclusion	p. 81
Databases	p. 83
Creating a database	p. 84
Inside Microsoft Access	p. 84
Inside Microsoft SQL Server	p. 85
Preparing a SQL Server database for Internet use	p. 88
Creating the IUSR account in SQL Server	p. 89
Database design	p. 91
Object naming conventions	p. 91
Creating tables	p. 92
Creating tables in Access	p. 93
Creating tables in SQL Server	p. 95
Relational databases and referential integrity	p. 97
Creating a relationship in Access	p. 98
Creating a relationship in SQL Server	p. 100
SQL Server views and Access queries	p. 102
Fundamental SQL	p. 103
Selecting all records from a table	p. 104
Selecting all records that meet one criterion	p. 104
Selecting all records that meet several criteria (using AND)	p. 105
Selecting records that meet one or more of several criteria (using OR)	p. 105
Useful SQL keywords	p. 106
COUNT	p. 107
SUM	p. 107
TOP	p. 108
BETWEEN	p. 108
ORDER BY	p. 109
IN	p. 110
GROUP BY	p. 111
DISTINCT	p. 112
Going on a DATE	p. 113
Making the connection	p. 113
Setting up a DSN to an Access database	p. 114
Setting up a DSN to a SQL Server database	p. 114
Connecting from Dreamweaver	p. 115
The Simple Recordset builder	p. 116
The Advanced Recordset builder	p. 119
Using commands	p. 122
Inserting a record	p. 124
Updating a record	p. 125
Updating multiple records (a simple example)	p. 127
Deleting a record	p. 128
Deleting multiple records (simple example)	p. 129
Conclusion	p. 131
Working with Forms	p. 133
Form attributes: Action and Method	p. 134
get method	p. 134
post method	p. 135
Retrieving form values with Request.Form	p. 135
Creating sample login forms	p. 135
Forms with text box elements	p. 136
Forms with list/menu elements	p. 137
Menu element selection form with conditional logic	p. 138
Forms with check box elements	p. 139
Receiving data from a URL parameter	p. 141
Retrieving URL parameters with Request.QueryString	p. 141
Sending form values to e-mail	p. 143
Setting up your SMTP server	p. 143
ASP mail components	p. 146
General requirements for mail components	p. 147
Sending e-mail with mail components	p. 148
Sending e-mail with CDO	p. 148
Sending mail with AspEmail	p. 151
Sending e-mail with JMail	p. 154
Dynamic e-mail interaction	p. 156
Sending e-mail by hyperlink	p. 156
Sending e-mail via a form button	p. 158
Making e-mail property values dynamic	p. 160
Sending e-mail with dynamic values	p. 160
Sending e-mail with dynamic form field values	p. 162
Sending a page to a friend	p. 164
Real-world examples using forms	p. 167
Sending a user a forgotten password	p. 167
Creating a mailing list	p. 170
Conclusion	p. 173
Building a Random Quote Generator	p. 175
Creating the quotes database table	p. 176
Building the form	p. 177
The Insert Record server behavior	p. 179
Adding conditional code	p. 180
The Repeat Region server behavior	p. 182
The Update Record server behavior	p. 186
The Delete Record server behavior	p. 189
Conclusion	p. 192
Completing the Quotes Administration System	p. 195
Updating the quotes database table	p. 196
Author administration	p. 199
Building the Insert Author page	p. 199
Category administration	p. 201
Building the Insert Category page	p. 201
Updating the Insert Quote page	p. 203
Creating the recordsets	p. 203
Building the Authors recordset	p. 203
Building the Categories recordset	p. 204
Building dynamic select lists	p. 204
Updating the Insert server behavior	p. 207
Updating the edit page	p. 208
Copying recordsets	p. 208
Adding authors and categories to the edit page	p. 210
Updating the Quotes recordset	p. 211
Binding dynamic select lists with a selected item	p. 211
Updating the Update server behavior	p. 213
The random quote generator	p. 214
Creating a join in the database	p. 214
Displaying a random quote	p. 216
Building the Quotes recordset	p. 217
Conclusion	p. 220
Restricting Access	p. 223
Creating the administrators database table	p. 224
Creating the login system	p. 225
Building the login form	p. 225
Adding the Log In User server behavior	p. 227
Restricting access	p. 229
Adding the Log Out User server behavior	p. 231
Registering new users	p. 233
Checking the new username	p. 235
Creating a user-friendly login	p. 236
Expanding the Log In User server behavior code	p. 237
Implementing the "remember me" feature	p. 239
Updating the login form	p. 239
Baking the cookies	p. 241
Conclusion	p. 243
Creating a Blog	p. 245
Blogging application overview	p. 246
The database	p. 246
The blog display	p. 246
Administrative controls	p. 247
Administrative login/logout	p. 247
The search function	p. 247
Creating your blog database	p. 247
Creating the database tables	p. 249
tbl_onews	p. 249
tbl_users	p. 250
Populating the database tables	p. 250
Populating tbl_onews	p. 251
Populating tbl_users	p. 251
Setting user permissions for tables	p. 251
Connecting Dreamweaver to your database	p. 253
Connection strings	p. 253
DSN	p. 254
Displaying blog entries	p. 255
Creating onews_main.asp	p. 255
Designing onews_main.asp	p. 256
Wiring up onews_main.asp	p. 257
Creating onews_details.asp	p. 261
Designing onews_details.asp	p. 262
Wiring up onews_details.asp	p. 262
Creating onews_archives.asp	p. 264
Designing onews_archives.asp	p. 264
Wiring up onews_archives.asp	p. 265
Blog administration	p. 266
Creating onews_admin_archives.asp	p. 266
Designing onews_admin_archives.asp	p. 267
Wiring up onews_admin_archives.asp	p. 268
Creating onews_admin_details.asp	p. 270
Designing onews_admin_details.asp	p. 271
Wiring up onews_admin_details.asp	p. 273
Securing the blog administration pages and creating login/logout functionality	p. 276
Designing login.asp	p. 277
Wiring up login.asp	p. 278
Creating logout.asp	p. 279
Searching your blog	p. 281
Creating the search form	p. 281
Creating the results page	p. 281
Designing onews_searchresults.asp	p. 283
Wiring up onews_searchresults.asp	p. 283
Conclusion	p. 285
Image Gallery	p. 287
Overview of the image gallery application	p. 287
Storing information in the database	p. 288
Inserting, editing, and displaying albums	p. 288
Uploading and displaying photos	p. 288
Editing captions and deleting photos	p. 288
Creating the database for the image gallery	p. 289
tbl_photoalbums	p. 289
tbl_photos	p. 290
The relationship between tbl_photos and tbl_photoalbums	p. 292
Connecting Dreamweaver to your database	p. 294
Connection strings	p. 294
Data Source Name (DSN)	p. 295
Inserting, editing, and displaying albums in the image gallery	p. 295
Creating myphotos_main.asp	p. 295
Designing the main web page	p. 297
Implementing the dynamic features of the main web page	p. 298
Creating addalbum.asp	p. 301
Designing the Add Album page	p. 301
Wiring up the Add Album page	p. 302
Creating edit_photo_album.asp	p. 304
Implementing the dynamic features	p. 304
Creating pages for uploading and displaying photos	p. 307
Creating upload.asp	p. 307
Designing upload.asp	p. 308
Wiring up upload.asp	p. 309
Creating upload_action.asp	p. 312
Creating the Edit Caption and Delete Photo pages	p. 316
Creating edit_caption.asp	p. 317
Creating delete_action.asp	p. 320
Conclusion	p. 322
Index	p. 327
Table of Contents provided by Ingram. All Rights Reserved.

Foundation ASP for Dreamweaver 8

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Web Graphics & Design

This Is Service Design Methods

A Companion to This Is Service Design Doing

Laws of UX

2nd Edition - Using Psychology to Design Better Products & Services

Confident Coding

How to Write Code and Futureproof Your Career

Learning Web Design

A Beginner's Guide to Html, Css, Javascript, and Web Graphics

Learning React

Modern Patterns for Developing React Apps

Don't Make Me Think, Revisited

A Common Sense Approach to Web Usability

Strategic Writing for UX

Drive Engagement, Conversion, and Retention with Every Word

Wordpress: The Missing Manual

The Book That Should Have Been in the Box 3rd Edition

Getting Started with 3D Printing

2nd Edition

CSS: The Definitive Guide

Web Layout and Presentation

UX Strategy

How to Devise Innovative Digital Products that People Want 2nd Edition

Learning Web Design

A Beginner's Guide to HTML, CSS, JavaScript, and Web Graphics : 5th Edition

Org Design for Design Orgs

Learning JavaScript Design Patterns

A JavaScript and React Developer's Guide

Fast and Slow

Methods for Timely HCI and Interaction Design Research

CHART

Designing Creative Data Visualizations from Charts to Art

Ajax For Dummies

For Dummies

The Anticipatory Design Playbook

A UX Guide to Design AI-Driven Experiences

The Anticipatory Design Playbook

A UX Guide to Design AI-Driven Experiences

Cloud Computing Security

Strategies and Best Practices

Cloud Computing Security

Strategies and Best Practices

Impact

A Complete Guide to Creating a User Research Practice at Your Organization

Technical Communication and the Discipline of Content

Considerations for Research, Training, and Career Readiness

Technical Communication and the Discipline of Content

Considerations for Research, Training, and Career Readiness

This product is categorised by