Full HTML for

Basic foilset Web-Linked Database Cold Fusion Tutorial

Given by Chao Wei Ou at ARL Database Tutorial on February 98. Foils prepared 26 Jan 98
Outside Index Summary of Material

This describes Cold Fusion technology for linking databases with the Web
What and Why is ColdFusion?
Architecture
Features
Tag Language
Database and File Capabilities
Examples
Advanced Features

Table of Contents for full HTML of Web-Linked Database Cold Fusion Tutorial

 Denote Foils where Image Critical
Denote Foils where HTML is sufficient
1 Cold Fusion Web-Linked Database Technology
2 Abstract of Cold Fusion Presentation
3 What and Why is Cold Fusion?
4 Cold Fusion Application Server
5 Cold Fusion Major Features
6 Benefits from Cold Fusion
7 Fast Tag-based Programming Language
8 New Functions in Cold Fusion
9 Example: Dynamic Page Flow Control
10 Example: Arrays
11 HTTP Environment Variables
12 Re-Use Code
13 Powerful Database and File Integration
14 Database Integration
15 Example 1
16 Example 2
17 Advanced SQL
18 File Management
19 Crystal Reports
20 Cold Fusion Features
21 Cold Fusion Features
22 Cold Fusion - Sample Applications

Outside Index Summary of Material

HTML version of Basic Foils prepared 26 Jan 98

Foil 1 Cold Fusion Web-Linked Database Technology

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
Instructor: Nancy McCracken
Prepared by Chao Wei Ou
Syracuse University
NPAC
111 College Place
Syracuse NY 13244 4100
Phone: 3154432163
HTML version of Basic Foils prepared 26 Jan 98

Foil 2 Abstract of Cold Fusion Presentation

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
This describes Cold Fusion technology for linking databases with the Web
What and Why is ColdFusion?
Architecture
Features
Tag Language
Database and File Capabilities
Examples
Advanced Features
HTML version of Basic Foils prepared 26 Jan 98

Foil 3 What and Why is Cold Fusion?

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
Cold Fusion uses a page-based application architecture and powerful server-side markup language so it seamlessly integrates with HTML and existing Web technology.
Cold Fusion is significantly faster and more powerful than first generation CGI or Perl application development
With Cold Fusion, companies are creating cross platform applications in a variety of different areas:
  • Business Systems
  • Electronic Commerce
  • Collaborative Computing
  • Interactive Publishing
HTML version of Basic Foils prepared 26 Jan 98

Foil 4 Cold Fusion Application Server

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 26 Jan 98

Foil 5 Cold Fusion Major Features

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
Cold Fusion offers seven major areas of features:
  • Fast Tag-based Programing Language (CFML)
  • Powerful Database and File Integration
  • Integrated Support for Internet Technologies
  • Dynamic Java Forms
  • Complete Application Framework
  • Open Extensible Architecture High Performance Application Delivery
HTML version of Basic Foils prepared 26 Jan 98

Foil 6 Benefits from Cold Fusion

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
Cold Fusion provides many benefits to Web application development:
  • Rapid Application Development
  • Tight Technology Integration
  • Scaleable High Performance
  • Lower Development Costs.
  • True Cross Platform Deployment
  • Compatibility With Open Standards
HTML version of Basic Foils prepared 26 Jan 98

Foil 7 Fast Tag-based Programming Language

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
The server-side Cold Fusion Markup Language (CFML) provides a flexible environment for rapid application development.
CFML is based on tags, so it seamless integrates with HTML. CFML tags encapsulate complex server processes like database interaction or sending e-mail so you don't have to write complicated code.
At the same time, CFML offers all of the advanced development functionality you expect from an application programming environment. CFML gives you the ability to quickly develop and easily maintain sophisticated Web applications.
HTML version of Basic Foils prepared 26 Jan 98

Foil 8 New Functions in Cold Fusion

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
Array Functions
Date and Time Functions
Decision Functions
Display and Formatting Functions
Dynamic Evaluation Functions
List Functions
Mathematical Functions
Other Functions
String Functions
System Functions
Query Functions
Alphabetical List of Functions
HTML version of Basic Foils prepared 26 Jan 98

Foil 9 Example: Dynamic Page Flow Control

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
<CFIF expression> HTML and CFML tags
<CFELSE> HTML and CFML tags
</CFIF>
<CFLOOP INDEX="parameter_name FROM="beginning_value"TO="ending_value"STEP="increment">
<!-- HTML or CFML code to execute -->
</CFLOOP>
HTML version of Basic Foils prepared 26 Jan 98

Foil 10 Example: Arrays

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
<CFSET mynewarray = ArrayNew(x)>
Example:
  • <CFSET mynewarray[3] = Form.emailaddress>
Multi-Dimensional Array:
  • <CFSET myotherarray = ArrayNew(2)>
  • <CFSET biggerarray = ArrayNew(3)>
  • <CFSET biggerarray[1][1][1] = myarray>
  • <CFSET biggerarray[1][1][1][10] = some_value>
  • <CFSET biggerarray[2][1][1] = myotherarray>
  • <CFSET biggerarray[2][3][2][4][2] = some_value>
HTML version of Basic Foils prepared 26 Jan 98

Foil 11 HTTP Environment Variables

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
URL Accessing
  • <A HREF="example.cfm?user_id=5&color=blue">
Form Accessing
  • <FORM ACTION="example.cfm" METHOD="post">
  • <INPUT TYPE="Hidden" NAME="Customer_ID" VALUE="24">
  • <INPUT TYPE="Submit" VALUE="Enter">
  • </FORM>
CFCookies
  • <CFCOOKIE NAME="User_ID" VALUE="2344" EXPIRES="100">
