Index_S

S

Save As Template dialog box, 619, 619

saving files

error checking before, 23

as templates, 625

to testing server, 31

scale of Oracle NUMBER datatype, 122

scheme, term defined, 91

screen resolution, recommended design guidelines, 55

script host, 295

script pages, independence of, 61–62

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

scripting languages, 7–9. See also Active Server Pages

(ASP); ASP.NET; ColdFusion MX; JavaServer

Pages (JSP); PHP (Hypertext Preprocessor)

scriptlets in JSP, 9, 274–275

SCRIPT_NAME server variable, for ASP Request object, 309

ScriptTimeout property, of ASP Server object, 311

searching, 603–604

advanced, 611–613

modifying form, 611, 611

Recordset for results, 613, 614

SQL code for, 611, 612

Macromedia Exchange for extensions, 652, 653

simple search, 604–609

adding recordset, 605

Dynamic Table for results display, 606

filter, 605–606

HTML form for, 604, 604

performing, 607, 608, 609

results page adjustment, 609

Secant Technologies ModelMethods Enterprise Server, 272

Second() function (Access), 202

Second Normal Form (2NF), 92

meeting requirements, 101–102

Secure Socket Layers (SSL), certificate for, 309

security, 405

database protection, 414–415

Dreamweaver MX for, 415–425

restricting access to page, 418–425

User Authentication page, 415–418, 416

intellectual property protection, 406–408

backup testing, 407

backups, 406

offsite storage of backups, 407–408

wiping or destroying old storage media, 408

types of threats, 406

web server protection, 408–414

antivirus software, 411–412

from external attacks, 409–410

firewall, 413, 413–414

from internal mishaps, 408–409

seed value, for Rnd() function in Access, 204

Select elements in HTML forms, 80–82, 82

Select Extension To Install dialog box, 647, 647

SELECT INTO statement (SQL), 452–453

Select ODBC DSN dialog box, 232

SELECT statement (SQL), 432–447

*, and performance, 135, 432

FROM clause, 432

AS clause, 434

FROM clause, 434

AS clause, 434

GROUP BY clause, 443–445

HAVING clause, 445, 446–447

limiting group results, 445–446

ORDER BY clause, 439–440, 442–443

simple form, 433

specifying columns, 434–435, 435

SQL Server views to display, 169–170

WHERE clause, 440–442, 441, 447

SELECT...LIMIT statements (MySQL), 154–155

SelectedItemTemplate, 368

semicolon (;)

for PHP statements, 391

for SQL statements, 433

SeparatorTemplate, 364, 368

SEQUEL (Structured English Query Language), 90, 430

serial numbers, Dreamweaver MX check on network for, 17

Server Behaviors, 471, 532

for ASP.NET, 509–510

to call stored procedure, 487

Callable (Stored Procedure) Server Behavior

for JSP, 494–497

Command Server Behavior for Microsoft ASP, 489–491

Stored Procedure Server Behavior for ASP.NET, 491–494

Stored Procedure Server Behavior for ColdFusion, 497–499

for data display, 500–510

Dynamic Table Server Behavior, 506, 507

Dynamic Text Server Behavior, 501–503

Recordset Navigation Bar Server Behavior, 507–508, 508

Recordset Navigation Status Server Behavior, 509, 509

Repeat Region Server Behavior, 504–505, 505

further information, 510

Master/Detail Page Set Server

Behavior, 510

for Master-Detail Page Sets, 548

in Recordset Navigation Bar, 508

to track file download count, 648

server controls, on Web Forms, 326

Server Network Utility (SQL Server), 160

Server object (ASP), 311–314

CreateObject() method, 314

creating instance, 314

Execute() method, 312

GetLastError, 313

HTMLEncode() method, 312

MapPath() method, 313

ScriptTimeout property, 311

URLEncode() method, 313

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

server-side validation of data, 65

Server Variable dialog box, 263, 263

server variables, for JSP, 288–289

SERVER_NAME server variable, for ASP Request object, 309

SERVER_PORT server variable, for ASP Request object, 309

SERVER_PROTOCOL server variable, for ASP Request object, 309

SERVER_SOFTWARE server variable, for ASP Request object, 309

Servertec Internet Server, 272

ServerVariables collection, of ASP Request object, 308–309

Service Manager (SQL Server), 161

servlets, 269

for JavaServer Pages, 8

session attribute, of JSP page directive, 277

Session object (ASP), 315–316

session variables

ColdFusion settings for, 253

Live Data view to initialize, 479–480, 480

for login and access right behaviors, 419

Session_OnEnd, 316, 342

Session_OnStart, 316, 342

sessions, terminating, 315

SET clause, in SQL UPDATE statement, 449

SET datatype (MySQL), 145–146

SetProperty command, for JavaBean property, 292

SGML (Standard Generalized Markup Language), 70

Sgn() function (Access), 203

sharing folders, 74

short_open_tag option in php.ini file, 389

Show Assets icon (Launcher), 19, 20

Show Behaviors icon (Launcher), 19, 20

Show Bindings icon (Launcher), 19, 20

Show Components icon (Launcher), 19, 20

Show CSS Styles icon (Launcher), 19, 20

Show Databases icon (Launcher), 19, 20

Show History icon (Launcher), 19, 20

Show If Not First Record Server Behavior, 548

Show If Not Last Record Server Behavior, 548

Show Server Behaviors icon (Launcher), 19, 20

Show Sites icon (Launcher), 19, 20

significant digits, 143

