diagramming, 128–129, 182
DISTINCT statements, 208
do/while loops, 379
doDelete() method, 66
doGet() methods
ControllerServlet, 324–327, 336, 375–379, 396
HTTPServlet, 61–62
ThreadTest Servlet, 306
WebAppSetup servlet, 311–312
doOptions() method, 67–68
doPost() method, 61, 65–66
doPut() method, 68–69
doStartTag() method, 272, 279, 353, 355
doTRACE() method, 69
DOUBLE data type, 169
DOUBLE PRECISION data type, 169
DROP DATABASE statements, 148, 166
drop databasename statements, 149
DROP privilege, 162
Drop_priv field, 156
E
EJBs. See Enterprise Java Beans (EJBs)
Element Construction Set (ECS) project, 440
encryption
browser support, 319
passwords, 159, 318, 319
telnet sessions, 158
User IDs, 317–318
engineInit() method, 424
Enterprise Java Beans (EJBs), 30
Enterprise JavaBeans (EJBs), 100–101
Entity-Relationship Diagrams (ERDs), 128–129, 182
ENUM data type, 171
equal tag, 469
ERDs. See Entity-Relationship Diagrams (ERDs)
FILE privilege, 162, 163
File_priv field, 156
findAttribute statements, 111, 113
findLogger() method, 422
finishSetup() method, 395
flat-file databases, 14, 120–121, 122, 123
FLOAT data type, 169
flush-hosts statements, 149, 156
flush-logs statements, 149, 156
flush-privileges statements, 149, 156, 159, 223, 249
flush-status statements, 149
flush-tables statements, 149, 156
flyweight design pattern, 235
foreign keys. See keys, foreign
form tag, 467–468
FormBean class, 348–350, 365, 379
FormFieldBean class, 344–345, 391–394
FormFieldRadioHandlerBean, 365–366
FormFieldTag class, 355–357
FormFieldTextArea class, 347
FormFieldTextBean class, 346–347
forms
authentication, form-based, 318, 320–321
classes, derived, 339, 345–346, 348, 350
common gateway interface (CGI) versus servlet processing, 340
Connection instance, use of, 343, 361
controller servlet processing, 340–341, 343, 351, 358–359, 374–380
databases, submitting results, 361, 380, 382–383
displaying, 63–65, 342, 352–358, 361
field default values, 346, 358, 360
field JavaBeans, 343–351
field modeling, 343–351
field properties, 343, 345
fields, hidden, 339, 348
fields, required, 381
fields, validating, 381–382
footers, 355
form JavaBeans, collecting field Beans in, 347–351
form JavaBeans, creating, 349
form JavaBeans, database update function, 359–361
form JavaBeans, forwarding as request attribute, 351–352, 355, 379–380
form JavaBeans, instance creation, 351, 358–359, 364
form JavaBeans, value setting function, 359–361
headers, 352, 353, 355
HyperText Markup Language (HTML), 62–63, 339–340, 343, 467–468
instances, creating, 351
instances, determining if new, 343
JavaServer Page (JSP), form, 342, 343, 389
JavaServer Page (JSP) use, 342
JavaServer Page (JSP), view, 343, 351–352, 370, 380, 389
JavaServer Pages (JSPs), creating, 370–374
JavaServer Pages (JSPs), field generation into, 355–357
JavaServer Pages (JSPs), request forwarding to, 343
JavaServer Pages (JSPs), request processing, 343, 361
messages to user, displaying, 372–373
Model-View-Controller (MVC) approach, 340–343
radio buttons in, 364–367, 394–395
request Uniform Resource Indicators (URIs), 343
requests, differentiating from submissions, 348, 359–360
requests, forwarding to view JSP, 343, 351–352
requests, GET, 62–63, 340, 375–379
requests, intercepting using servlet mapping, 240, 341, 374–375
requests, JavaBean attachment to, 351–352
requests, JavaServer Page (JSP) processing of, 343, 361
requests, locating form in, 357
requests, POST, 65–66, 340, 375
requests, processing logic, 375–376
requests, Uniform Resource Locators (URLs) for, 358
requests, validating, 380–381
responses, Uniform Resource Locators (URLs) for, 358
saving submitted data, 342, 343, 361
security, 358
shopping cart applications, 241–242
Struts form handling, 442–443, 447, 452, 454–456, 457–458
submit buttons, 339–340, 355, 395, 455
table data, controller, 342, 359, 369, 374
text boxes, multiline, 347
[dq]thank you[dq] page, 369, 380
Tomcat support of, 339
validation, 342, 343, 358, 367, 380–382
values, default, 346, 358, 360
values, setting, 359–361
FormSurveyBean class
graphing survey results, 404–411
source code, 397–404
FormTag class, 353–354
forward() method, 238, 263
forward tag, 469
forwards, 442, 451
FreeMarker, 11
G
General Public License (GPL), 15,
137
GenericServlet class, 58
GET method
form submission, 62, 86,
318
page requests, 61
POST method compared, 66
getAsText method, 466
getAttribute() method, 74, 84–85,
256, 295, 313
getException method, 85
getExtraInfo() method, 359
getFormDonePage() method, 413,
414
GetFormFields Servlet, 63–64
getHtml() method, 345, 346
getInitParameter method, 256
getInitParameterNames method, 72
getIterator() methods, 270, 271,
295, 390
getLinks() methods, 311, 312–313
getMetaData() method, 227
getMethod methods, 61, 64, 295–296
getOut method, 85
getPage method, 85
getParameterNames method, 64
getProperty method, 98–99, 249,
250, 269
getProperty tag, 269
getRequest method, 85
getResponse method, 85
getServletConfig method, 85
getServletContext method, 85, 268
getServletContext() method, 268
getServletPath method, 262
getSession method, 84, 85, 99
getString() method, 227
getter methods, 58
getVariableInfo method, 114
GIF images, 412
GNU project, 15
GPL. See General Public License
(GPL)
GRANT statements, 161–162, 163,
222–223
Grant_priv field, 156
graphs
JPG images, 404–405, 412–413
user survey results, 386,
404–411
greaterEqual tag, 469
greaterThan tag, 469
Greenspan, Jay, 211
groupadd statements, 142
CGI. See Common Gateway Interface
(CGI)
character set, 59–60, 84–85
Charset property, 59–60
chat room applications
color, 103, 104, 106
error handling, 105
login page, 103, 120–122
messages, displaying, 112–114
messages, posting, 107–111
username processing, 105–107M
with this book Access Project Security Manager 1553CD-ROM with this book
EZ File Manager Sampler 1555CD-ROM with this book EZ Search Manager Sampler
1556CD-ROM with this book Mountain Animal Data Access Pages database 1180CD-ROM
with this book Report Manager Professional 1554CD-ROM with this book Search
Manager Professional 1554CD-ROM with this book updates, downloading 64client/server
environment See also projects, Access; SQL Server 2000 Desktop Enginecommand
button controls hyperlinks, attaching to 1213, 1215data access pages (DAPs)
HyperText Markup Language (HTML) document component 1220, 1224, 1226, 1229data,
exporting Extensible Markup Language (XML), to 1265-1266, 1267-1270data,
exporting HyperText Markup Language (HTML), form datasheets to 1194-1198,
1200-1201data, exporting HyperText Markup Language (HTML), page setup properties
when exporting to 1198data, exporting HyperText Markup Language (HTML),
query datasheets to 1192-1194data, exporting HyperText Markup Language
(HTML), report datasheets to 1202-1205data, exporting HyperText Markup
Language (HTML) tables, to 739-740, 1186, 1190-1192d–147
introduced, 21
shared, 76–77
transactions, role in, 310
Web, finding on, 146
#config directive, 316, 330–333
Connection objects, 225–234, 257–258,
279. See also database operations
Connection parameter, 243
connection testing, 62–63
ConnectionString property, 234
ConnectionTimeout property, 234
Content Linking component, 127,
133–137
content rating, 63–65
Content Rotator component, 127,
138–139
CONTENT_LENGTH variable, 46, 323
ContentLink configuration file,
134
ContentType property, 60
CONTENT_TYPE variable, 46, 323
cookies
alternatives to, 211–212
browser issues, 198
checking for, 204–205
collection, 198–199
communier 825records queries,
returning number of in 809-811reports macros, running on return to previous
section 952-953reports printer setup 440, 587-589, 651-654security forms,
startup 1326security startup options 1328-1330Setup Wizard 1420, 1426sorting
Structured Query Language (SQL) statements, specifying in 827, 831SQL Server
2000 Desktop Engine bootup, starting on 1120SQL Server 2000 Desktop Engine
connection setup 1123-1124, 1144SQL statements See Structured Query Language
(SQL) statementsstarting Access See also startup optionsStartup dialog
box 47, 57, 1087startup options Access icon, specifying 1086startup options
applications 1402-1404startup options bypassing 13 collection, 37, 44
CopyFile method, 150
CopyFolder method, 150
Count method, 252
Count property, 43, 73, 83
counters, 139–140, 142
Counters component, 128, 139–1er
825records queries, returning number of in 809-811reports macros, running
on return to previous section 952-953reports printer setup 440, 587-589,
651-654security forms, startup 1326security startup options 1328-1330Setup
Wizard 1420, 1426sorting Structured Query Language (SQL) statements, specifying
in 827, 831SQL Server 2000 Desktop Engine bootup, starting on 1120SQL Server
2000 Desktop Engine connection setup 1123-1124, 1144SQL statements See
Structured Query Language (SQL) statementsstarting Access See also startup
optionsStartup dialog box 47, 57, 1087startup options Access icon, specifying
1086startup options applications 1402-1404startup options bypassing 13ng,
277–282
commands, 237–242
connections, closing, 227–228
connections, creating explicitly,
225–226, 279
connections, creating in
global.asa file, 227
connections, opening, 226–227,
279
connections, properties,
234
connectioapplication 933macros
tasks possible using 894-895menu bars docking options 1070Microsoft Office
spell checking 554-556Object Linking and Embedding (OLE) See also data,
exporting; data, importing; data, linking; OLE Object data typeObject Linking
and Embedding (OLE) data types supported 691-692Object Linking and Embedding
(OLE) embedding graphs 535-542Object Linking and Embedding (OLE) file path
considerations 521Object Linking and Embedding (OLE) linking in graphs
539-540, 542Object Linking and Embedding (OLE) reports, OLE objects in
643Object Linking and Embedding (OLE) types of objects supported 222-223On
Click event property command buttons, using with 1052, 1059On Click event
property macros, callinmary keys 851, 852forms subforms using lookup tables
852-859forms tables, working with multies, passing parameters to, 241
queries, 219–222
record sets, closing, 231,
269
record sets, creating, 219,
230–231, 268
record sets, cursor type
assignment, 243–244
record sets, data manipulation
using, 245–251
record sets, multiple, 231–233,
234–236, 250–251
record sets, opening, 231,
242–243, 269
records, adding, 248, 291–297
records, deleting, 248–249,
301, 302
records, locking, 245–246
records, looping, 220–221,
269
records, updating, 246–247,
297–305
resynchronizing data, 244
schema, accessing information
about, 251–256
schema, defining, 218
searches, 249–250
searches, keyword, 270–273,
383, 384
SQL execution at connection
level, 228–230
SQL insert statements, 293–294
SQL search statements, 272
tables, accessing information
about, 255–256
transactions, 259–261
date, inserting in page, 330–331;
(semicolon) Structured Query Language (SQL) statement delimiter 831-832combo
box controls queries, creating from 515-517, 855, 857Crosstab Query Wizard
766-767data access pages (DAPs) query conversion to 1255-1256data, exporting
HyperText Markup Language (HTML), query datasheets to 1192-1194data, linking
functions in query criteria 716data types action queries, errors in 799date
operations queries, in 292-293, 753, 764, 782, 806-808errors query failure
on 825errors query timeout on 824expressions in queries, total 744, 745,
754-756fields combining using union queries 813-815fields Structured Query
Language (SQL) statements, selecting for 814, 815, 817, 827, 828-831forms
queries, based on 88, 254, 424-427forms subforms, queries used in 836,
846-847functions queries, in 375, 1158, 1165-1166indexes creating using
data definition queries 813, 816-817indexes queries, updating from 356Jet
queries, maximum simultaneous 1116list box controls query data source 509-510mail
merge reports queries, assembling data using 879mathematical operations
See also queries, total queriesmathematical operations queries, in 381-382,
387, 393-394mathematical operations Structured Query Language (SQL) functions
224Memo data type queries, in 376-377New Query dialog box 274, 766Object
Linking and Embedding (OLE) queries, in 382On Query event property 924operators
queries, in 293, 370-374permissions queries, assigning temporarily using
1346pivot tables crosstab queries compared 557procedures queries using
stored procedures 1161-1165projects, Access queries 1127, 1157, 1158-1166queries
action queries 271, 773queries action queries, append 773, 785-790, 799,
800queries action queries, backing up before 775queries action queries,
checking results 775-776, 780, 784, 790, 793queries action queries, converting
select queries to 779-780queries action queries, creating 777-778, 781-783,
785-789, 790-793, 813-817queries action queries, data-type errors in 799queries
action queries, delete 184, 773, 776, 790-794queries action queries in
projects 1157queries action queries, key violations in 799-800queries action
queries, locked record issues 800queries action queries, make-table 719,
773, 776, 781-784queries action queries, reversing 776-777queries action
queries, running 799queries action queries, safety tips 775, 777queries
action queries, saving 798-799queries action queries, scoping criteria
776queries action queries, select queries versus 775queries action queries,
steps in working with 775queries action queries, tasks accomplished by
774-775queries action queries, troubleshooting 799-800queries action queries,
types 773-774queries action queries, update 773, 777-780, 799, 800, 1164-1165queries
action queries, using stored procedures with 1164-1165queries ANSI-92 SQL
query mode, enabling 823queries back-version compatibility 40queries Between
. . . And operators in 387-388queries Boolean
| I sometimes think the stork made a terrible mistake and dropped me
at a humble peasant dwelling instead of at the palace and that I'm
really a princess, I mean prince, in pauper's clothing. I'd demand
genetic testing except I look too much like my folks. Oh well.
I index books for a living. Freelance. Mostly computer books. Not bad actually! Everything takes place over the Internet and I can work whenever, wherever and however I want. I can support myself working part-time. Best gig I've ever had / this is as good as it gets! I'm also completely uninterested. I put on a good show though, am dependable, do what is asked without question and clients love me. I'm almost four years into this now and I expect I'll be indexing until I win a lottery or croak whichever comes first. Next step is to find a publisher with books I might actually want to read if I weren't being paid to do so. Heaven! Soon on I discovered that publishers tend to treat the index as a page stuffer at the end. Two actual examples from my last two jobs: "We need to fill 20 more pages, add 2,000 entries." -- no prob. "Turns out we're short of space, cut from 75 pages down to 16 [in other words cut 6,000+ entries!]. We need it back by 4:30." -- no prob. Hey, you want shit you got it just pay me. If ever the book you're reading has a lousy index, don't blame the indexer! Before that I was a librarian. That was OK. My last job was managing systems and cataloguing for a consortium of 13 public libraries. I was completely uninterested but I put on a good show, did a good job and employers loved me. I didn't like supervising people and the relentless 9 to 5 was a killer. A normal-type job is really really painful for me. Before that I did shit work. Work has been hard, it really has. The work world we've created for ourselves is quite mad and it's not been easy to find a sane way through. The indexing I do now is the best I've come to -- and believe me I've looked around, made huge efforts and tried many things! It doesn't devour my whole life; it doesn't force me to spend the majority of my waking hours surrounded by people I have absolutely nothing in common with; and it pays well (mainly because I get paid in U.S. dollars). I don't go around hating my work. I don't hate it. It's OK. Lord knows I'm far better off than most people in the world! I appreciate where I've come to and am very grateful for my work. Without it the bubblebath'd stop flowing pretty quick! Work is central to what it is to be human. How strange the madness it has become. Pound Of Flesh
Yeah, that's me. This is what you get for sitting all day every day at a keyboard for 16 years.
|
| page
directive, 81–82, 86
page objects, 85 page tag, 465 pageContext objects, 85 pages compression, 73 context, 85 counters, 88 deletion by users, 66 headers, display by user, 66–67, 69 headers, servlet access to, 61, 73 hiding by changing extension, 279–280 layout, 233–234, 266 scope, 84, 461 update by users, 68 parameter tag, 465 Password field, 155 password new-password statements, 149 passwords. See also authentication; security asterisks display, 318 changing, 149 encryption/encoding, 159, 318, 319 prompting for, 188 requiring, 149, 161, 226 root, 151, 157–158 server, when connecting to, 149 storage location, 155, 183 perform() method, 456 Perl scripts Apache server Perl interpreter, 22 common gateway interface (CGI), 22 server-side includes (SSI), executing from, 21 as server-side scripting language, 23 sources, 22 permissions. See also access control adding, 158–160 administrator/superuser, 157 changing, 160 create, 166 database access, 155, 156, 162 database, core, 142 flushing privileges, 149, 156, 159, 223, 249 grant tables, reloading, 149, 150, 159, 162 granting, 161–162, 248 index access, 155, 156, 162 introduced, 140 record access, 155, 156, 162 reloading, 159 removing, 160, 162–163 table access, 155, 156, 162 user rights records, 190–191, 194 Web server access, 156, 162, 163 ping statements, 150 POST method, 58, 59, 64, 66 present tag, 471 primary key. See keys, primary PRIMARY KEY attribute, 172 println statements, 227, 229 procedures MySQL support, 138 Structured Query Language (SQL) support, 209 PROCESS privilege, 162, 163 processlist statements, 150 Process_priv field, 156 programming code location choices, 240–241 PropertyEditor interface, 466 PUT method, 68 Q
R
F
G
|
scriptlets
avoiding, 244, 268 code location in, 228 custom tags, replacing by, 109 data declaration using, 87 JavaBeans, replacing by, 86 JavaServer Pages (JSPs), in, 84, 85–87 syntax, 84 scripts directory, 145 searching. See queries Secure Sockets Layer (SSL), 319 security. See also access control; authentication; permissions certificates, 319 encryption, 158, 159, 317–318, 319 forms, 358 Java and native code, linking, 28 server access, logging, 8–9 servlet chaining, 51 telnet session encryption, 158 Tomcat, 319–324 Tomcat security manager, 475 validation, client-side, 342, 380–381 web.xml settings, 319 SecurityBean class, 329–333 SELECT privilege, 162 SELECT statements, 138, 154–155, 202–209 Select_priv field, 155, 156 SEQUEL. See Structured English Query Language (SEQUEL) Serializable interface, 100 server-side includes (SSI), 21, 23 server-side scripting languages, 21, 23. See also specific languages servers, Web. See Web servers server.xml Tomcat configuration file, 39–45, 54 service() method, 57–58, 59–61 service, running MySQL as, 144–145 servlet containers. See also Tomcat contexts/servlet relationship, 51 in-process, 28 JavaServer Page (JSP) requests, 89 memory space, 28–29 message flow, 11–12, 27–28 out-of-process, 28–29 standalone, 12, 29 tasks, 11 Web application handling, 50–52 Web server, interaction with, 11–12, 27–29 servlet context initialization parameters, retrieving, 72–73 interceptors, 45 interservlet communication, role in, 51–52 JavaServer Page (JSP) implicit object, 85 retrieving ServletContext object, 465 servlets, relationship with, 51 servlet engines. See servlet containers servlet mapping controller servlet setup, 261–263 forms, using with, 240, 341, 374–375 request interception function, 50, 231, 237, 261–263 request logging, in, 415–416, 418–422 web.xml files, defined in, 46 ServletRequest objects, 59, 85 ServletResponse objects, 59, 85 servlets access, simultaneous, 303–308 applets compared, 19 benefits, 23–24 C/C++ versus, 23–24 chaining, 51 code located in, 240 communication between, 51–52 defined, 19 destroying, 57–58, 253 forms, calling from, 240 initialization parameters, 57–58, 71–72 initialization servlets, 251, 252–260 input control using, 237–238 instances, 303, 306–307 JavaServer Pages (JSPs), compiling into, 78, 79–81, 83, 87, 89 loading, 57–58, 224, 251, 252–253 portability, 24 retrieving ServletConfig object, 85, 465 specifications, 25, 473 Web sites related to, 25 servlets, controller in authentication, 324–327 declaring, 261 in forms, 340–341, 343, 351, 358–359, 374–380 mapping, 261 in request logging, 415–417 request management functions, 261–263 Struts, 442, 443 in user surveys, 388, 389, 395–397 session management. See also cookies beans, session, 101 cookies, role in, 73–74 distributed database, using, 102 distributed environment issues, 102 JavaBean persistence, 100 persistence of session data, 100 referencing current session, 82 tracking, 73–74, 99, 102, 417–418 Uniform Resource Locator (URL), appending session ID to, 452 session objects, 85, 457, 465 session scope, 84, 461 SET data type, 171 Set interface, 289, 291 setAttribute() method, 74, 256 setAttributeservlet method, 268 setAttributeservlet() method, 268 setFormPage() method, 369 setParameters() method, 348, 359–360 setPrompt() method, 358 setProperty method, 95, 97 setProperty tag, 95 setValue() method, 367 share/mysql directory, 145 shopping cart applications, 74, 100, 241–242 SHOW DATABASES statements, 151–152 SHOW TABLES statements, 153, 173 SHT files, 21 SHTM files, 21 SHTML files, 21 SHUTDOWN privilege, 162, 163 shutdown statements, 150 Shutdown_priv field, 156 SimpleTag class, 106 SingleThreadModel, 306–307, 308, 313 singleton design pattern, 235 Slide project, 440 SMALLINT data type, 168, 171 SnoopServlet, 70 socket files, 149 Solaris, 32 SQL. See Structured Query Language (SQL) SQL1 standard, 122 Uniform Resource Identifiers (URIs), storage in, 263, 278 resource tag, 465–466 response objects, 85, 465 ResultSet objects, 226–227, 259 ResultSetMetaData objects, 227 REVOKE statements, 160, 162–163 rlike operator, 211 Rocks class, 284–285, 287–289 ? (question mark ) wildcard character 227, 326, 377[ ] (square brackets) wildcard character delimiters 325, 377CD-ROM with this book Cool Combo Box Techniques 1555Crosstab Query Wizard 766-767data access pages (DAPs) software requirements 1218-1219Find Duplicate Query Wizard 794Find Unmatched Query Wizard 794-798hardware requirements 24, 1117, 1143, 1276Microsoft Office hardware requirements 24Microsoft Office software requirements 24Microsoft SQL Server Database Wizard 1123-1125passwords SQL Server 2000 Desktop Engine 1124, 1147queries action queries, steps in working with 775queries action queries, using stored procedures with 1164-1165queries Between . . . And operators in 387-388queries column width, changing 285queries counters, working with 381-382queries crosstab queries, Row Heading field 757, 758, 760-761, 763queries crosstab queries, specifying criteria against new fields 761-763queries crosstab queries, specifying criteria against Row Heading fields 763queries currency data, working with 381-382queries Datasheet View 275, 277, 283queries Field List Window, working with 76, 346-347, 348, 349-350queries field lowest value, returning 746, 824queries numeric data, working with 381-382, 387, 393-394queries Object Linking and Embedding (OLE) objects, working with 382queries table names, showing/hiding in design mode 821-823queries tables, adding to views 1158-1159queries total queries, creating using QBE pane Total: row 742-746queries Web page creation from 1186queries Yes/No criteria, working with 382, 778Query by Example (QBE) pane Criteria row 278, 291Query by Example (QBE) pane Delete row 793Query by Example (QBE) pane fields, working with in 281-282, 283-288, 383Query by Example (QBE) pane Sort row 278, 288-289Query by Example (QBE) pane Table row 278, 823Query by Example (QBE) pane Total row 742-746, 757Query êShow Table 76, 275software requirements 24, 1117, 1218-1219SQL Server 2000 Desktop Engine database diagrams, working with 1127, 1138-1142SQL Server 2000 Desktop Engine hardware requirements 1117, 1143SQL Server 2000 Desktop Engine passwords 1124, 1147SQL Server 2000 Desktop Engine software requirements 1117SQL Server 2000 Desktop Engine tables, displaying ownership 1131SQL Server 2000 Desktop Engine Windows NT, integrated security with 1115, 1116Structured Query Language (SQL) statements creating in SQL view window 826Structured Query Language (SQL) statements viewing 826Structured Query Language (SQL) statements WHERE clauses 829-830, 831text, working with append queries 800toolbars Query Design window 277-278Web pages queries, creating from 1186mary keys 851, 852forms subforms using lookup tables 852-859forms tables, working with multiple 457-463forms updates, checking for 1174functions forms, using to check for updates 1174Help systems, custom F1 key, mapping to 1367, 1393-1394Help systems, custom F1 key, preventing from being passed to Access runtime 1419Help systems, custom HyperText Markup Language (HTML) files, working with 1372-1374, 1376Help systems, custom topics, linking 1367-1368Hyperlink data type HyperText Markup Language (HTML), exporting to 1191hyperlinks command buttons, attaching to 1213, 1215hyperlinks HyperText Markup Language (HTML) tables, in imported 1210hyperlinks images, attaching to 1213, 1215HyperText Markup Language (HTML) See also Web pagesHyperText Markup Language (HTML) anchors 1206HyperText Markup Language (HTML) Browser title bar, displaying text in 1206HyperText Markup Language (HTML) datasheets, page setup properties when exporting to 1198HyperText Markup Language (HTML) Extensible Markup Language (XML) compared 1266HyperText Markup Language (HTML) form datasheets, exporting to 1194-1198, 1200-1201HyperText Markup Language (HTML) Help topics, writing in 1372-1374HyperText Markup Language (HTML) lists, importing from 1208-1210HyperText Markup Language (HTML) report datasheets, exporting to 1202-1205HyperText Markup Language (HTML) sorting 1192HyperText Markup Language (HTML) tables, exporting to 739-740, 1186, 1190-1192HyperText Markup Language (HTML) tables, importing from 736, 1208-1210HyperText Markup Language (HTML) viewing code 1197images hyperlinks, attaching to 1213, 1215Jet SQL Server 2000 Desktop Engine compared 1114keys, primary advantages of using 158-159, 170-171keys, primary AutoNumber field assignment 158, 168keys, primary length, optimal 171keys, primary linking operations, in 694-695, 703, 704keys, primary subform linking by 851, 852keys, primary table relationships involving 167macros keystrokes, passing to Access 933macros keystrokes, passing to another application 933macros tasks possible using 894-895menu bars docking options 1070Microsoft Office spell checking 554-556Object Linking and Embedding (OLE) See also data, exporting; data, importing; data, linking; OLE Object data typeObject Linking and Embedding (OLE) data types supported 691-692Object Linking and Embedding (OLE) embedding graphs 535-542Object Linking and Embedding (OLE) file path considerations 521Object Linking and Embedding (OLE) linking in graphs 539-540, 542Object Linking and Embedding (OLE) reports, OLE objects in 643Object Linking and Embedding (OLE) types of objects supported 222-223On Click event property command buttons, using with 1052, 1059On Click event property macros, callinmary keys 851, 852forms subforms using lookup tables 852-859forms tables, working with multiple 457-463forms updates, checking for 1174functions forms, using to check for updates 1174Help systems, custom F1 key, mapping to 1367, 1393-1394Help systems, custom F1 key, preventing from being passed to Access runtime 1419Help systems, custom HyperText Markup Language (HTML) files, working with 1372-1374, 1376Help systems, custom topics, linking 1367-1368Hyperlink data type HyperText Markup Language (HTML), exporting to 1191hyperlinks command buttons, attaching to 1213, 1215hyperlinks HyperText Markup Language (HTML) tables, in imported 1210hyperlinks images, attaching to 1213, 1215HyperText Markup Language (HTML) See also Web pagesHyperText Markup Language (HTML) anchors 1206HyperText Markup Language (HTML) Browser title bar, displaying text in 1206HyperText Markup Language (HTML) datasheets, page setup properties when exporting to 1198HyperText Markup Language (HTML) Extensible Markup Language (XML) compared 1266HyperText Markup Language (HTML) form datasheets, exporting to 1194-1198, 1200-1201HyperText Markup Language (HTML) Help topics, writing in 1372-1374HyperText Markup Language (HTML) lists, importing from 1208-1210HyperText Markup Language (HTML) report datasheets, exporting to 1202-1205HyperText Markup Language (HTML) sorting 1192HyperText Markup Language (HTML) tables, exporting to 739-740, 1186, 1190-1192HyperText Markup Language (HTML) tables, importing from 736, 1208-1210HyperText Markup Language (HTML) viewing code 1197images hyperlinks, attaching to 1213, 1215Jet SQL Server 2000 Desktop Engine compared 1114keys, primary advantages of using 158-159, 170-171keys, primary AutoNumber field assignment 158, 168keys, primary length, optimal 171keys, primary linking operations, in 694-695, 703, 704keys, primary subform linking by 851, 852keys, primary table relationships involving 167macros keystrokes, passing to Access 933macros keystrokes, passing to another application 933macros tasks possible using 894-895menu bars docking options 1070Microsoft Office spell checking 554-556Object Linking and Embedding (OLE) See also data, exporting; data, importing; data, linking; OLE Object data typeObject Linking and Embedding (OLE) data types supported 691-692Object Linking and Embedding (OLE) embedding graphs 535-542Object Linking and Embedding (OLE) file path considerations 521Object Linking and Embedding (OLE) linking in graphs 539-540, 542Object Linking and Embedding (OLE) reports, OLE objects in 643Object Linking and Embedding (OLE) types of objects supported 222-223On Click event property command buttons, using with 1052, 1059On Click event property macros, callinage (SQL) statements creating in SQL view window 826Structured Query Language (SQL) statements database servers, sending commands to 813, 815-816Structured Query Language (SQL) statements field selection 814, 815, 817, 827, 828-831Structured Query Language (SQL) statements financial functions 224Structured Query Language (SQL) statements FROM clauses 830-831Structured Query Language (SQL) statements indexes, dropping 813, 816-817Structured Query Language (SQL) statements Internet resources 832Structured Query Language (SQL) statements modifying 826Structured Query Language (SQL) statements ORDER BY clauses 827, 831, 1157Structured Query Language (SQL) statements queries, conversion to/from 826, 1021-1023Structured Query Language (SQL) statements query selection 830-831Structured Query Language (SQL) statements records, displaying based on top values 830Structured Query Language (SQL) statements sort order 827, 831Structured Query Language (SQL) statements stored procedures, in 1161Structured Query Language (SQL) statements table lookup properties, in 195Structured Query Language (SQL) statements table selection 827, 830-831table relationships Find Unmatched queries 182table relationships joins, creating in queries 357-360, 803table relationships joins, deleting in queries 358, 360table relationships queries, creating in 174, 343-345, 349, 351-354, 357-360table relationships queries, overridden by 177tables creating using make-table action queries 719, 773, 776, 781-784tables lookup tables in queries 803-805tables queries, adding to 75, 275, 277, 349tables queries, opening in 344tables queries, removing from 275, 349tables queries, updating from 354-357tables query destination table name 825tables Structured Query Language (SQL) statements, selection for 827, 830-831text, working with append queries 800toolbars Query Design window 277-278TOP query clause 1163Web pages queries, creating from 1186Yes/No data type queries, in 382, 778 background sound support, determining, 131 buffer flusing to, 56–57 connection testing, 62–63 cookie limitations, 198 frame support, determining, 131 Java support, determining, 131 platform, determining, 131 properti |
struts-bean.tld
file, 441
struts-config_1_0.dtd file, 448 struts-documentation.war file, 441 struts-example.war file, 441 struts-html file, 441 struts-logic.tld file, 441 struts tag, 466 struts-template.tld file, 442 struts-test.war file, 441 subscription order tracking, 134, 187, 188–189, 192–193 subselects, 138 sum() method, 286, 289, 435 Sun Java Web site Developers Connection Bookshelf, 25 development kits, 473–474 Java downloads, 30–31, 473–474 Java2 Enterprise Edition Blueprints, 25, 474 overview, 25 specifications, 473 SurveyBean1 class, 387–388 surveys. See user surveys synchronization, thread, 307–308, 309 System/R, 121 T
|
servlet variable declaration operator, 89
SQL comparison operator, 209
!= (exclamation mark, equal sign) SQL comparison operator, 209
% (percent sign) MySQL wildcard character, 161
%> (percent sign, arrow)
directive delimiter, 81
scriptlet delimiter, 84
&& (ampersands) SQL comparison operator, 209
* (asterisk) JavaServer Page (JSP) wildcard operator, 96
*/ (asterisk, slash) Java comment delimiter, 45
--> (dash, dash, arrow) XML comment delimiter, 45
/* (slash, asterisk) Java comment delimiter, 45
; (semicolon) SQL statement suffix, 152, 153
< (arrow) SQL comparison operator, 209
<!-- (arrow, exclammation mark, dash, dash) XML comment delimiter, 45
<% (arrow, percent sign) scriptlet delimiter, 84
<%@ (arrow, percent sign, at sign) directive delimiter, 81
<= (arrow, equal sign) SQL comparison operator, 209
<=> (arrow, equal sign, arrow) SQL comparison operator, 209
<> (arrows) SQL comparison operator, 209
<P> </P>JavaServer Page (JSP) paragraph delimiters, 78
= (equal sign) SQL comparison operator, 209
> (arrow) SQL comparison operator, 209
>= (arrow, equal sign) SQL comparison operator, 209
? (question mark) form data delimiter, 65
_ (underscore) MySQL wildcard character, 161, 210
|| (pipes) SQL comparison operator, 209
3NF. See third normal form (3NF)
% % (percent signs) keyword delimiter, 384
| (pipe) TextStream object form elements separator, 159
#config directive, 316, 330–333
#echo directive, 316, 322–326
#exec directive, 316, 326
#flastmod directive, 316, 326–328
#fsize directive, 316, 328–329
#include directive, 316–322
% (percent sign)
escape sequence prefix, 9
SQL wildcard, 384
& (ampersand)
parameter separator, 8
in URLs, encoded, 9
" "+ (double quotes, plus sign) record set copy operator, 299
' ' (single quotes) string delimiters, 249, 384
+ (plus sign) space escape sequence, 9
<!-- > (arrow, exclamation mark, double dash, arrow) SSI delimiters, 6
<% ... %> (arrow, percent sign ... percent sign, arrow)
script code delimiters, 14–15
variable delimiters, 15
<%@ ... %> (arrow, percent sign, at sign ... percent sign, arrow) directive delimiters, 15
= (equals sign) value assignment operator, 8
? (question mark) querystring prefix, 8
Ad Rotator component, 127, 128–131
adBigInt database field type, 251
adBoolean database field type, 251
adBSTR database field type, 251
adChar database field type, 251
adCmdStoredProc database option, 229
adCmdTable database option, 229
adCmdText database option, 229
adCmdUnknown database option, 229
adCurrency database field type, 251
adDate database field type, 251
adDBDate database field type, 251
adDBTime database field type, 251
adDBTimeStamp database field type, 251
adDecimal database field type, 251
AddHeader method, 54–55, 112
AddLogin method, 340
AddNew method, 248
adDouble database field type, 251
adEmpty database field type, 252
adError database field type, 252
adInteger database field type, 252
adLockBatchOptimistic lock type, 246
AdLockOptimistic lock type, 246
AdLockPessimistic lock type, 245
AdLockReadOnly lock type, 245
adLongVarBinary database field type, 252
adLongVarChar database field type, 252
adLongVarWChar database field type, 252
adojavas.inc, 230, 234, 243
adOpenDynamic cursor type, 244
adOpenForwardOnly cursor type, 244
adOpenKeySet cursor type, 244
adOpenStatic cursor type, 244
adovbs.inc, 230, 234, 243
adSingle database field type, 252
adSmallInt database field type, 252
adTinyInt database field type, 252
adult sites content rating, 63–65
adUnsignedBigInt database field type, 252
adUnsignedInt database field type, 252
adUnsignedSmallInt database field type, 252
adUnsignedTinyInt database field type, 252
adVarBinary database field type, 252
adVarChar database field type, 252
adVarWChar database field type, 252
advertisements, rotating, 128–131
adWChar database field type, 252
ALL_HTTP variable, 45, 323
ALL_RAW variable, 45
ancillary resources, 12
anonymous access, 336
Append Parameters method, 239
AppendChunk method, 240
AppendToLog method, 55–56
application directory. See virtual directory
Application object
Contents collection, 72–74
described, 20
event processing, 75–76
locking/unlocking, 69–70
properties, accessing, 70–72
properties, counting, 73
properties, finding name, 73–74
properties, removing, 74
StaticObjects collection, 76–77
values, accessing, 72–73
values, setting, 72–73
application root, 12, 67
Application_OnEnd event, 75–76
Application_OnEnd event handler, 22
Application_OnStart event, 75, 211
Application_OnStart event handler, 22
APPL_MD_PATH variable, 45
APPL_PHYSICAL_PATH variable, 45
arrays
color arrays, 103
count of elements, 110
formatting data from, 380, 390
JavaScript, 39
subarrays, extracting, 110
.asp files, 12
ASPDeveloper.Net, 146
asp.dll, 7
ASPError object, 95
AspScriptTimeout property, 91
AtEndOfStream property, 154, 156
atomicity, 307
Attributes Parameters property, 239
Attributes property, 234
authentication
anonymous access, 336
basic, 337
certificates, 37, 44, 337–338
digest, 337
enabling, 338
filters, 3rd party, 338–339
integrated Windows authentication, 337
local versus public Internet access, 336
login/password d344
virtuin; (semicolon) Structured Query Language (SQL) statement delimiter 831-832application distribution setup program, creating 1431application distribution setup program customization 1418-1419application distribution setup program, testing 1432-1436application distribution startup parameters 1402-1404applications, runtime Access features unavailable in runtime environment 1406applications, runtime startup options 1402-1404AutoCorrect feature 556CD-ROM, running Access features from 24CD-ROM with this book Picture Builder Button Sampler 1556CD-ROM with this book setup 64check box controls values returned 382, 403, 502command-line startup parameters 46-47, 1406connection SQL Server 2000 Desktop Engine connection setup 1123-1124, 1144data access pages (DAPs) interactive nature of 1185data, exporting HyperText Markup Language (HTML), page setup properties when exporting to 1198data, exporting overview of Access features 9-10data, importing Lotus spreadsheets 718, 722data, importing overview of Access features 9-10data, linking overview of Access features 9-10Database window startup options 1403databases opening at startup 46-47databases startup, opening at 46-47databases values, passing to at startup 47date operations current date, returning 334date operations difference between dates, returning 334date operations future dates, calculating 806-809date operations intervals, returning 334date operations portions of dates, returning 683-684date operations returning dates 333, 334, 672-673design conceptual phase 91dialog boxes values returned 936Edit êSave As Picture 483expressions property values, returning specified 341expressions syntax checking features 336fields Structured Query Language (SQL) statements, selecting for 814, 815, 817, 827, 828-831fields values, returning 746fields values, returning number of non-Null 746, 747fields values, returning totals 746, 754-755File êPage Setup 587Filter by Form feature 217, 244-245filtering Structured Query Language (SQL) statements, specifying in 827forms startup forms 47-48, 438, 455, 906, 1086-1087forms status bars 496functions random numbers, returning 333graphs overview of Access features 13-14graphs Structured Query Language (SQL) statements in 542Help systems, custom file structure 1371HyperText Markup Language (HTML) datasheets, page setup properties when exporting to 1198icons Access icon, specifying at startup 1086indexes Structured Query Language (SQL) statements affecting 813, 816-817Insert Picture dialog box 484, 524-525Insert êPicture êFrom File 1454Insert êPicture êFrom file 1375Insert Picture êViews êPreview 484Internet Explorer Web toolbar features 1181-1182Internet features overview 14-15list box controls items, returning number of 1036Lotus spreadsheets 692, 694, 718, 722macros running at Access startup 47-48, 906, 1086macros running on return to previous report section 952-953mailing labels punctuation 866margins Page Setup dialog box option 654mathematical operations count, returning 336mathematical operations depreciation return 335mathematical operations random numbers, returning 333mathematical operations Structured Query Language (SQL) functions 224menu bars startup, specifying at 1086menus, shortcut startup, allowing/disallowing at 1403menus, shortcut startup, specifying at 1086Microsoft Office AutoCorrect feature 556Microsoft Office voice recognition features 24Modify Object Status dialog box 1485Normalized Data Structure: A Brief Tutorial (Codd) 103/Nostartup command 47Object Linking and Embedding (OLE) overview of Access features 14On Click event property On Dbl Click mutually compatible with 1052option button controls values returned by 403Page Setup dialog box 587-588, 652-654, 871passwords startup options 46Picture Alignment property 439-440Picture Builder 504-505, 1063Picture Builder Add-On Picture Pack 1065,1411Picture Builder Button Sampler (on the CD) 1556Picture property 439, 525, 1065Picture Size Mode property 439, 488Picture Tiling property 440, 527Picture Type property 439, 525pictures See imagesprinters reports, setup for 440, 587-589, 651-654procedures command completion feature 977queries averages, returning 746, 752queries dynasets, dynamic nature of 273queries field highest value, returning 746, 824queries field lowest value, returning 746, 824queries field non-Null values, returning number of 746, 747queries field values from first record, returning 746queries field values from last record, returning 746queries field values, returning unique 824queries field values totals, returning 746, 754-755queries population variance, returning 746queries records, returning maximum number 825queries records, returning number of in 809-811queries records, returning top 272, 811-812, 830queries standard deviation, returning 746random numbers, returning 333records number of in query, returning 809-811records number of in table, returning 809-811records number of matching criterion, returning 810-811records queries, returning by top values 272, 811-812, 830records queries, returning maximum number 825records queries, returning number of in 809-811reports macros, running on return to previous section 952-953reports printer setup 440, 587-589, 651-654security forms, startup 1326security startup options 1328-1330Setup Wizard 1420, 1426sorting Structured Query Language (SQL) statements, specifying in 827, 831SQL Server 2000 Desktop Engine bootup, starting on 1120SQL Server 2000 Desktop Engine connection setup 1123-1124, 1144SQL statements See Structured Query Language (SQL) statementsstarting Access See also startup optionsStartup dialog box 47, 57, 1087startup options Access icon, specifying 1086startup options applications 1402-1404startup options bypassing 1314, 1330startup options command-line parameters 46-47, 1406startup options Database window display 1403startup options databases, opening 46-47startup options databases, passing values to 47startup options forms 47-48, 438, 455, 906, 1086-1087startup options keys, disabling/enabling 1404startup options macros, running 47-48, 906, 1086startup options menu bar 1086, 1403startup options menus 1403, 1404startup options runtime environment 1406startup options shortcut menu display 1403, 1404startup options Startup dialog box, hiding 47startup options status bar display 1086, 1403startup options title bar text, specifying 1086startup options toolbars 1086, 1404startup options user profile options 46startup options username/password options 46startup options Visual Basic (VBA) procedures, running 47Startup parameters dialog box 1402Startup properties window 906Status Bar Text property 496, 1106status bars 57, 213, 496, 1086, 1403status line messages 494Structured Query Language (SQL) statements See also specific statementsStructured Query Language (SQL) statements Active Server Pages (ASP), in 1202Structured Query Language (SQL) statements conditions, specifying 831-832Structured Query Language (SQL) statements creating in SQL view window 826Structured Query Language (SQL) statements database servers, sending commands to 813, 815-816Structured Query Language (SQL) statements ending 831-832Structured Query Language (SQL) statements field selection 814, 815, 817, 827, 828-831Structured Query Language (SQL) statements field values, eliminating duplicates 829-830Structured Query Language (SQL) statements filters, specifying 827Structured Query Language (SQL) statements financial functions 224Structured Query Language (SQL) statements FROM clauses 830-831Structured Query Language (SQL) statements graphs, in 542Structured Query Language (SQL) statements indexes, creating 813, 816-817Structured Query Language (SQL) statements indexes, dropping 813, 816-817Structured Query Language (SQL) statements Internet resources 832Structured Query Language (SQL) statements modifying 826Structured Query Language (SQL) statements ORDER BY clauses 827, 831, 1157Structured Query Language (SQL) statements queries, conversion to/from 826, 1021-1023Structured Query Language (SQL) statements queries, in 272, 356, 372-373, 813-817, 826-832Structured Query Language (SQL) statements query selection 830-831Structured Query Language (SQL) statements records, displaying based on top values 830Structured Query Language (SQL) statements sort order 827, 831Structured Query Language (SQL) statements stored procedures, in 1161Structured Query Language (SQL) statements subqueries 817Structured Query Language (SQL) statements table lookup properties, in 195Structured Query Language (SQL) statements table selection 827, 830-831Structured Query Language (SQL) statements viewing 826Structured Query Language (SQL) statements WHERE clauses 829-830, 831switchboards startup, loading at 1086tables copying structure 163tables records, returning number of in 809-811tables Structured Query Language (SQL) statements affecting 816tables Structured Query Language (SQL) statements, selection for 827, 830-831text, working with length of string, returning 335text, working with lowercase, returning 335text, working with rightmost characters of string, returning 335text, working with uppercase, returning 334time operations current time, returning 333, 334toggle button controls values returned 403, 502toolbars startup options 1086, 1404Tools êStartup 906Tools êStartup êApplication Title 58validation, data status line messages 494Visual Basic Application edition (VBA) startup, running VBA procedures at 47voice recognition features 24Yes/No data type values returned by 138, 382ctured Query Language (SQL) statements table lookup properties, in 195Structured Query Language (SQL) statements table selection 827, 830-831table relationships Find Unmatched queries 182table relationships joins, creating in queries 357-360, 803table relationships joins, deleting in queries 358, 360table relationships queries, creating in 174, 343-345, 349, 351-354, 357-360table relationships queries, overridden