Foundation ASP for Dreamweaver 8

by Elbaga, Omar

• ISBN13: 9781590595688
• ISBN10: 1590595688
• Format: Paperback
• Copyright: 2006-01-30
• Publisher: Springer-Verlag New York Inc

Summary

This book looks specifically at using Dreamweaver's built- in server behaviours to build dynamic web sites using ASP, Microsoft's highly popular classic server-side language, along with Access or MySQL databases. The latest version of Dreamweaver includes even more powerful support for ASP. Examples built throughout the book include a content management system, and an online image gallery. All examples are designed to meet modern usability requirements and be web standards compliant. No previous experience of ASP or databases is required to use this book.

Table of Contents

About the Authors	xiv
About the Technical Reviewer	xv
Acknowledgments	xvi
Introduction	xvii
Dreamweaver and Dynamic Sites	1	(18)
Data exchange	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)
Checking out data	9	(1)
Connecting to databases	9	(1)
Where is ASP in Dreamweaver?	10	(7)
ASP features supported by Dreamweaver	10	(1)
Insert bar	11	(1)
The Insert bar's ASP tab	12	(2)
The Insert bar's Application tab	14	(2)
Application panel	16	(1)
The Databases tab	16	(1)
The Bindings tab	16	(1)
Conclusion	17	(2)
The Dreamweaver Environment	19	(26)
Workspace layout	19	(1)
The Multiple Document Interface	20	(12)
The CSS panel	21	(1)
The Application panel group	22	(1)
The Databases panel	22	(1)
The Bindings panel	23	(1)
The Server Behaviors panel	24	(1)
The Tag Inspector panel group	25	(1)
The Attributes panel	26	(1)
The Behaviors panel	26	(1)
The Files panel group	27	(1)
The Files panel	27	(1)
The Assets panel	28	(1)
The Snippets panel	28	(1)
The Properties panel	29	(1)
The Results panel group	30	(1)
The Search panel	30	(1)
The Validation panel	30	(1)
The Target Browser Check panel	31	(1)
The Link Checker panel	31	(1)
The Site Reports panel	31	(1)
The FTP Log panel	31	(1)
The Server Debug panel	32	(1)
The Reference panel	32	(1)
Toolbars	32	(7)
The Insert toolbar/panel group	32	(1)
The Document toolbar	33	(2)
The Standard toolbar	35	(1)
The Style Rendering toolbar	35	(1)
The Coding toolbar	36	(1)
New tools in Design view	37	(1)
Zoom	37	(1)
Magnification	37	(1)
Hand	37	(1)
Guides	37	(2)
Defining an ASP VBScript site in Dreamweaver	39	(4)
Local Info screen	39	(1)
Remote Info screen	40	(1)
Testing Server screen	41	(1)
Creating the site	42	(1)
Conclusion	43	(2)
A First Taste of ASP	45	(38)
Specify your language: VBScript	46	(1)
ASP delimiters <% %>	46	(1)
Insensitive case!	47	(1)
Variables	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)
Variable concatenation	54	(1)
Watching out for ``adding'' numbers	55	(1)
Variable naming conventions	56	(1)
Prefixes	56	(1)
Using Understandable variable names	56	(1)
Commenting code	57	(1)
VBScript's house of built-in functions	58	(3)
Conversion functions	58	(1)
String functions	59	(2)
Operators	61	(7)
Assignment operators	62	(1)
Logical operators	62	(1)
And, Or	62	(1)
Not	63	(1)
Comparison operators	64	(1)
Mathematical operators	65	(1)
Operator precedence	66	(2)
Conditional logic	68	(3)
The If statement	68	(1)
The If . . . Then . . . Else statement	69	(1)
The If . . . Then . . . Elself statement	69	(2)
Looping logic	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)
Cookie expiration	75	(1)
Updating cookies	75	(1)
Deleting cookies	76	(1)
A word of warning about the use of cookies	76	(1)
Session variables	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)
Note on sessions	79	(1)
Environment variables	79	(2)
Conclusion	81	(2)
Databases	83	(50)
Creating a database	84	(4)
Inside Microsoft Access	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)
Database design	91	(6)
Object naming conventions	91	(1)
Creating tables	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)
Fundamental SQL	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)
Useful SQL keywords	106	(7)
Count	107	(1)
Sum	107	(1)
Top	108	(1)
Between	108	(1)
Order By	109	(1)
In	110	(1)
Group By	111	(1)
Distinct	112	(1)
Going on a Date	113	(1)
Making the connection	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)
Using commands	122	(9)
Inserting a record	124	(1)
Updating a record	125	(2)
Updating multiple records (a simple example)	127	(1)
Deleting a record	128	(1)
Deleting multiple records (simple example)	129	(2)
Conclusion	131	(2)
Working with Forms	133	(42)
Form attributes: Action and Method	134	(1)
get method	134	(1)
post method	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)
ASP mail components	146	(1)
General requirements for mail components	147	(1)
Sending e-mail with mail components	148	(1)
Sending e-mail with CDO	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)
Creating a mailing list	170	(3)
Conclusion	173	(2)
Building a Random Quote Generator	175	(20)
Creating the quotes database table	176	(1)
Building the form	177	(2)
The Insert Record server behavior	179	(3)
Adding conditional code	180	(2)
The Repeat Region server behavior	182	(4)
The Update Record server behavior	186	(3)
The Delete Record server behavior	189	(3)
Conclusion	192	(3)
Completing the Quotes Administration System	195	(28)
Updating the quotes database table	196	(3)
Author administration	199	(2)
Building the Insert Author page	199	(2)
Category administration	201	(2)
Building the Insert Category page	201	(2)
Updating the Insert Quote page	203	(4)
Creating the recordsets	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)
Updating the edit page	208	(6)
Copying recordsets	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)
Conclusion	220	(3)
Restricting Access	223	(22)
Creating the administrators database table	224	(1)
Creating the login system	225	(8)
Building the login form	225	(2)
Adding the Log In User server behavior	227	(2)
Restricting access	229	(2)
Adding the Log Out User server behavior	231	(2)
Registering new users	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)
Updating the login form	239	(2)
Baking the cookies	241	(2)
Conclusion	243	(2)
Creating a Blog	245	(42)
Blogging application overview	246	(1)
The database	246	(1)
The blog display	246	(1)
Administrative controls	247	(1)
Administrative login/logout	247	(1)
The search function	247	(1)
Creating your blog database	247	(6)
Creating the database tables	249	(1)
Table 1: tbl_onews	249	(1)
Table 2: tbl_users	250	(1)
Populating the database tables	250	(1)
Populating tbl_onews	251	(1)
Populating tbl_users	251	(1)
Setting user permissions for tables	251	(2)
Connecting Dreamweaver to your database	253	(2)
Connection strings	253	(1)
DSN	254	(1)
Displaying blog entries	255	(11)
Creating onews_main.asp	255	(1)
Designing onews_main.asp	256	(1)
Wiring up onews_main.asp	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)
Blog administration	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)
Designing login.asp	277	(1)
Wiring up login.asp	278	(1)
Creating logout.asp	279	(2)
Searching your blog	281	(4)
Creating the search form	281	(1)
Creating the results page	281	(2)
Designing onews_searchresults.asp	283	(1)
Wiring up onews_searchresults.asp	283	(2)
Conclusion	285	(2)
Image Gallery	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)
Table 1: tbl_photoalbums	289	(1)
Table 2: tbl_photos	290	(2)
The relationship between tbl_photos and tbl_photoalbums	292	(2)
Connecting Dreamweaver to your database	294	(1)
Connection strings	294	(1)
Data Source Name (DSN)	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)
Creating addalbum.asp	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)
Creating upload.asp	307	(1)
Designing upload.asp	308	(1)
Wiring up upload.asp	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)
Conclusion	322	(5)
Index	327