|
|
ObjectContext object (ASP), 317
OBJECT_ID() function (SQL Server), 167
OBJECT_NAME() function (SQL Server), 167
objects
in .NET framework, 320
in ASP
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
in ASP.NET, 337–343
Page object, 340–341
Request object, 340
Response object, 337–339
ODBC (Open Database Connectivity), 9, 226–228
and JDBC, 230
for Oracle connection, 135
ODBC-compliant database systems, and database location, 28
ODBC Data Source Administrator dialog box, 75
System DSN tab, 76, 227, 229
ODBC data source name, creating, 75
ODBC Microsoft Access Setup dialog box, 229
Office Web Components (OWC), and Access, 190–191
offsite storage of backups, 407–408
OLE DB (Object Linking and Embedding Database) connection, 9, 229–230
for ASP developers, 233–234
for ASP.NET developers, 234–237
for Oracle, 135
OLE DB Connection dialog box, 235
OLE DB Managed Provider for ADO.NET, 348
OLE Object datatype (Access), 192
one-to-many relationships, 106, 106
foreign key for, 110
one-to-one relationship, 105–106
Open method, of Connection object, 212, 213–215
open-source software
development process, 140
PHP as, 387
OpenDataSource() function (SQL Server), 168
OPENXML, 159
operating system
Access requirements, 186
Dreamweaver MX requirements, 13–14
patches and security fixes, 409–410
operators in SQL, 463–465
comparison, 463
logical, 464
mathematical, 463
<option> tag (HTML), 81
optional regions
inserting in template, 630–633
parameters to control, 632
on template, 617
OR operator, in SQL WHERE clause, 440
Oracle
connection options, 135–136
and database location, 28
datatypes, 121–123, 669–670
and Dreamweaver and SQL, 120–121
features, 119
functions, 123–131
aggregate functions, 665–666
conversion functions, 129–130, 669–670
date/time functions, 127–129, 668–669
favorite functions, 130–131
grouping functions, 123–125
numeric functions, 125–126, 666
string functions, 126–127, 667–668
further information, 136
product family, 120
SQL statement construction, 131–135
comments, 132–133
guidelines, 132
statement tuning, 135
syntax variations, 133–134
Oracle 9i, 10, 272
ORDER BY clause, SELECT statement (SQL), 439–440, 442–443
Orion Application Server, 272
orphaned files, 43
orphaned records, 115
outer joins
left, 108, 108–109
Oracle SQL statement for, 133–134
right, 109, 109, 110
outer select, 460
output_buffering option in php.ini file, 389
@ OutputCache directive (ASP.NET), 324
OWC (Office Web Components), and Access, 190–191
|
|