Simonyi, Charles, 51

simple form, SELECT statement (SQL), 433

Simple Object Access Protocol (SOAP), 344

simultaneous requests, ColdFusion setting to limit, 261

single-line text input as HTML input element, 72

site definition, creating, 28–36

Site Definition window, 30

Advanced tab, 474, 475

Local Info category, 31

Remote Info category, 31–32

Testing Server category, 32, 32

Basic tab, 33, 33–36, 34

Summary screen, 36, 37

Site Manager, default home page designated for, 41

site map, 42, 42, 60, 61

Site panel, 475

SmallDateTime datatype (SQL Server), 161

smallest unit breakdown of data, 99

SMALLINT datatype (MySQL), 142

SmallInt datatype (SQL Server), 162

SmallMoney datatype (SQL Server), 162

SMIL (Synchronized Multimedia Integration Language), 23

SOAP (Simple Object Access Protocol), 344

software

backups, 406

for Dreamweaver MX, 13–14

Soundex() function (SQL Server), 169

Space$() function (Access), 196

space, non-breaking (  character), 54

special characters, in MySQL, 153

Split() function (Access), 197

SQL (Structured Query Language)

aggregate functions, 467–469

ASC keyword, 437, 438

Data Manipulation Language, 432

DELETE statement, 450–451

delimiting and concatenating, 465–467

DESC keyword, 437

functions in Oracle, 123–131

conversion functions, 129–130

date functions, 127–129

favorite functions, 130–131

grouping functions, 123–125

numeric functions, 125–126

string functions, 126–127

history, 430

INSERT INTO statement, 454–457

interaction with database, 430

operators, 463–465

comparison, 463

logical, 464

mathematical, 463

predicates, 435–440

DISTINCT, 435–436

TOP, 437, 438, 438–439

SELECT INTO statement, 452–453

SELECT statement, 432–447

* and performance, 135, 432

FROM clause, 432

AS clause, 434

FROM clause, 434

AS clause, 434

GROUP BY clause, 443–445

HAVING clause, 445, 446–447

limiting group results, 445–446

ORDER BY clause, 439–440, 442–443

simple form, 433

specifying columns, 434–435, 435

WHERE clause, 440–442, 441, 447

standardization, 431

statement construction in Oracle, 131–135

comments, 132–133

guidelines, 132

statement tuning, 135

syntax variations, 133–134

statements, duplicates, and upsizing, 219

subqueries, 460–462, 461

syntax and structure, 431–432

TRANSFORM statement, 457–459

UPDATE statement, 448–450

updateable queries, 462

vendor dialects, 431

what it is, 429–430

SQL Managed Provider for ADO.NET, 348

SQL Server. See Microsoft SQL Server

SQL Server Connection dialog box, 238

SQL Server Desktop, 187–190

SQL Server login failed, as database connection error message, 245

SQL Server logon general failure, as database connection error message, 246

SQL Server Properties (Configure) dialog box, Security tab, 245

SSL (Secure Socket Layers), certificate for, 309

Standard Generalized Markup Language (SGML), 70

StartRecord property, of MM:DataSet Custom tag, 355

statement in SQL, 431

StDev function (SQL), 216, 468

StDev() function (T-SQL), 181

StDevP function (SQL), 216, 469

StDevP() function (T-SQL), 182

Stored Procedure Properties dialog box, 488

Stored Procedure Server Behavior, 481

for ASP.NET, 491–494

for ColdFusion, 497–499

stored procedures, 487–488

in Microsoft SQL Server, 171–174

creating and executing, 172

default value for parameters, 174

passing parameters, 172–174

Server Behaviors to call

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

Command Server Behavior for Microsoft ASP, 489–491

Stored Procedure Server Behavior for ASP.NET, 491–494

Stored Procedure Server Behavior for ColdFusion, 497–499

storefronts, extension for building, 657–658

Str$() function (Access), 196

StrComp() function (Access), 196

string functions, 667–668

in Access, 195–197

in Microsoft SQL Server, 168–169

in MySQL, 149–151

in Oracle, 126–127

strings

in Access, 191

language overview, single and double quoted in PHP, 391–392

in MySQL, 153–154

Oracle functions for, 127

StrReverse() function (Access), 197

Structured English Query Language (SEQUEL), 90, 430

Stuff() function (SQL Server), 169

Submit button as HTML input element, 71

events, 541

subqueries in SQL, 460–462, 461

SUBSTR() function (Oracle), 127

substring() function (SQL Server), 168

SuccessURL property, of MM:DataSet Custom tag, 354

Sum function (SQL), 216, 468

SUM() function (MySQL), 148

SUM() function (Oracle), 125

SUM() function (T-SQL), 180–181

Sun

JDBC_ODBC Driver (ODBC Database)

dialog box, 239

patches for Linux products, 410, 411

Sun ONE Active Server Pages, 296

Sun ONE Application Server 7, 270, 272

surrogate keys, 94

and cascading options, 117

Sybase EAServer, 272

Syd() function (Access), 207

Symantec, 412

Synchronized Multimedia Integration Language (SMIL), 23

SYSDATE() function (Oracle), 129

System data connection, 227

System DSN, 75

System DSN connection, for ASP developers, 231–232

system functions, in Microsoft SQL Server, 166–167

System/R, 430

SYSTEM.DATA namespace, 321



Mastering Dreamweaver MX Databases
Mastering Dreamweaver MX Databases
ISBN: 078214148X
EAN: 2147483647
Year: 2002
Pages: 214

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net