Index_U

U

UCase$() function (Access), 196

UCASE() function (MySQL), 150

UDFs. See user-defined functions

UNION operator, 462, 464

unique values, SQL statement to retrieve, 435–436

UNSIQNED attribute, for MySQL datatype, 142

update forms. See HTML forms

UPDATE statement (SQL), 448–450

updateable queries in SQL, 449, 462

updating date column to empty string in Access,

as database connection error message, 246

updating records in HTML forms, 532–538

adding page, 534–537

Go To Detail Page Server Behavior, 532–534

UPPER() function (Oracle), 127

upsizing Access database to SQL Server, 216–220

planning, 217

URL (Uniform Resource Locator), SQL Server

actions to access data, 160

URLEncode() method, of ASP Server object, 313

user account, for web service, and access permission

problems, 244

User Authentication page, 415–418, 416

User Authentication Server Behavior, 415, 416

user-defined functions

in Access, 194

in Microsoft SQL Server, 174–179

page count, 176

scalar, 175–176

table variable returned, 176–179

user input, and database design, 96–97

USER_ID() function (SQL Server), 167

USER_NAME() function (SQL Server), 167

users, concurrent, vs. concurrent connections, 189

Val() function (Access), 197

Validate Form dialog box, 63

validation of data

client-side, 62–65

server-side, 65

validation server controls, in ASP.NET, 332–336

ValidationSummary web server control, 330

Var function (SQL), 216, 469

Var() function (T-SQL), 182

VarBinary datatype (SQL Server), 161, 162

VARCHAR datatype (Oracle), 121

VARCHAR datatype (MySQL), 144

VarChar datatype (SQL Server), 161, 162

variables

case sensitivity of PHP names, 390–391

in ColdFusion

# (pound) symbol for, 260

defining, 261

comments for, 48

concatenating, 465–467, 466

declaration, 58–59

naming conventions for, 51–52

in PHP

extracting from query string, 395

Get method to pass between pages, 394–395

testing for, 58

when debugging, 259

VarP function (SQL), 216, 469

VarP() function (T-SQL), 182

VBA (Visual Basic for Applications), 7

VB.NET

for ASP.NET, 321

global.asax file in, 343

PageSecurity, 339

ResponseBuffer, 338–339

ResponseWrite, 337

validation, 334–335

Web forms example, 322

VBScript, 7, 295

Verity, 603

View menu

® Live Data, 476

® Visual Aids, ® Invisible Elements, 515

viewing template-based page, 638–640

views

for Site tab, 40

in SQL, 430

SQL Server, 169–171, 171

viruses, computer

protection from, 409

sources, 412

visitor registration on website, 422–425, 423

Visual Basic for Applications (VBA), 7