Index_C

C

C#

for ASP.NET, 321

global.asax file in, 343

validation, 335

Web forms example, 322-323

Calendar web server control, 328

Callable (Stored Procedure) Server Behavior, for JSP, 494-497

capitalization, Oracle function for, 126

cascading options, to maintain referential integrity, 116-117

case sensitivity

of file names, 54

of JSP tags, 273

in MySQL, 154

Oracle and SQL code, 132

of PHP, 390-391

CASE statement, 59-60

Caucho Technology Resin, 271

CBool() function (Access), 197

CByte() function (Access), 198

CCur() function (Access), 198

CD-ROM, contents, xxii

CDate() function (Access), 199

CDbl() function (Access), 198

Ceiling() function (SQL Server), 165

Cell Padding property, for repeating table, 630

Cell Spacing property, for repeating table, 630

centering graphics, 625

certificate for Secure Socket Layers (SSL), 309

fields for, 310

<cfabort> tag, 262

<cfapplication> tag, 267

dialog box to set, 268

<cfcookie> tag, 266

<cfelse> tag, 266

<cfelseif> tag, 266

<cfif> tag, 266

<cflock> tag, Dreamweaver button to add, 265

<cfloop> tag, 266

.cfm file extension, 259

CFML. See ColdFusion

CFML Form Tab extension, 661, 661-662

<cfoutput> tag, 261

<cfquery> tag, 261-262

Dreamweaver button to create, 263, 263

<cfset> tag, 261

CHAR datatype (Oracle), 121

CHAR datatype (MySQL), 144

Char datatype (SQL Server), 161

character codes, for HTML, 312

character datatypes

in MySQL, 144-145

in Oracle, 121

Check Box object, 84

Check Form extension, 656, 656-657

check-in/check-out option for files, 36, 39-40

Check New Username dialog box, 422, 423

Check New Username Server Behavior, 422

checkbox control as HTML input element, 72

CheckBox web server control, 328

CheckBoxList web server control, 328

Chili!Soft ASP, 296

Chr$() function (Access), 195

CInt() function (Access), 198-199

classic output format for ColdFusion debugger, 256, 257

clause in SQL, 431

Client Network Utility (SQL Server), 160

client/server environment, optimizing SQL Server

database application for, 183

client-side scripting, vs. server-side, 296

client-side validation of data, 62-65

client variables, for ColdFusion, 253

clientcertificate collection, of ASP Request object, 309-311

CLng() function (Access), 199

CLOB datatype (Oracle), 122

Close All Documents extension, 663, 663-664

CLR (Common Language Runtime), 320

clustered index, 114

Codd, E.F., 90

Code Declaration Block in ASP.NET Web Form, 324-325

Code Render Block in ASP.NET Web Form, 325

Code View window, extension to jump to line in, 662-663

coding practices, 45

accessibility, 55-57

comments, 45-51

boilerplate header comment, 47-48

for code performing specific task, 49-50

tag structures, 46-47

for variables, 48

error checking and data validation, 62-65

client-side validation, 62-65

server-side validation, 65

HTML guidelines, 54-55

naming conventions, 51-57

for data columns, 53

for data tables, 52-53

for variables, 51-52

Tag Library Editor, 65, 66, 67

web code structure, 57-62

independence of script pages, 61-62

logic structure, 59-61

test for passed variable existence, 58

test for variable value, 58

variable declaration, 58-59

ColdFusion

application.cfm file, 254

comment tags, 46

connections, to Oracle database, 136

as development environment, 262-268

as language, 259-262

# (pound) symbol, 260

<cfabort> tag, 262

<cfoutput> tag, 261

<cfquery> tag, 261-262

<cfset> tag, 261

Master/Detail Page Sets with, 578-583

Detail.cfm file, 581-583, 584

Master.cfm code, 580-581, 581

Server Behaviors for dynamic data display, 500-501

Stored Procedure Server Behavior for, 497-499

as web application server, 249-259

ColdFusion Administrator, 249-250, 250

client variables, 253

custom response for page not found, 252

Data Sources section, 241, 241, 255, 256

Debugging & Logging, 256-259, 257

Debugging IP addresses, 259, 259

memory variables, 253

server settings-settings, 250-252

server settings-settings summary, 255, 255

ColdFusion developers, connections for, 240-241

ColdFusion MX, 9

ColdFusion Server, trial version, xxii

collections, 603

