Index_O

O

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