Index

D

daily message display application, 617–624

dash (—) decrement operator, 37

dash, greater than sign (—>) DTD comment suffix, 595, 602

data, 19

data source name. See DSN

data type

AutoNumber, 729, 733

Boolean, 22

converting, 45–48, 69

Currency, 723

database field, 722–723, 725–727, 734

Date, 723

described, 19

JavaScript as weakly typed, 20

Memo, 723

mixing types, 43–44

numerical, 20, 43–48, 723

primitive, 106, 108, 109, 110–111, 112

text, 20–22, 43–45, 723

Time, 723

Yes/No, 723

database. See also ADO (ActiveX Data Objects); SQL (Structured Query Language)

adding data, 734, 744, 761–769

authorization to access, 753, 764

beginning of file, finding, 755

connection

closing, 753, 759

creating, 752–753, 758

opening, 752–753, 758, 883

string, 747, 752

creating, 724–727

cursor type, 760

data source setup, 747–751, 873, 880

deleting

record, 745, 761

relationship, 738

DSN, 752, 880

EOF, finding, 754–755, 874

field

autonumbering, 729, 733, 768

creating, 723

data type, 722–723, 725–727, 734

described, 722

Indexed property, 733

key, defining as primary, 733, 736

naming, 722, 725

query, specifying for, 739, 754

record, relation to, 723

size, specifying, 726–727

table, splitting into, 728

IIS security, error message caused by, 761

index, 733

integrity of data, 736, 737

key, primary, 733, 736

logon data, storing in, 796, 870–875

message board application, 796, 876–883

normalization, 731

password data, storing in, 796, 870– 875

query

Boolean operator, using, 742

criteria, on multiple, 742

criterion, limiting record return by, 741–742

field, specifying, 739, 754

recordset, returning, 747, 753–754, 758

result, displaying, 741, 755–759

result, loading to HTML table, 755–759

result, rounding numerical, 757–758

result, sorting, 742–743

running, 741, 758

SQL select statement, using, 739–743

table, specifying, 739

record

closing recordset, 759

deleting, 745, 761

described, 722

field, relation to, 723

forward only cursor type recordset, 760

inserting, 734, 744, 761–769

navigating recordset, 754, 759, 760

number in recordset, returning highest, 769

opening recordset using Connection object, 753–754, 758

opening recordset using Recordset object, 759–760

query, limiting by record criterion, 741–742

query, returning recordset from, 747, 753–754, 758

selecting, 739–743

table row, relation to, 734

updating, 743–744, 761

relational, 722

relationship

data integrity enforcement, role in, 736, 737

defining, 736–739

deleting, 738

displaying, 738

editing, 737

key, primary, 733

many-to-many, 736

one-to-many, 736

one-to-one, 736

replication, avoiding unnecessary, 728

security, 753, 761, 764–766

table

adding data to, 734, 744, 761–769

creating, 725

date, inserting, 767

described, 722

field, splitting into, 728

query, specifying in, 739

relationship, defining, 736–739

row focus, changing, 754

row, inserting, 731–733

row, record relation to, 734

text file data storage versus, 721

Trivia Quiz application

Answer field, 770

AskQuestion.htm file, coding for database functionality, 782–787

key, primary, 775

NoteUserSelections.asp file, coding for database functionality, 777–778, 781

OptionOrder field, 772

query coding, 785, 789

Question table, 770–772, 774, 776

Questionhtml field, 770

QuestionId field, 770, 772, 775–776, 778

QuestionOptions table, 770, 771–772, 775–776, 777

QuestionType field, 770, 789

referential integrity, 776

table relationship, 775–776

updating, 743–744, 761

web page, accessing from

connection, closing, 753, 759

connection, creating, 752–753, 758

connection, opening, 752–753, 758, 883

connection string, 747, 752

location of database, 746

ODBC data source, 747–751

web server, located on, 746

Date data type, 723

Date object

constructor property, 903

creating, 108, 136–137

declaring, 136

getDate method, 137, 903

getDay method, 137, 832, 903

getFullYear method, 137, 139, 903