COL_LENGTH() function (SQL Server), 167

COL_NAME() function (SQL Server), 167

columns in database

alias in SQL statement, 434

specifying in SQL, 434-435, 435

columns in HTML table, adding, 532-533

Command dialog box, 489

Command object, 215

Execute method of, 212

Command Server Behavior, for Microsoft ASP, 489-491

CommandText property, of MM:DataSet Custom tag, 353, 354

comments, 45-51

boilerplate header comment, 47-48

for code performing specific task, 49-50

Dreamweaver button to create, 263, 263, 264

in Oracle SQL statements, 132-133

tag structures, 46-47

for variables, 48

Common Language Runtime (CLR), 320

communication, with outside world, 4-5

CompareValidator web server control, 329

comparison operators in SQL, 463

compiled languages, 7

complex document, 70

Computer Associates Advantage Joe, 271

computer viruses

protection from, 409

sources, 412

CONCAT() function (MySQL), 149

concatenating literal values and variables, 465-467, 466

concurrent connections, vs. concurrent users, 189

concurrent users, vs. concurrent connections, 189

Connection object, 212-215

Execute method of, 212-213

Open method of, 212, 213-215

connection objects, names for, 53

Connection String Template dialog box, 236-237, 237

connection string template, loading, 236-237

connections

for ASP developers, 231-234

DSN-less connection, 234

OLE DB connection, 233-234

System DSN connection, 231-232

for ASP.NET developers, 234-238

Managed Data Provider for SQL Server, 237-238

OLE DB connection, 234-237

for ColdFusion developers, 240-241

ColdFusion settings for, 255

concurrent, vs. concurrent users, 189

creating in Dreamweaver, 225-226

for DataSet, 356

deleting, 243

for HTML forms, 512

Java Database Connectivity (JDBC), 230

for JSP developers, 238-240

custom JDBC connection, 240

JDBC-ODBC bridge, 238-239

Type 4 JDBC drivers, 239-240

managing existing, 242-243

Microsoft error messages, 243-246

access permission problems, 244

Data source name not found, 246

SQL Server login failed, 245

SQL Server logon general failure, 246

too few parameters, 246

updating date column to empty string in Access, 246

native drivers, 230-231

ODBC (Open Database Connectivity), 226-228

OLE DB (Object Linking and Embedding Database), 229-230

options

Microsoft Access, 221

Microsoft SQL Server, 184

Oracle, 135-136

for PHP developers, 242

troubleshooting, 243

ConnectionString property, of MM:DataSet Custom tag, 353, 354

constants, names for, 52

Containers operator, for search filter, 606

content for HTML, 70

CONTENT_LENGTH server variable, for ASP Request object, 309

contentType attribute, of JSP page directive, 277

CONTENT_TYPE server variable, for ASP Request object, 309

Context Help Toolbar extension, 658, 658-659

@ Control directive (ASP.NET), 324

Control Panel (Windows), Administrative Tools folder, Data Sources (ODBC), 75

control structures, comments for, 50

controls, Jet SQL to populate, 211

conversion functions, 669-670

in Access, 197-199

in Oracle, 129-130

cookies

accessing, 286-287

ColdFusion tag for, 266, 267

Live Data view to initialize variables, 479-480, 480

writing, 280-282

Cookies collection, of ASP Request object, 307-308

Cookies element, of ASP Response object, 297-298

copying files, to local site from testing server or live site, 39

Count function (SQL), 216, 467-468

COUNT() function (MySQL), 148

COUNT() function (Oracle), 124

Count() function (T-SQL), 180

crackers, protection from, 409

CREATE FUNCTION statement, for UDF, 174-175

Create New Data Source dialog box, 228

CREATE PROCEDURE statement, 172, 173

CREATE VIEW statement, 170

CreateDataSet property, of MM:DataSet Custom tag, 354

CreateObject() method, of ASP Server object, 314

crosstab queries, TRANSFORM statement to create, 457-459

CSng() function (Access), 199

CStr() function (Access), 199

Cube Stores Designer extension, 657, 657-658

cubes, 159

curly braces ({ }), for PHP code blocks, 391

Currency datatype (Access), 193

CurrentPage property, of MM:DataSet Custom tag, 355

Custom Connection String dialog box, 233

Custom JDBC Connection dialog box, 240

custom JDBC connection, for JSP developers, 240

customer information, accessing from web site, 159

CustomValidator web server control, 329