Sams Teach Yourself E-Commerce Programming with ASP in 21 Days (Sams Teach Yourself)

Sams E-Commerce Programming with ASP in 21Days Teach Yourself......Page 2
Copyright © 2000 by Sams......Page 3
Contents at a Glance......Page 4
Contents......Page 6
About the Authors......Page 15
Tell Us What You Think!......Page 17
Introduction......Page 18
WEEK 1 At A Glance......Page 22
DAY 1 Introduction to E-Commerce......Page 24
What Is E-Commerce?......Page 25
Microsoft Technologies for E-Commerce......Page 26
What Is an ASP Page?......Page 30
Summary......Page 34
Workshop......Page 35
DAY 2 Interacting with the Customer......Page 38
Working with the Response Object......Page 39
Working with the Request Object......Page 44
Retrieving Query String and Form Variables......Page 55
Q&A......Page 60
Workshop......Page 61
DAY 3 Using Application and Session Objects in E-Commerce Applications......Page 64
Tracking Customers with Cookies......Page 65
Tracking Customers with Session Variables......Page 69
Using Application Variables......Page 74
Using the Global.asa File......Page 79
Summary......Page 82
Q&A......Page 83
Workshop......Page 84
Including Files in an ASP Page......Page 86
Using File Redirection......Page 92
Using the File Access Component......Page 94
Summary......Page 102
Workshop......Page 103
Creating the Store Database......Page 106
Creating the Products Table......Page 108
Connecting to a Database......Page 110
Adding Products to the Products Table......Page 112
Updating Product Information in the Products Table......Page 121
Q&A......Page 134
Workshop......Page 135
Using Recordsets......Page 136
Displaying Products......Page 140
Making Your Store More Scalable......Page 154
Workshop......Page 157
Displaying a Rotating List of Featured Products......Page 160
Creating a Search Page......Page 169
Creating Indexable Web Pages......Page 175
Workshop......Page 177
Bonus Project......Page 180
WEEK 2 At A Glance......Page 184
DAY 8 Building the Transaction Databases......Page 186
The Transaction Database Tables......Page 187
Creating the Users Database Table......Page 188
Registering Users......Page 189
Gracefully Handling Form Errors......Page 198
Using the Secure Sockets Layer......Page 200
Summary......Page 205
Workshop......Page 206
Using Session Variables to Create a Shopping Cart......Page 208
Using Native ADO Methods......Page 217
Using a Database Table to Create a Shopping Cart......Page 221
Q&A......Page 228
Workshop......Page 229
Understanding Transactions......Page 230
Completing the Order......Page 236
Processing Orders......Page 243
Q&A......Page 251
Workshop......Page 252
Methods of Processing Credit Cards......Page 254
Preparing for CyberCash......Page 257
Authorizing a Credit Card Transaction......Page 262
Settling Credit Card Transactions......Page 271
Q&A......Page 273
Workshop......Page 274
DAY 12 Letting Customers Track Their Orders......Page 276
Enabling Customers to Track Orders with a Web Page......Page 277
Calculating Shipping Costs......Page 281
Summary......Page 288
Workshop......Page 289
DAY 13 Creating a Subscription-Based Site......Page 290
Using HTTP Authentication......Page 291
Using Database Authentication......Page 293
Using Hybrid Authentication......Page 304
Summary......Page 311
Workshop......Page 312
Retrieving the Existing User Settings......Page 314
Showing Past Purchases......Page 319
Advertising Items Your Customers Would Like......Page 324
Q&A......Page 333
Workshop......Page 334
WEEK 2 In Review......Page 336
Bonus Project......Page 337
WEEK 3 At A Glance......Page 340
DAY 15 Securing Your Store......Page 342
Registering Your Own Domain......Page 343
Making Your Server More Secure......Page 346
Protecting Your Users’ Private Information with SSL......Page 352
Protecting Your Database......Page 354
Registering with the Better Business Bureau Reliability Program......Page 355
Establishing a Privacy Policy and Joining a Privacy Seal Program......Page 356
The Better Business Bureau’s Children’s Advertising Review Unit Guidelines......Page 358
Summary......Page 359
Workshop......Page 360
DAY 16 Debugging Your E-Commerce Applications......Page 362
Keeping Your Development and Production Systems Separate......Page 363
Debugging Your Application Using Visual InterDev’s Integrated Debugger......Page 371
Debugging Your Application on a Production Server......Page 378
Capturing Errors into a Log File......Page 386
Testing for Scalability......Page 389
Summary......Page 390
Q&A......Page 391
Workshop......Page 392
DAY 17 Administering Your Store Remotely with ASPs......Page 394
The IIS Administration Pages......Page 395
Installing and Administering the IIS FTP Service......Page 402
Uploading Files to Your Site Using FTP......Page 404
Advanced Web-Based Product Catalog Maintenance......Page 406
Summary......Page 424
Workshop......Page 425
DAY 18 Using Email from Active Server Pages......Page 426
The Basics of Internet Mail......Page 427
Configuring the SMTP Service......Page 428
The Collaboration Data Objects for NT Server (CDONTS)......Page 431
Sending Email from an ASP Page......Page 432
Sending Batches of Email......Page 445
Q&A......Page 455
Workshop......Page 456
Reporting on Site Usage......Page 458
Workshop......Page 482
DAY 20 Working with Wallets......Page 484
Physical Commerce Versus Electronic Commerce......Page 485
Wallet Standards......Page 492
Your Own Store Wallet......Page 493
Summary......Page 509
Workshop......Page 510
DAY 21 Promoting Your Site and Managing Banner Advertising......Page 512
Search Engines......Page 513
Web Rings......Page 525
Banner Ads......Page 527
Participating in Reward Programs......Page 530
Other Ways to Increase Revenue......Page 531
Workshop......Page 534
WEEK 3 In Review......Page 536
Bonus Project......Page 537
APPENDIX A Quiz Answers......Page 540
APPENDIX B Frequently Asked Questions About Active Server Pages......Page 562
APPENDIX C SQL Reference......Page 576
INDEX......Page 588