CGI Environments - CGI.varname
varname:SERVER_NAME, SERVER_PROTOCOL, SERVER_PORT, etc.
HTML version of Basic Foils prepared 26 Jan 98

Foil 12 Re-Use Code

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
CFINCLUDE
  • <CFINCLUDE TEMPLATE="template_name">
  • Use CFMODULE to invoke a custom tag for use in your Cold Fusion application pages.
CFMODULE can help deal with any custom tag name conflicts that might arise.
  • <CFMODULE TEMPLATE="template"
  • NAME="tag_name"
    • ATTRIBUTE="value"
  • ATTRIBUTE="value" ...>
Custom CFML Tags
HTML version of Basic Foils prepared 26 Jan 98

Foil 13 Powerful Database and File Integration

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
High level support for database and file system interactions frees you to create everything from simple dynamic pages to powerful database Web applications.
Connect your applications to any ODBC compliant relational database including Microsoft Access, SQL Server, Oracle and many others. Use advanced functionality including any SQL statement, stored procedures, transaction processing, and dynamically built SQL queries.
Easily add file uploading and file management capabilities to your applications. Intelligently index and search content in text files and relational databases with the embedded full text searching technology from Verity.
HTML version of Basic Foils prepared 26 Jan 98

Foil 14 Database Integration

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
Selecting Data:
  • <CFQUERY NAME="query_name"
  • DATASOURCE="ds_name"
  • USERNAME="username"
  • PASSWORD="password"
  • MAXROWS="number"
  • TIMEOUT="milliseconds"
  • DEBUG="yes/no">
  • SQL statements
  • </CFQUERY>
HTML version of Basic Foils prepared 26 Jan 98

Foil 15 Example 1

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
<CFQUERY NAME="EmployeeList"
  • DATASOURCE="CompanyDB">
SELECT * FROM Employees
</CFQUERY>
Displaying data:
  • <CFOUTPUT QUERY="queryname"
  • MAXROWS=n >
  • Literal text, HTML tags, and dynamic field references (e.g. #FullName#)
  • </CFOUTPUT>
HTML version of Basic Foils prepared 26 Jan 98

Foil 16 Example 2

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
<CFOUTPUT QUERY="EmployeeList">
<HR>
#FirstName# #LastName# (Phone: #PhoneNumber#) <BR>
</CFOUTPUT>
<HR>
John Smith (Phone: 507-452-7224) <BR>
<HR>
Deborah Jones (Phone: 612-227-1019) <BR>
<HR>
Frank Wilson (Phone 612-831-9555) <BR>
HTML version of Basic Foils prepared 26 Jan 98

Foil 17 Advanced SQL

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
Select one or more companies to get more information on:
  • <SELECT Name="SelectEmp" MULTIPLE>
  • <OPTION VALUE="'Staff'">Staff
  • <OPTION VALUE="'Student'">Student
  • </SELECT>
  • <INPUT type="hidden" NAME="SelectedEmp_required"
  • VALUE="You must select at least one category.">
In other CFM page includes the following SQL statement
  • SELECT * FROM Organizations
  • WHERE OrganizationName IN (#PreserveSingleQuotes(SelectedEmp)#)
Actual statement to be sent to database:
  • SELECT * FROM Organizations
  • WHERE OrganizationName IN (`Staff','Student')
HTML version of Basic Foils prepared 26 Jan 98

Foil 18 File Management

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
CFFILE
  • <CFILE ACTION="action", ...>
  • action includes UPLOAD, WRITE, MOVE, COPY, RENAME, etc.
Example
  • <CFFILE ACTION="UPLOAD"
  • FILEFIELD="UploadFile"
  • DESTINATION="c:\uploads\MyImage.GIF"
  • NAMECONFLICT="OVERWRITE"
  • ACCEPT="image/gif, image/jpeg">
HTML version of Basic Foils prepared 26 Jan 98

Foil 19 Crystal Reports

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
<CFREPORT REPORT="report_path"
ORDERBY="result_order"
USERNAME="username"
PASSWORD="password">
</CFREPORT>
Example
<CFREPORT REPORT="#GetDirectoryFromPath(CF_TEMPLATE_PATH) #EMPLOYEES.rpt">
{Employees.Department} IN "#FORM.Departments#"
</CFREPORT>
HTML version of Basic Foils prepared 26 Jan 98

Foil 20 Cold Fusion Features

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
Integrated support for Internet Technologies
  • Send E-mail (SMTP)- CFMail
  • Retrieve E-mail(POP)- CFPop
  • HTTP Support- CFHTTP
  • LDAP Support- CFLDAP
Dynamic Java Forms
  • Dynamic Java Forms- CFForm, CFTextInput, CFSlider, CFTree, etc.
  • Data Entry Validation- Form Validation, InputValidation
  • Content Type Control- CFContent
HTML version of Basic Foils prepared 26 Jan 98

Foil 21 Cold Fusion Features

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
Complete Application Framework
Web Server Security Integration
Client State Management - CFCookie
Application Framework - CFApplication, CFParam
Customize Error Messages - CFError
Extensive Debugging Information
Open Extensible Architecture
Custom Tags - CFModule, Encrypting Custom Tags
ActiveX Server Components (COM) - CFObject
Open API - CFXs
HTML version of Basic Foils prepared 26 Jan 98

Foil 22 Cold Fusion - Sample Applications

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. *
Full HTML Index
Commerce - http://www.allaire.com/products/coldfusion/30/Example/ ExtranNar.cfm
Business Systems - http://www.allaire.com/products/coldfusion/30/Example/ Intranar.cfm
Interactive Publishing -http://www.allaire.com/products/coldfusion/30/Example/ HealthSearchnar.cfm
Other Cold Fusion Sites - http://www.allaire.com/products/coldfusion/30/sites.cfm
© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Mon Jan 26 1998