Index_A

A

Abs() function (Access), 204

ABS() function (MySQL), 148

ABS() function (Oracle), 125

Abs() function (SQL Server), 165

access permission problems, as database connection error message, 244

Access projects for SQL Server Desktop, 187-190

datatypes, 188-189

properties, 187-188

accessibility, 55-57

ACTION attribute, for HTML forms, 512

Action page, <form> tag without, 326

actions in JSP, 9

active events in ASP.NET, 330-332

Active Server Pages (ASP), 7

Command Server Behavior for, 489-491

comment tags, 46

connections, to Oracle database, 135

global.asa file, 316

Master/Detail Page Sets with, 545-558

additional details, 560-564

Detail.asp, 557-558, 558, 559

Master.asp, 549-557, 558, 559

Recordset code, 546-547

objects, 297-317

Application object, 314-315

ASPError object, 317

ObjectContext object, 317

Request object, 303-311

Response object, 297-303

Server object, 311-314

Session object, 315-316

Option Explicit, 59

requirements to run, 296

Server Behaviors for dynamic data display, 500

ActiveX controls, Office Web Components (OWC) as, 190

ActiveX Data Objects (ADO), migrating DAO to, 183

Add Browser dialog box, 22

add-ins. See Dreamweaver MX extensions

ADD_MONTHS() function (Oracle), 128

ADO. See ActiveX Data Objects (ADO)

ADO.NET, 184

data binding in Web Forms, 359-382

data-binding expressions, 359-360

through control's data source, 361-362

web server controls, 363-382

object model, 348-358

datasets, 348-353, 349

MM:DataSet Custom tag, 353-358

SQLConnection and OLE DB Managed Providers, 348

what it is, 347-358

namespaces, 348

ADP files, 187

AdRotator web server control, 328

aggregate functions, 163, 665-666

in Access, 206

in Microsoft SQL Server, 179-182

SQL, 215-216

alias, 124

align attribute, as editable attribute, 634-635

ALL_HTTP server variable, for ASP Request object, 308

allow_call_time_pass_reference option in php.ini file, 389

ALT tag, 55

AlternatingItemTemplate, 363-364, 367

with HTML and ASP.NET code, 373

American National Standards Institute (ANSI), 431

Analysis Services in SQL Server 2000, 159

anchor date, for SQL Server, 163

AND operator, in SQL WHERE clause, 440

anomaly, 89

ANSI (American National Standards Institute), 431

antivirus software, 409, 411-412

Apache, 27

Apache Tomcat, 271

Apache Web Server, and PHP, 386

Apple, patches for OS X, 410, 411

Application object (ASP), 314-315

Application panel

Binding tab, 38, 38

Databases tab, 29, 29

Server Behaviors tab, 38

Recordset (Query), 605

User Authentication, Log In User, 416, 417

User Authentication, Log Out User, 419

User Authentication, Restrict Access To Page, 418

application server, 9

application variables

ColdFusion settings for, 253

Live Data view to initialize, 479-480, 480

application.cfm file, 254

Application_OnEnd, 316, 342

Application_OnStart, 316, 342

AS clause, for SQL SELECT statement, 434, 434

Asc() function (Access), 195

ASC keyword (SQL), 437, 438

ASP (Active Server Pages). See Active Server Pages (ASP)

ASP developers, connections for, 231-234

DSN-less connection, 234

OLE DB connection, 233-234

System DSN connection, 231-232

.asp file extension, 73, 296

ASPError object (ASP), 313, 317

ASP.NET, 7

.NET framework, 320-321

active and passive events, 330-332

connections, 234-238

Managed Data Provider for SQL Server, 237-238

OLE DB connection, 234-237

to Oracle database, 135

global.asax file, 342-343

as host, 321

objects, 337-343

Page object (ASP.NET), 340-341

Request object (ASP.NET), 340

Response object (ASP.NET), 337-339

overview, 319-320

Server Behaviors for dynamic data display, 500

server controls, 327-330

specifying validation, 332-336

Stored Procedure Server Behavior for, 491-494

VB.NET or C#, 321

Web Forms, 322-326

Code Declaration Block, 324-325

Code Render Block, 325

Page directive, 323-324

XML web services, 344-345

asp_tags option in php.ini file, 389

.aspx file extension, 320

@ Assembly directive (ASP.NET), 324

Assets window, 619, 620

asterisk (*), in SELECT statements, and performance, 135, 432

asynchronous processing, 213

AUTH_PASS server variable, for ASP Request object, 308

AUTH_TYPE server variable, for ASP Request object, 308

autoFlush attribute, of JSP page directive, 277

AutoIncrement command, 351

AutoNumber datatype (Access), 193

autoupdate links, 43, 44

Average Distribute Extension, 660-661, 661

Avg function (SQL), 216, 467

AVG() function (MySQL), 147

AVG() function (Oracle), 123-124

AVG() function (T-SQL), 179-180