Index_D

D

data, 603

dynamic, benefits, 3-5

data access. See also ADO.NET

Data Access objects (DAO), migrating to ADO, 183

Data Access Pages (DAP), and Access, 190

data binding in ADO.NET Web Forms, 359-382

data-binding expressions, 359-360

through control's data source, 361-362

web server controls, 363-382

building on Dreamweaver code, 372-379

DataGrid web server control, 379-382

DataList web server control, 368-371

Repeater web server control, 363-368

data columns, naming conventions for, 53

data connection. See connections

Data connection layer, 6

data display, Server Behaviors for

Dynamic Table Server Behavior, 506, 507

Dynamic Text Server Behavior, 501-503

Recordset Navigation Bar Server Behavior, 507-508, 508

Recordset Navigation Status Server Behavior, 509, 509

Repeat Region Server Behavior, 504-505, 505

data-driven site, 6

Data Link Properties dialog box

Connection tab, 236

Provider tab, 235

Data Manipulation Language, 432

data source

of control, data binding through, 361-362

Jet SQL as, 210, 210-211

Data Source Name (DSN), 75, 226

Data Source Name (DSN) dialog box, 231, 231, 232

Data source name not found, as error message, 246

data storage media, wiping or destroying old, 408

data tables, naming conventions for, 52-53

Data Transformation Services Import/Export Wizard (SQL Server), 160

Data type mismatch in criteria expression error message, 246

database administrator (DBA), 119

database design, 89

foreign key, 95

defining, 110-114

normalization, 90-92

primary key, 92-93

natural or surrogate, 94

process, 95-114

applying normal forms, 97-104

datatypes definition, 104-105

knowledge of data, 96-97

relationships, 105-109

redundant data and relational database theory, 89-90

referential integrity, 114-116

cascading options, 116-117

database files, properties, web service access, 244, 244

Database layer, 6

Database object, Execute method of, 212

database servers, 28

databases, 9-10

changes with UPDATE statement, 448-450, 449

connection setup, 36-38, 37

DELETE statement to remove records, 450-451

folders for, 414-415

location for development environment, 27-28

protection for, 414-415

SQL interaction with, 430

term defined, 91

Databases panel, 585

opening, 233

DataBind() command, of Page object, 359

DataGrid dialog box, 380

DataGrid Server Behavior, 510

DataGrid web server control, 329, 379-382, 382

in master page, 585-586, 590

DataList dialog box, 368-369, 369

inserting template code, 370

DataList Server Behavior, 510

DataList web server control, 329, 368-371

code for, 371

event-driven procedures, 378-379

script page, 374-377, 377

DataRelations object, 349

DataSet dialog box, 357, 357

DataSets, 347, 348-353, 349

creating from data source, 352-353

creating in memory, 350-352

MM:DataSet Custom tag to create, 356-357

scripting-server controls to dynamically update, 374

DataSource property, of server controls, 359

datatypes, 670-672

choosing correct, 193

definition, 104-105

Jet, 188-189, 191-193

in Microsoft SQL Server, 161-162

in MySQL, 141-146

character, 144-145

date/time, 146

numeric, 142-144

in Oracle, 121-123

DATE datatype (Oracle), 123

DATE datatype (MySQL), 146

Date() function (Access), 200

date/time datatypes

in Access, 192

in MySQL, 146

in Oracle, 123

date/time functions, 668-669

in Access, 200-203

in Microsoft SQL Server, 163-164

in MySQL, 151-153

in Oracle, 127-129

DateAdd() function (Access), 200

DateAdd() function (SQL Server), 164

DateDiff() function (Access), 201

DateDiff() function (SQL Server), 164

DatePart() function (Access), 201

DatePart() function (SQL Server), 164

dates, Access vs. SQL Server support, 218-219

DateSerial() function (Access), 201

DATETIME datatype (MySQL), 146

DateTime datatype (SQL Server), 161

DateTime Null datatype (SQL Server), 161

DateValue() function (Access), 201

DAvg() function (Access), 206

Day() function (Access), 201

Day() function (SQL Server), 164

DAYNAME() function (MySQL), 152

DAYOFWEEK() function (MySQL), 152

DAYOFYEAR() function (MySQL), 152

dBASE, and database location, 28

DB_ID() function (SQL Server), 166

DB_NAME() function (SQL Server), 166

DCount() function (Access), 204

Ddb() function (Access), 207

Debug property, of MM:DataSet Custom tag, 354

debugger in ColdFusion, 256-259

enabling, 256

execution time, 259

output format, 256

variables, 259

debugging Active Server Pages (ASP), 300-301

Debug.Print statement, 214

DECIMAL datatype (MySQL), 143-144

Decimal datatype (SQL Server), 161

