Mastering Dreamweaver MX Databases

R

radio button as HTML input element, 72

Radio Button object, 84

radio group control, 519–520

Radio Group dialog box, 519

Radio Group object, 84

RadioButton web server control, 329

RadioButtonList web server control, 329

Rand() function (SQL Server), 165

Randomize() function (Access), 204

RangeValidator web server control, 329

Rate() function (Access), 207

Real datatype (SQL Server), 162

Record Insertion Form, 530

Record Insertion Form dialog box, 531

Record Navigation Status Server Behavior, 529

Record Update Form dialog box, 536

Record Update Form menu, 532

RecordCount property, of MM:DataSet Custom tag, 355

RecordCountCommandTest property,

of MM:DataSet Custom tag, 355

records in database

deleting, 450–451

HTML forms to delete, 539–542, 540

HTML forms to update, 532–538

adding page, 534–537

Go To Detail Page Server Behavior, 532–534

limiting number displayed, 507

term defined, 91

Recordset dialog box, 400, 482

Advanced mode, 483, 485–486, 486,

611–613, 612

for dynamic text on template, 641

with filter, 535, 536

final configuration, 485

for join in Details.asp, 561

for search filter, 605

SQL statement in, 482–486

Dreamweaver generation of, 483–484

Recordset Navigation Bar dialog box, 528, 528

Recordset Navigation Bar object, 524

Recordset Navigation Bar Server Behavior,

507–508, 508

Recordset Navigation Status dialog box, 529, 529

Recordset Navigation Status Server Behavior,

509, 509

Recordset Server Behavior, 481, 482, 548

Recordsets, 348, 471

creating, 481–486

filter for, 535

for search page, 605

testing, 486

redirect command, of ASP.NET Response object, 339

Redirect element, of ASP Response object, 301–303

redirecting users to different URL, 282

redundant data and relational database theory, 89–90

@ Reference directive (ASP.NET), 324

referential integrity, 114–116

cascading options, 116–117

regions. See also editable region; optional regions;

repeating region

editing properties, 634

@ Register directive (ASP.NET), 324

registration

of custom tag in ASP.NET script page, 353, 356

of visitors to web site, 422–425, 423

Registry, ColdFusion client variables in, 253

RegularExpressionValidator web server control, 329

relational databases

history, 90

term defined, 91

theory, 89–90

definitions, 91

RelationsCollection object, 349

relationships, 105–109

foreign keys for, 110

joins, 107–109

many-to-many, 106, 107

one-to-many, 106, 106

one-to-one, 105–106

term defined, 91

remote host, connect and disconnect, 39

REMOTE_ADDR server variable, for ASP Request object, 309

REMOTE_HOST server variable, for ASP Request object, 309

REMOTE_IDENT server variable, for ASP Request object, 309

REMOTE_USER server variable, for ASP Request object, 309

Repeat Region dialog box, 364, 505

Repeat Region Server Behavior, 504–505, 505, 548

Repeat Rows Of The Table property, for repeating table, 630

Repeater Server Behavior, 509–510

Repeater web server control, 329, 363–368, 366

repeating region

in Details page, 560

inserting in template, 628

moving rows outside, 525–526

table with, 402, 402

on template, 617

repeating table, inserting in template, 629–630, 630

Replace() function (Access), 197

reports

of ColdFusion server settings, 255, 255

Jet SQL to populate, 211

Request object (ASP), 303–311

Request object (ASP.NET), 340

Request object (ASP)

clientcertificate collection, 309–311

Cookies collection, 307–308

Form collection, 304–305

Querystring collection, 306–307

ServerVariables collection, 308–309

REQUEST_BODY server variable, for ASP

Request object, 309

REQUEST_METHOD server variable,

for ASP Request object, 309

Require() function (PHP), 398

RequiredFieldValidator web server control, 330, 332, 333

parameters, 334

reserved words

in MySQL, using for identifiers, 153–154

and naming conventions, 53

Reset button as HTML input element, 71

Response object (ASP), 297–303

Response object (ASP.NET), 337–339

Response object (ASP)

Buffer element, 298

Cookies element, 297–298

End element, 300–301

Flush element, 299–300

Redirect element, 301–303

Write element, 298–299

restoring backups, testing, 407

Restrict Access To Page dialog box, 418, 419

Results panel, broken links on, 43, 43

right-clicking, preventing for web pages, 664

Right$() function (Access), 196

RIGHT() function (MySQL), 151

right outer join, 109, 109, 110

Rnd() function (Access), 203–204

ROUND() function (MySQL), 148–149

ROUND() function (Oracle), 126

for date/time, 128

Round() function (SQL Server), 165–166

row in database table, term defined, 91

ROWNUM() function (Oracle), 131

Rowset functions, in SQL Server, 168

RunAt property, of MM:DataSet Custom tag,

353, 354

RUNAT="SERVER" parameter, 325, 327

RunSQL method, of DoCmd object, 212