ASP Programming for the Absolute Beginner

Macromedia HomeSite, 19–20 MadLibs, 61–69

database, integrating with, 207–209 data input form, 61–63

dynamic form elements and, 202–207 dynamic page formatting, 209–213 home page, 61–63

MadLibHome.asp, 203–204 MadLibHome_Rev.asp, 209–211 MadLibProcess.asp, 204–207 MadLibProcess_Rev.ASP, 211–213 ODBC connection, establishing, 208 processing page, 63–67

saving, 66–69 TextStream object in, 57

MagicNumber variable, 158 manual updating, 25

306

Index

IsNumeric() function, 170						marquees in FrontPage 2000, 231–233
illustration of, 172–173						MatchData table, 116–117, 121, 123–124
ISPs (Internet service providers)						WinCheck connection, 140
development of ASP-enabled Web pages						mathematical functions, 168–169
with, 4						MathFunctions.asp, 169
FrontPage 2000 with, 259						MAX function, 284
J						Memory Game, 110–111
						database, 116–120
JavaScript, 2						design overview, 115–116
client-side processing and, 28						hidden form fields, 141
comparing ASP to, 3						Memory_Home.asp page, 126–127
DHTML effects with, 257						Memory Process.asp, 127–141
Form Validation message box using, 237							generating game board, 136–138
L							playing game, 136–138
							random number generation, 138–141
LastName variable, 114							setting up game, code for, 134–136
Layout section, Table Properties dialog							Y
						ODBC connectivity, establishing, 117–119
box, FrontPage 2000, 227–230						L
						permissions, establishing, 119–120
Left() function, 274					Fprogramming for, 120–126
LIKE operator, 282–283						random number generation, 120–126
Line property, 57						Memory Properties dialog box, 119–120
LinkName variable, 198–199				M
			A			merging cells in tables, 229–230
logarithm function, 168						methods of File object, 54
		E
Log() function, 168						Microsoft. See also FrontPage 2000
						Access Driver, 86–87, 147
logical operators, 280–283
Long variables, 269	T					Microsoft SQL Server Administrator’s
loops, 37–38							Guide, 89
efficiency with, 153						Microsoft Access Setup dialog box, 88
lowercase characters, converting, 273						Mid() function, 274
M						MIN function, 284
						Minute() function, 173, 276

Monotype Corsiva font, 148–149

Month() function, 173, 276

Move File object method, 54

N

names

File object returning, 53

for MadLibs game files, 68–69

Navigation view, FrontPage 2000, 221 nested.asp, 37

Netscape Communicator, 3 Netscape Navigator, 219

DHTML with, 257

JavaScript Web pages with, 28 tables in, 230

New dialog box, FrontPage 2000, 216–217 NewFortune variable, 159

Team-Fly®

New Page dialog box, FrontPage 2000, 250 Next statement, 38–39

NOT, use with operators, 283 Notepad, 18, 244

Now() function, 173, 276

O

objects. See also ADO component; specific types

closing, 56 collections, 47–52 variables, 269

ODBC Data Source Administrator dialog box, 86–87

ODBC Microsoft Access Setup dialog box, 147

ODBC (Open Database Connectivity), 84 for Fortune.mdb database, 146–147 MadLibs, integrating database

with, 208

for Memory Game, 117–119

OLE-DB (Object Linking and Embedding Database), 84

on-line help, use of, 18 OpenAsTextStream, 56 File object method, 54

OpenTextFile, 56

P

Page Counter component defined, 73

example of, 80 methods of, 81 working with, 81

PageHit method, Page Counter component, 81

Page view, FrontPage 2000, 220 Palm Pilot, 264

ParentFolder, 53 path

File object returning, 53 MadLibs game files, saving, 69

permissions

INSERT statement, setting for, 98–99 Memory Game permissions, 119–120

Personal Web Manager control panel, 8–9 features of, 12–13

Personal Web Server (PWS), 262 confirming installation, 12–13 default home page, displaying, 18 FrontPage Web in, 216

hanging after installation, 11 installing, 10–12

as staging platform, 13 Tour option, 13

Pictures toolbar, FrontPage 2000, 225–226 Player form, 141

plug-ins, 258 POST method, 52

PrevFortune variable, 157 primary key fields, 288 privacy. See security properties

of File object, 53–54

of TextStream object, 57

Publishing Wizard, 13

Q

QueryString.asp, 200–201 QueryString collection, 48

Request object QueryString collection, 51–52

