|
|
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
|
|