Index_T

T

T-SQL. See Transact-SQL

table variable, 174

UDF to return, 176

Table web server control, 329

TableCell web server control, 329

TableName property, of MM:DataSet Custom tag, 354

TableRow web server control, 329

tables in database

copying structure with SELECT INTO, 453

LOAD DATA INFILE statement to populate, 155–156

term defined, 91

tables in HTML, 54

for button group, 520

Dynamic Table to fill, 522

nonbreaking space in cells, 609

as repeating region on template, 617

Tag Editor—Cfquery dialog box, 264

Tag Library Editor, 65, 66, 67

TagEditor dialog box, for Submit button, 541

TagEditor—Dropdownlist dialog box, 362

TagEditor—Form dialog box

Events, 517, 518

General, 514, 514, 516

Language, 517, 517

Style Sheet/Accessibility, 516, 517

TagEditor—Textbox dialog box, 330

TagLib directive in JSP, 279

Tagtraum Industries jo!, 273

task switching, 5, 314–315

technologies, 5–6

template-based page, 616

templates

adding Dynamic Text, 640–641

anatomy, 616–617

applying to existing document, 622

benefits of, 615–616

building, 623–635

adding graphics, 623, 624

editable tag attributes, 634–635

editing region's properties, 634

inserting editable region, 626–628

inserting locked content, 625–626

inserting optional region, 630–633

inserting repeating region, 628

inserting repeating table, 629–630, 630

creating, 617–621

from Assets window, 620, 620–621

from existing page, 619

from new page, 618–619

creating page from, 621, 636–638

HTML and ASP.NET code in, 372–379

for Repeater server control, 363–364

saving files as, 48

SQL Server URL to reference, 160

viewing page based on, 638–640

temporary file, for previewing work in

browser, 23

temporary variables, 60

testing

HTML forms, 537, 537, 538

for logged-in status, 418–419

for passed variable existence, 58

for variable value, 58

web site on multiple browsers, 22

testing server, 29

connection in basic site definition, 33

copying files to local site from, 39

options, 474–481

saving files to, 31

text data, in Access, 191

TEXT datatype (MySQL), 144

Text datatype (SQL Server), 162

Text datatype (Access), 192

Text Field object, 84

Text menu, ® Align, ® Center, 625

Textarea object, 84

Textbox web server control, 329

TheDS property, of MM:DataSet Custom tag, 355

Third Normal Form (3NF), 92

meeting requirements, 102–103

threads, 6

TIME datatype (MySQL), 146

timeout requests, ColdFusion setting for, 261

TimeSerial() function (Access), 203

TIMESTAMP datatype (MySQL), 146

Timevalue() function (Access), 203

TINYINT datatype (MySQL), 142

TinyInt datatype (SQL Server), 162

TO_CHAR() function (Oracle), 129–130

TO_DATE() function (Oracle), 123, 129

TO_NUMBER() function (Oracle), 130

Too few parameters, as database connection error message, 246

toolbar, for context help, extension for building, 658–659

TOP predicate (SQL), 437, 438

Transact-SQL, 430

Microsoft SQL Server use of, 169–182

aggregate functions, 179–182

executing in code, 183–184

SQL Server views, 169–171

stored procedures, 171–174

user-defined functions, 174–179

TRANSFORM statement (SQL), 457–459

Trend Micro, 412

Trifork Application Server 3.1, 273

TRIM() function (MySQL), 151

Trimmed QueryString Element, 476

troubleshooting database connections, 243

TRUNC() function (Oracle), 126

for date/time, 129

TRUNCATE() function (MySQL), 149

Type 4 JDBC drivers, for JSP developers, 239–240