URLs (Uniform Resource Locators) and, 52

QueryStrings

assigning values to, 199

dynamic QueryStrings, creating, 197, 199–201

for sensitive information, 201

R

Radio Button Validation dialog box, FrontPage 2000, 239

RANDOMIZE function, 157–158 random number generation, 120–126,

138–141

ReadA11() method for TextStream object, 57, 60

Read (a number) method for TextStream object, 57, 60

reading from text files, 59–60 Readline method, 57, 60 recordsets

object, 85

returned recordset, 91 working with, 103–105

307

I n d e x

308

Index

REPLACE function, 275 replacing strings, 270–272, 275

Reports view, FrontPage 2000, 220 Request object, 44–47

collections, 47–48 form collection, 47–51

forms, working with, 113–115 MadLibs game, saving, 68 QueryString collection, 51–52

Request.QueryString method, 201

Reset method, Page Counter component, 81

Response object, 44–47 returned recordset, 91 Right() function, 274 RndCheck variable, 124

S

Save As dialog box, FrontPage 2000,

218–219, 234

Save Embedded Files dialog box, FrontPage 2000, 234

saving. See also FrontPage 2000 MadLibs game, 66–69

Saving Results of Form dialog box, FrontPage 2000, 256

scripting editors, 89

search forms in FrontPage 2000, 231 searching and replacing strings,

270–272

Second() function, 173, 276 security

on ASP+, 265 cautions about, 120 need for, 265

QueryStrings and, 201

of server-side processing, 30 server-side processing and, 3

Select Database dialog box, 87–88 SELECT statement, 91–97

in Fortune Teller game, 157 in Memory Game, 138

for random number generation, 123 working with, 278

servers. See IIS (Internet Information Server); Personal Web Server (PWS)

server-side processing, 2 advantages of, 2–3

client-side processing vs., 27–29

reasons for using, 28 security of, 30

ServerVariables collection, 48 ShortName, File object returning, 53 ShortPath, File object returning, 53 sine function, 168

Sin() function, 168 Single variables, 269

Size, File object returning, 53

Skip (a number) method for TextStream object, 57, 60

SkipLine method for TextStream object,

57, 60

SomeNumber value, 150 speed of performance, 3

splitting/merging cells in tables, 229–230 SQL (Structured Query Language), 85.

See also DELETE statement; INSERT statement; SELECT statement; UPDATE statement

Access tables with, 297–299 AVG function, 284 BETWEEN operator, 281 COUNT function, 283

data-sorting functions, 283–284 IN operator, 281

introduction to, 88–92

IS NULL operator, 280–281 LIKE operator, 282–283 logical operators, 280–283 MAX function, 284

MIN function, 284 returned recordset, 91 SUM function, 283–284

Sqr() function, 168 square root function, 168

strings, 269–275. See also QueryStrings comparing string values, 272–274 concatenating, 269–270

extracting strings, 274 replacing strings, 270–272, 275 searching for, 270–272

string variables, 31, 269 SUM function, 283–284

T

TableCount variable, 138

Table Properties dialog box, FrontPage 2000, 227–230

tables. See also Access tables; FrontPage 2000

arrays as, 164 captions, adding, 229

cell properties, formatting, 228–229 graphics, adding, 230–231

HTML code for, 190–192 MatchData table, 121, 123–124 splitting/merging cells in, 229–230

<table> tag, 192 Tan() function, 168

tangent function, 168 TargetFrame property, 77 Tasks view, FrontPage 2000, 221 Tear() function, 276 TestPage.asp, 15

Text Box Properties dialog box, FrontPage 2000, 235

Text Box Validation dialog box, FrontPage 2000, 235–236

text files

with Ad Rotator component, 77–78 with Content Linking component, 74–76 with Content Rotator component, 79–80 MadLibs game, saving, 66–69

reading from, 59–60 writing to, 57–59

TextFormat variable, 60 TextStream object, 56–60

properties of, 57

reading from text files, 59–60 writing to text files, 57–59

tick marks for comments, 39–40 Time function, 173

in VBScript, 173–174, 275–276 tools, selecting, 263

Tour option, 13

trigonometric functions, 168–169 troubleshooting PWS installation, 11 Type, File object returning, 53

U

UNBOUND() function, 165 UPDATE statement, 99–102, 124

working with, 279–280

uppercase characters, converting, 273 URLs (Uniform Resource Locators), 15–16

with Ad Rotator component, 78