getHours method, 107, 141, 903

getMilliseconds method, 143, 903

getMinutes method, 107, 141, 144, 903

getMonth method, 137, 139, 226, 803–804, 903

getSeconds method, 143, 903

getTime method, 107, 903

getTimezoneOffset method, 334, 337, 346, 903

getUTCDate method, 340, 904

getUTCDay method, 340–341, 904

getUTCFullYear method, 340, 904

getUTCHours method, 340, 904

getUTCMilliseconds method, 340, 904

getUTCMinutes method, 340, 904

getUTCMonth method, 340, 904

getUTCSeconds method, 340, 904

getVarDate method, 904

getYear method, 139, 904

initializing, 137, 139, 143

parse method, 904

prototype property, 903

setDate method, 140, 141, 904

setFullYear method, 140, 904

setHours method, 144, 904

setMilliseconds method, 144, 904

setMinutes method, 144, 904

setMonth method, 140, 141, 225, 904

setSeconds method, 144, 904

setTime method, 905

setUTCDate method, 339, 905

setUTCFullYear method, 339, 905

setUTCHours method, 339, 905

setUTCMilliseconds method, 339, 905

setUTCMinutes method, 339, 905

setUTCMonth method, 339, 905

setUTCSeconds method, 339, 905

setYear method, 905

toDateString method, 137, 334, 336

toGMTString method, 905

toLocaleDateString method, 334, 336

toLocaleString method, 334, 905

toLocaleTimeString method, 334, 336, 338

toSource method, 905

toString method, 905

toTimeString method, 143, 334, 336, 338

toUTCString method, 334, 337, 905

UTC method, 905

valueOf method, 227, 905

date operation. See also time operation

birth date form, 364, 831–832

calculation involving date value, 107, 141, 221–228

expiration date, 425, 429, 431, 838

web page visit date, storing in, 838

current date, returning, 138–140, 145

database table, inserting date into, 767

day, returning, 137, 139, 340–341, 832, 904

drop-down date list, creating, 224–225

format considerations, 136–137

hour, returning, 142

millisecond

returning, 142, 227

UTC millisecond, getting/setting, 339, 340, 905

minute, returning, 142, 144

modification date, returning, 436, 930

month, returning, 137, 139, 156, 225–226, 803–804

second

returning, 142

UTC second, getting/setting, 339, 340, 905

setting date value, 140, 141, 339–341, 904, 905

storage format, 136

time zone, returning date based on, 137

validation, 868

year

returning, 137, 139

UTC year, getting/setting, 339, 340, 905

DatePosted field, 880

daylightSavingsAdjust variable, 346

dayNow variable, 139

days variable, 220

db1.mdb file, 724

debug_bottomFrame.htm file, 390

debug_callstack.htm file, 387

debug_frameset.htm file, 389, 390

debugger keyword, 378–379

debugging

BOM property, accessing, 386

breakpoint, using, 383–384, 394–395

browser, tracking instance/page load, 389–391

condition, evaluating, 385–386, 399

function call stack, displaying, 386–389, 394–395

logic error, 367, 369, 833, 835

loop structure, 380–382, 386

stepping through code, 378, 379–383

syntax error, 367–368, 369–370, 404, 836

variable value, checking, 385, 394

debug_timestable.htm file, 375, 377, 378, 380

debug_timestable2.htm file, 380, 383, 392, 412, 833

debug_topFrame.htm file, 389, 390

decimalPlaces variable, 806

decodeURI function, 899

DecodeURIcomponent function, 899

decrement operator, 37–38, 86

default statement, 80, 81, 83

Default Web Site Properties dialog box (IIS), 661

defaultChecked property

Checkbox object, 929

Radio object, 940

defaultSelected property (Option object), 938

defaultStatus property (window object), 160–161, 946

defaultValue property

Password object, 939

Text object, 944

Textarea object, 945

degCent variable, 69–70, 798

degFahren variable, 69–70, 71

delete operator, 891

delete SQL statement, 745

description

property

Exception object, 402, 403

Plugin object, 630

