COLDFUSION by ARVIND SONI NITIN SHARMA ANUJ SHARMA

COLDFUSION by ARVIND SONI NITIN SHARMA ANUJ SHARMA GAURAV BAMANIA VISHAL JAIN 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 1

What is coldfusion? • § • The Cold. Fusion Web application server provides the fastest way to integrate browser, server, and database technologies into powerful Web applications and interactive Web sites. Cold. Fusion templates, look surprisingly similar to standard HTML pages, but the difference is that you can create a single template and serve up tons of information dynamically rather than having to create a separate page for every item. Cold. Fusion applications rely on these core development components: The Cold. Fusion Markup Language (CFML) Cold. Fusion Server Cold. Fusion Administrator 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 2

CFML § The Cold. Fusion Markup Language (CFML) consists of a set of tags you use in your Cold. Fusion pages to interact with data sources, manipulate data, and display output. § Cold. Fusion Express supports a subset of CFML. Using CFML tags is very simple; tag syntax is much like HTML element syntax. lets examplify and look into the tags and functions provided by CFML 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 3

CFML example <HTML> <HEAD> <TITLE>Array. Append Example</TITLE> </HEAD> <BODY> <H 3>Array. Append Example</H 3> <CFQUERY NAME="Get. Employee. Names" DATASOURCE="HRApp"> SELECT First. Name, Last. Name FROM Employees </CFQUERY> <! Simplicity of expressing the query > 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 4

<CFSET my. Array=Array. New(1)>  <CFSET my. Array[1]="Test Value">  <CFLOOP query="Get. Employee. Names"> <CFOUTPUT>#Array. Append(my. Array, "#First. Name# #Last. Name#")# </CFOUTPUT>, Array was appended </CFLOOP> 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 5

<CFSET my. List=Array. To. List(my. Array, ", ")>  <CFOUTPUT> The contents of the array are as follows: #my. List# </CFOUTPUT> </BODY> </HTML> 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 6

In the above eg. CFQUERY passes the query name "Get. Employee. Names" to be applied to datasource “Hrapp” CFLOOP has several forms --loop based on condition --loop on index --loop on query (used in above eg. ) Note the syntax for usage of function ‘Array. Append ‘ which takes 2 args arrayname and value to be appended coldfusion talk by vishal, anuj 10/15/2021 , arvind , nitin, gaurav 7

variables Type Scope Reference prefix Query Page in which declared Queryname. varname Local Page in which declared Variable. Cgi All sessions CGI. url Target page URL Form Action page Form. Cookie All browser sessions Cookie. 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 8

CFML TAGS CFABORT Stops processing of a Cold. Fusion page at the tag location. CFAPPLICATION Defines application name and activates client variables. CFBREAK Breaks out of a CFML looping construct. CFCOOKIE Defines and sets cookie variables. CFIF CFELSE Used to create IF-THEN-ELSE constructs. 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 9

CFML TAGS (conti…) CFINCLUDE Embeds references to Cold. Fusion pages. CFINSERT Inserts records in an ODBC data source. CFLOCATION Opens a Cold. Fusion page or HTML file. CFLOOP Repeats a set of instructions based on set of conditions. CFPARAM Defines a parameter and its initial default value. 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 10

CFML TAGS (conti…) CFOUTPUT Displays output of database query or other operation CFQUERY Passes SQL to a database. CFSET Defines a variable. CFSETTING Define and control a variety Cold. Fusion settings. 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 11

CFML TAGS (conti…) CFSWITCH CFCASE CFDEFAULTCASE Evaluates a passed expression and passes control to the CFCASE tag that matches the expression result. CFUPDATE Updates rows in a database data source 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 12

CFML FUNCTIONS l l l 10/15/2021 Array Functions Date and Time Functions Decision Functions Display and Formatting Functions Dynamic Evaluation Functions List Functions Mathematical Functions Query Functions String Functions Structure Functions System Functions coldfusion talk by vishal, anuj , arvind , nitin, gaurav 13

Cold fusion server § When any Cold. Fusion Server is installed on a Web server: The Web server passes files to Cold. Fusion Server if a page request contains a Cold. Fusion file extension. § Cold. Fusion Server scans the page and processes all CFML tags. Cold. Fusion Server then returns only HTML and other client-side technologies to the Web server and, in turn, the browser. 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 14

COLDFUSION ADMINISTRATOR You use the Administrator to perform a variety of administrative tasks for the Cold. Fusion Server, such as adding and configuring a data source and configuring security settings. 2. During the Cold. Fusion installation process, you specify an Administrator password that is used to prevent unauthorized access to the Administrator pages. 3. Open the administrator by loading the following URL: http: //hostname/CFIDE/administrator/index. cf m 1. 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 15

The admin facilities include. . Starting and Stopping Cold. Fusion The Settings Page Configuring Administrator Security Mapping Directories The Cold. Fusion Logging Page Cold. Fusion Administrator Debugging Options 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 16

CONCLUSION There are lot more facilities which assist in § Cold. Fusion Studio helps in developing templates. § building search interfaces for database § building webfront ends for online database manipulation. 10/15/2021 coldfusion talk by vishal, anuj , arvind , nitin, gaurav 17