with Content Linking component, 73–74

QueryString collection and, 52

User Data Sources list, 147 UserName variable, 31–32 UserText value, 151

V

Value variable in arrays, 164 variables. See VBScript VBScript, 3–4

in client-side processing, 28 commenting on code, 39–40 constants, declaring, 31–32 convert functions, 167–168 currency subtype, 31

date subtype, 31 essential of, 268

For...Next statement, 37–39 functions, 167–174 If...Then statements, 33–37 integer subtype, 31

integrating with ASP, 24–27 Is functions, 169–173

mathematical functions, 168–169 programming ASP pages with, 263 simple program example, 32–33 string variables, 31

time and date functions, 173–174 variables

subtypes, 269 understanding, 29–31

verification of form data, 116 Visual Basic, 3

W

War Game, 174–188 ASPWar_Home.asp, 179–180 ASPWar_Play.asp, 179–188 hidden form fields in, 180 rules of, 175–178

War.mdb.database, 179 Web Site button, 13 Weekday() function, 276 weight for image display, 78 WHERE clause, 94–96

with DELETE statement, 103

WinCheck connection, 140

Windows 2000, configuring IIS for, 4–5

Windows Components Wizard dialog box, 6

309

I n d e x

310

Index

Windows NT, IIS support for, 5	writing to text files, 57–59
wizards, use of, 18	wwwroot folder, 15
Write (a string) method for TextStream	X
object, 57, 60
WriteBlankLines (a number) method for	XML (eXtensible Markup Language),
TextStream object, 57, 60	265
WriteLine (a string) method for	Z
TextStream object, 57, 60
WriteLine method, 56	zero-based arrays, 164–165

This page intentionally left blank

License Agreement/Notice of Limited Warranty

By opening the sealed disc container in this book, you agree to the following terms and conditions. If, upon reading the following license agreement and notice of limited warranty, you cannot agree to the terms and conditions set forth, return the unused book with unopened disc to the place where you purchased it for a refund.

License:

The enclosed software is copyrighted by the copyright holder(s) indicated on the software disc. You are licensed to copy the software onto a single computer for use by a single user and to a backup disc. You may not reproduce, make copies, or distribute copies or rent or lease the software in whole or in part, except with written permission of the copyright holder(s). You may transfer the enclosed disc only together with this license, and only if you destroy all other copies of the software and the transferee agrees to the terms of the license. You may not decompile, reverse assemble, or reverse engineer the software.

Notice of Limited Warranty:

The enclosed disc is warranted by Premier Press, Inc. to be free of physical defects in materials and workmanship for a period of sixty (60) days from end user’s purchase of the book/disc combination. During the sixty-day term of the limited warranty, Premier Press will provide a replacement disc upon the return of a defective disc.

Limited Liability:

THE SOLE REMEDY FOR BREACH OF THIS LIMITED WARRANTY SHALL CONSIST ENTIRELY OF REPLACEMENT OF THE DEFECTIVE DISC. IN NO EVENT SHALL PREMIER OR THE AUTHORS BE LIABLE FOR ANY OTHER DAMAGES, INCLUDING LOSS OR CORRUPTION OF DATA, CHANGES IN THE FUNCTIONAL CHARACTERISTICS OF THE HARDWARE OR OPERATING SYSTEM, DELETERIOUS INTERACTION WITH OTHER SOFTWARE, OR ANY OTHER SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES THAT MAY ARISE, EVEN IF PREMIER AND/OR THE AUTHORS HAVE PREVIOUSLY BEEN NOTIFIED THAT THE POSSIBILITY OF SUCH DAMAGES EXISTS.

Disclaimer of Warranties:

PREMIER AND THE AUTHORS SPECIFICALLY DISCLAIM ANY AND ALL OTHER WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING WARRANTIES OF MERCHANTABILITY, SUITABILITY TO A PARTICULAR TASK OR PURPOSE, OR FREEDOM FROM ERRORS. SOME STATES DO NOT ALLOW FOR EXCLUSION OF IMPLIED WARRANTIES OR LIMITATION OF INCIDENTAL OR CONSEQUENTIAL DAMAGES, SO THESE LIMITATIONS MIGHT NOT APPLY TO YOU.

Other:

This Agreement is governed by the laws of the State of Indiana without regard to choice of law principles. The United Convention of Contracts for the International Sale of Goods is specifically disclaimed. This Agreement constitutes the entire agreement between you and Premier Press regarding use of the software.