variable, 754

DescriptionDiv style class, 843

detailsWindow variable, 261

DevEdge website, 158, 630

DHTML (Dynamic HTML). See also HTML (Hypertext Markup Language)

adding content in IE environment, 468–470

appearance coding in IE environment, 454–457

BOM dependence, 445

browser

DOM, cross-browser programming using, 557–558

menu cross-browser programming, 567–571, 575–580

mouse rollover effect cross-browser programming, 565–567

page change, cross-browser programming involving small, 514–519

redirecting browser using, 518–519

support, 445–446

text addition/deletion cross-browser programming, 561–565

text animation cross-browser programming, 558–560

button coding, 466–468, 471

changing content in IE environment, 460–468

color, formatting, 455–457, 490, 497–498, 515, 565–567

error handling, 467

event handling

argument, passing explicitly, 568–569

button-related, 471

function, passing event object to, 498–499, 507, 568–569, 577

IE environment, 470–472, 473, 474–475, 477, 481

layer-related, 494, 496–497, 502

NN environment, 498–501, 503–504, 505, 506

form, referencing, 454–455

HTML versus, 446–447

id attribute, referencing element by, 455, 535, 568

image effect

cross-browser environment, in, 520, 844–850

IE environment, in, 473–476, 479–480, 486

NN environment, in, 501, 502, 503, 505–507, 512

innerhtml property, getting/setting, 462–468, 569–570

innerText property, getting/setting, 461–462

inserting content, 468–470

introduced, 445

layer

content, changing, 495–496

creating, 489–490

div tag coding, 490, 492–495, 496, 497–498

event handling, 494, 496–497, 502

implicit, 490

inline, 490

menu, creating using, 501–508, 512–514

moving, 490–495

NN environment, in, 489–498

positioning, 490–495

referencing, 490

z-index, 491–494

array, populating from, 486–487, 501, 503, 506, 510

border, 505

cross-browser programming, 567–571, 575–580

div tag coding, 473–475, 476, 487–488, 570–571

event handling in IE environment, 473, 474–475, 477, 481

event handling in NN environment, 503–504, 505, 506

function, creating using, 486–488, 513–514, 576–577

hiding, 476, 480, 505–507, 577

hyperlink, 476, 481, 502–503

image effect in cross-browser environment, 520, 844–850

image effect in IE environment, 473–476, 479–480, 486

image effect in NN environment, 501, 502, 503, 505–507, 512

layer, creating using, 501–508, 512–514

mouse rollover effect, 473–475, 480–481, 503–505, 507–508

showing, 475–476, 479, 505–507, 577

style sheet, applying to, 478–479, 480–481

table coding, 477–479, 481, 487–488, 570–571

mouse rollover effect

color change, 456–457

cross-browser programming, 565–567

menu, in, 473–475, 480–481, 503–505, 507–508

style change, 480–481

text change, 456–457, 565–567

moving content, 458–460, 515–517

object model, 454

outerhtml property, getting/setting, 462–468

page tag, referencing in IE environment, 454–455

paragraph

color, changing, 456–457, 497–498

positioning, 459–460, 494–495

referencing, 455, 462

style sheet, applying to, 447, 448, 449

positioning content in IE environment, 458–460

radio button, 466–468

style object coding in IE environment, 454–457

style sheet

introduced, 446

menu, applying to, 478–479, 480–481

table

aligning, 581, 853

border, 581, 853

menu, table coding for, 477–479, 481, 487–488, 570–571

text

adding, 561–565

animating, 558–561

color effect, 456–457, 565–567

deleting, 561–565

mouse rollover effect, 456–457, 565–567

moving, 458–460

referencing Text object, 455

sizing, 455

spacing, 455

timer, 458–460

XML, using with, 617–624

diceThrow variable, 126

dimensions method (VBArray object), 921

directive, server, 668

directory, virtual, 662–665, 715

Display property (CSS), 604

displayedImages cookie, 841

DisplayEvent function, 207–208

displayPDAS function, 622

DisplayStock.asp file, 756, 763

div

