|
|
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
|
|