Decimal datatype (Access), 192

Decimal Null datatype (SQL Server), 161

declarations in JavaServer Pages, 275-276

DECODE() function (Oracle), 130-131

default home page, designating for Site Manager, 41

Default Images folder, 31

DefaultView property, of MM:DataSet Custom tag, 355

Define Access Levels dialog box, 421

degaussing, 408

Delete Record dialog box, 540

Delete Record Server Behavior, 539

DELETE statement (SQL), 450-451

deleting

data connection, 243

records, HTML forms for, 539-542, 540

delimiters, 465-466

for dates, 467

Deploy Supporting Files to Testing Server dialog box, 356

DESC keyword (SQL), 437

Design panel, Behaviors tab, Validate Form, 63, 63

Design view of Dreamweaver, 471-472, 472

form objects in, 84, 84

designers, recommended Launcher settings, 20-21

details. See Master/Detail Page Sets

deterministic functions, in SQL Server, 163

development environment

ColdFusion as, 262-268

setup, 27-38

binding to data, 38

database connection, 36-38

database location, 27-28

site definition, 28-36

web server, 27

device drivers, for Oracle connection, 136

DHTML (Dynamic Hypertext Markup Language), 12

Data Access Pages (DAP) to save Access object as, 190

diagram of code operation, 60

dial-up modems, and download speed, 55

Difference() function (SQL Server), 169

directives, in JavaServer Pages (JSP), 9, 276-279

directories. See folders

disconnected dataset, 347

display monitor, Dreamweaver MX requirements, 13-14

display_errors option in php.ini file, 389-390

DISTINCT predicate (SQL), 435-436

DISTINCTROW keyword

in Access, 436

and upsizing, 219

DLookup() function (Access), 205

DMax() function (Access), 205

DMin() function (Access), 205

dockable output format for ColdFusion debugger, 256, 258

DoCmd object, RunSQL method of, 212

document types, in site definition, 29

documents

extension to close all, 663-664

as pages, 616

dollar sign ($), for PHP variable names, 391

domain, 204

domain functions, in Access, 204-206

Don' t Make Me Think (Krug and Black), 55

DOUBLE datatype (MySQL), 143

downloading

dial-up modems and speed of, 55

from Macromedia Exchange, 644

Server Behavior to track count, 648

drag and drop, to add dynamic data to script page, 503

Dreamweaver MX

basics, 7

configuration, 18-26

adding icons to panels and adding launcher, 18-21, 19

additional preference settings, 26

code appearance and readability, 26

code corrections by Dreamweaver, 25-26

error checking before saving, 23, 24

preview in browser, 21-23

history, 11-12

installing, 13-16

hardware and software requirements, 13-14

local web server, 14

options, 15

PC/server environment setup, 27-38

database location, 27-28. See also database

web server, 27

running for first time, 16-17

interface options, 16

refusal to start, 17

for security, 415-425

restricting access to page, 418-425

User Authentication page, 415-418, 416

trial version, xxii

Dreamweaver MX extensions, 643-649.

See also Macromedia Exchange

categories, 646

disabling, 649

examples, 656-664

Average Distribute Extension, 660-661, 661

CFML Form Tab, 661, 661-662

Check Form, 656, 656-657

Close All Documents, 663, 663-664

Context Help Toolbar, 658, 658-659

Cube Stores Designer, 657, 657-658

Drop Down Menu Builder for IE, 659-660, 660

Favorites Menu, 659, 659

Go To Line Number, 662, 662-663

No Right-Click, 664

Extension Manager, 644, 644-647, 645

installing extension, 647-648

removing, 645, 649

reviews, 656

searching Macromedia Exchange for, 652, 653

Dreamweaver MX Library, storing templates in, 368

DreamweaverCtrls.dll file, 356

drop-down lists in HTML forms, 80-81

Drop Down Menu Builder for IE extension, 659-660, 660

DropDownList web server control, 329

Drumbeat (Elemental), 12

DSN (Data Source Name), 75, 226

creating local, 75-79

creating system, 228

DSN-less connection, for ASP developers, 234

DStDev() function (Access), 205

DStDevP() function (Access), 205

DSum() function (Access), 204

duplicate records, 93

DVar() function (Access), 205

DVarP() function (Access), 205

.dwt file extension, 618

dynamic data, benefits of offering, 3-5

Dynamic Table dialog box, 402, 506, 523, 606, 607

Dynamic Table object, 522

to display search results, 606

Dynamic Table Server Behavior, 506, 507, 593-594, 598-599

Dynamic Text, 359-360

on template, 640-641

Dynamic Text dialog box, 501-502, 502, 641, 642

for Details.asp, 562

Dynamic Text Server Behavior, 501-503, 548