HTML tag

DHTML layer coding, 490, 492–495, 496, 497–498

DHTML menu coding, 473–475, 476, 487–488, 570–571

element positioning, using for, 450, 451–454, 459

left attribute, 451–453

onmouseout event handler, 474–475, 476, 502

style container, as, 450

top attribute, 451–453

object

moving, 847, 848–849

referencing, 476

style property, 517, 848

variable, 128

divhtml variable, 487

division (arithmetic), 36, 887, 889

DivMenu style class, 478

DivStyle1 style class, 452

do while statement, 90–91, 894, 895

DOCTYPE declaration, 597

document object

alinkColor property, 930

all property, 163, 174, 175, 514–515, 518–519

anchors property, 930

applets property, 930

bgColor property, 7, 8, 930

browser

IE/NN difference, 163

support, checking, 174, 175

version, returning using, 174–175

close method, 498, 931

cookie property, 415, 429, 930

createAttribute method, 547

createElement method, 547, 549

createTextNode method, 547, 549

documentElement property, 539, 545

DOM document object, 534–538, 614

domain property, 930

embeds property, 930

fgColor property, 930

Form_name property, 930

forms property, 188–190, 930

getElementById method, 174, 517, 535, 543, 568

getElementsByTagName method, 535, 538, 618

images property, 163, 166–167, 172–173, 930

lastModified property, 436, 930

layers property, 175, 490, 506, 515, 517

linkColor property, 930

links property, 163, 167, 930

load method, 614

location property, 930

NN support, 163, 175

onclick event, 929

onclick property, 171

ondblclick event, 929

onkeydown event, 929

onkeypress event, 929

onkeyup event, 929

onmouseout event, 477, 480

onmouseover event, 477, 480–481

onmouseup event, 929

onreadystatechange event, 638

open method, 931

plugins property, 930

referrer property, 930

securityPolicy property, 175

title property, 930

URL property, 930

vlinkColor property, 930

window, returning reference to document object in current, 160, 946

write method

array, using with, 53, 57–58, 486, 503

described, 931

DOM, using with, 580–581, 850–852

Layer object, writing to using, 495

multiplication table result, writing using, 103, 800–803

replacing text using, 262

writeln method, 931

Document Object Model. See DOM

document property (window object), 160, 946

Document Type Definition. See DTD

documentElement property (document object), 539, 545

DocumentFragment object, 534

document_onmouseout function, 480, 481, 579–580

document_onmouseover function, 480–481, 579, 580

DocumentType object, 534

DOM (Document Object Model)

attribute

creating, 550–551

value, replacing, 550

value, returning, 550, 552

value, setting, 550, 552

BOM

DOM versus, 521–522, 529

overlap with DOM, 538–539

browser

independence, 521–522

support, 522, 529

comment, 534

cross-browser programming using, 557–558

element

creating, 547–549

node of, returning, 541

referencing, 534–538, 539, 543, 568

value, setting, 541

event model, 552–557

introduced, 521

language support, 527–528

method, 534–539, 617

node

appending, 547

child, 530, 541, 545, 546

creating, 547

introduced, 530

leaf, 531

objects related to, 533

parent, 530, 541

removing, 547

replacing, 547

returning, 541

root, 530

sibling, 541, 545, 546

text node, 547, 549, 569–570

object overview, 533–534

platform independence, 521–522

property overview, 539–544

standard, 528–529

style object coverage by, 538–539

tree structure, 522, 529–532, 543–546

write method, using with, 580–581, 850–852

domain property (document object), 930

DoPlay method (RealPlayer), 628, 643, 858

download detector application, 616

Dreamweaver MX, 5

drop-down list, 192, 216, 224–225

DSN (data source name), 752, 880

DTD (Document Type Definition). See also XML (Extensible Markup Language)

creating, 595–596

document prologue, as, 584

external, 584, 597

introduced, 526

markup declaration, 595

referencing, 596–597

sharing between documents, 584

XHTML DTD declaration, 527

XML validity, role in, 584, 594–595

Dynamic HTML. See DHTML