WIXLIB

coldfusion#coldfusion

Table of ContentsAbout1Chapter 1: Getting started with coldfusion2Remarks2Versions2Examples3Installation or SetupLinux (Ubuntu) InstallationLucee (Open Source)333ColdFusion / CFML Interpretor3Nginx3Adobe (Closed Source)4ColdFusion / CFML Interpretor4Nginx4Hello World5Chapter 2: CFLOOP How-To7Remarks7Examples7Looping through a collection using CFML tags.7Looping through a collection using CFSCRIPT.7Index7Parameters7Basic index loop8Increase step to 28Decrement step by 19CFLoop in a Function9ColdFusion 11 through currentConditionTag syntax101010Parameters10Generated HTML10

CFScript10Previous to ColdFusion 811ColdFusion 8 through current11ColdFusion 11 through current11Generated HTML11Date or time range11Query11Parameters11Example queryTag syntax1212Generated HTML12Limiting output to specific rows13Grouping Output13CFScript14ColdFusion 6 (MX) though current15ColdFusion 8 though current15ColdFusion 10 though current15ColdFusion 11 though current15List16Tag syntax16Parameters16Generated HTML16CFScript16Previous to ColdFusion 816ColdFusion 8 through current17ColdFusion 9 through current17ColdFusion 11 through current17Generated HTML17Array17Tag syntax17ColdFusion 8 through current17

Parameters18Generated HTML18ColdFusion 2016 through current18ParametersGenerated HTMLCFScript181919Previous to ColdFusion 819ColdFusion 8 through current19ColdFusion 9 through current19ColdFusion 11 through current19Generated HTML19File20Structure20Tag syntax20Parameters20Using Structure Functions20Implicit Structure Syntax20Generated HTML21CFScript21Output the structure's keys21Generated HTML21Output the value of the structure's keys21Using Structure Functions21Implicit Structure Syntax21ColdFusion 11 through current22Generated HTML22Index Loop22Conditional Loop22Query Loop22List Loop23File Loop23COM Collection/Structure Loops23

Chapter 3: cfquery24Parameters24Examples24Using cfquery within a Function24Query of Query24Function Calls24User.cfc24Chapter 4: ColdFusion ating Arrays26Creating arrays explicitly using ArrayNew()26History26Declaration26Using ArrayAppend()27Creating 1-D Array Implicitly28Create 2-D Array Implicitly29Array in CFScriptSimilarly, for 2 Dimension Array:General informationChapter 5: Creating REST APIs in coldfusion30313132Introduction32Examples32Creating backend32The interface32Chapter 6: Database QueriesExamples3333Working with databases33Basic Example33

Authentication34Cached Queries34Limiting the Number of Records Returned35Timeouts35Chapter 7: How to invoke a private method dynamically36Remarks36Examples36CFML36CFSCRIPT (CF10 )36Chapter 8: Scopes in Coldfusion37Introduction37Examples37Request Scopes37Global Scopes37Components and functions37Custom tags37Common scopes38Overview38Chapter 9: Variables39Parameters39Examples39Using cfset39Using cfparam39Checking if a Variable Exists40Setting a variable scope40Chapter 10: Working with RegExp Replace ples42User defined REReplaceCallback function43Using REReplaceCallback function43

Credits44

AboutYou can share this PDF with anyone you feel could benefit from it, downloaded the latest versionfrom: coldfusionIt is an unofficial and free coldfusion ebook created for educational purposes. All the content isextracted from Stack Overflow Documentation, which is written by many hardworking individuals atStack Overflow. It is neither affiliated with Stack Overflow nor official coldfusion.The content is released under Creative Commons BY-SA, and the list of contributors to eachchapter are provided in the credits section at the end of this book. Images may be copyright oftheir respective owners unless otherwise specified. All trademarks and registered trademarks arethe property of their respective company owners.Use the content presented in this book at your own risk; it is not guaranteed to be correct noraccurate, please send your feedback and corrections to info@zzzprojects.comhttps://riptutorial.com/1

Chapter 1: Getting started with coldfusionRemarksThis section provides an overview of what coldfusion is, and why a developer might want to use it.It should also mention any large subjects within coldfusion, and link out to the related topics. Sincethe Documentation for coldfusion is new, you may need to create initial versions of those relatedtopics.VersionsVersionRelease DateCold Fusion version 1.01995-07-02Cold Fusion version 1.51996-01-01Cold Fusion version 2.01996-10-01Cold Fusion version 3.01997-06-01Cold Fusion version 3.11998-01-01ColdFusion version 4.01998-11-01ColdFusion version 4.5.11999-11-01ColdFusion version 5.02001-06-01ColdFusion MX version 6.02002-05-01ColdFusion MX version 6.12003-07-01ColdFusion MX 72005-02-07ColdFusion 82007-07-30ColdFusion 92009-10-05ColdFusion 102012-05-15ColdFusion 112014-04-29ColdFusion 20162016-02-16https://riptutorial.com/2

ExamplesInstallation or SetupLinux (Ubuntu) InstallationLucee (Open Source)ColdFusion / CFML InterpretorDownload the appropriate file from their site (http://lucee.org/downloads.html) and execute theirinstallerwget cee-5.0.0.252-pl0-linux-x64installer.runsudo chmod x lucee-5.0.0.252-pl0-linux-x64-installer.runsudo ./lucee-5.0.0.252-pl0-linux-x64-installer.runStep through installer.NginxInstall Nginx on your serversudo apt-get install nginxEdit your /etc/nginx/sites-available/defaultserver {listen 80;server name ;root /opt/lucee/tomcat/webapps/ROOT;index index.cfm index.html index.htm;#Lucee Admin should always proxy to Luceelocation /lucee {include lucee.conf;}#Pretty URLslocation / {try files uri /index.cfm uri? is args args;include lucee.conf;}location \.cfm {include lucee.conf;}https://riptutorial.com/3

location \.cfc {include lucee.conf;}}Edit /etc/nginx/lucee.confproxy pass http://127.0.0.1:8888;proxy set header Host http host;proxy set header X-Real-IP remote addr;proxy set header X-Forwarded-For proxy add x forwarded for;proxy set header X-Forwarded-Proto scheme;Reload nginxsudo service nginx reloadAccess the Lucee Server admin 888/lucee/admin/server.cfmYour root web directory lives here:/opt/lucee/tomcat/webapps/ROOTAdobe (Closed Source)ColdFusion / CFML InterpretorDownload the appropriate file from their site d-trial/try.html) and execute their installerwget URL /ColdFusion 2016 WWEJ linux64.binsudo chmod x ColdFusion 2016 WWEJ linux64.binsudo ./ColdFusion 2016 WWEJ linux64.binStep through installer. Make sure you select the internal web server (port 8500)NginxInstall Nginx on your serversudo apt-get install nginxhttps://riptutorial.com/4

Edit your /etc/nginx/sites-available/defaultserver {listen 80;server name ;root /opt/coldfusion2016/cfusion/wwwroot;index index.cfm index.html index.htm;location / {try files uri uri/ 404;}location /CFIDE/administrator {deny all;}location * \.(cfm cfml cfc html) {include /etc/nginx/conf/dc tomcat connector.conf;}location /rest {include tomcatconf;}}Edit /etc/nginx/tomcat.confproxy pass http://127.0.0.1:8500;proxy set header Host host;proxy set header X-Forwarded-Host host;proxy set header X-Forwarded-Server host;proxy set header X-Forwarded-For http x forwarded for;proxy set header X-Real-IP remote addr;Reload nginxsudo service nginx reloadAccess the Adobe ColdFusion Server admin our root web directory lives here:/opt/coldfusion2016/cfusion/wwwrootHello WorldFile: test.cfmTag Implementationhttps://riptutorial.com/5

cfoutput Hello World! /cfoutput CFScript Implementation cfscript writeOutput("Hello World!"); /cfscript Read Getting started with coldfusion online: ngstarted-with-coldfusionhttps://riptutorial.com/6

Chapter 2: CFLOOP How-ToRemarksBig thanks to Pete Freitag for his CFScript Cheat Sheet Adam Cameron for CF 11: CFLOOP in CFScript is Very Broken (and it still is in CF 2016).ExamplesLooping through a collection using CFML tags. !--- Define collection --- cfset attributes {"name": "Sales","type": "text","value": "Connection"} !--cfloop tag with attribute collection can be used toloop through the elements of a structure--- cfloop collection #attributes# item "attribute" cfoutput Key : #attribute#, Value : #attributes[attribute]# /cfoutput /cfloop Looping through a collection using CFSCRIPT. cfscript /*define collection*/attributes {"name": "Sales","type": "text","value": "Connection"};for(attribute in attributes){/* attribute variable will contain the key name of each key value pair in loop */WriteOutput('Key : ' & attribute & ', Value : ' & attributes[attribute] & ' br/ ');} /cfscript IndexParametershttps://riptutorial.com/7

e name for the loop's index. Defaults tothe variables scope.fromtruenumericStarting value for the index.totruenumericEnding value for the index.stepfalsenumeric1DescriptionValue by which to increase or decrease theindex per iteration.Basic index loopFinal value of x is 10. !--- Tags --- cfoutput cfloop index "x" from "1" to "10" li #x# /li /cfloop /cfoutput !--- cfscript --- cfscript for (x 1; x 10; x ) {writeOutput(' li ' & x & ' /li ');} /cfscript !--- HTML Output --- - 1- 2- 3- 4- 5- 6- 7- 8- 9- 10Increase step to 2Final value of x is 11. !--- Tags --- cfoutput cfloop index "x" from "1" to "10" step "2" li #x# /li /cfloop /cfoutput !--- cfscript --- cfscript for (x 1; x 10; x 2) {https://riptutorial.com/8

writeOutput(' li ' & x & ' /li ');} /cfscript !--- HTML Output --- - 1- 3- 5- 7- 9Decrement step by 1Final value of x is 0. !--- Tags --- cfoutput cfloop index "x" from "10" to "1" step "-1" li #x# /li /cfloop /cfoutput !--- cfscript --- cfscript for (x 10; x 0; x--) {writeOutput(' li ' & x & ' /li ');} /cfscript !--- HTML Output --- - 10- 9- 8- 7- 6- 5- 4- 3- 2- 1CFLoop in a FunctionMake sure to var or local scope the index inside a function. Foo() returns 11. !--- var scope --- cffunction name "foo" access "public" output "false" returntype "numeric" cfset var x 0 / cfloop index "x" from "1" to "10" step "1" cfset x / /cfloop cfreturn x / /cffunction !--- Local scope --- cffunction name "foo" access "public" output "false" returntype "numeric" cfloop index "local.x" from "1" to "10" step "1" cfset local.x / https://riptutorial.com/9

/cfloop cfreturn local.x / /cffunction ColdFusion 11 through currentThe cfscript function cfloop has no support for index as a stand alone countermechanism.ConditionTag stringDefaultDescriptionCondition that manages the loop. Cannot containmath symbols like , or . Must use ColdFusiontext implementations like less than, lt, greater than, gt, equals or eq.Final value of x is 5. cfset x 0 / cfoutput cfloop condition "x LT 5" cfset x / li #x# /li /cfloop /cfoutput Generated HTMLThis will also have a line break between each line of HTML. li 1 /li li 2 /li li 3 /li li 4 /li li 5 /li CFScripthttps://riptutorial.com/10

Previous to ColdFusion 8 cfscript x 0;while (x LT 5) {x x 1;writeOutput(' li ' & x & ' /li ');} /cfscript ColdFusion 8 through current cfscript x 0;while (x LT 5) {x x ;writeOutput(' li ' & x & ' /li ');} /cfscript ColdFusion 11 through currentThe cfscript function cfloop has no support for condition.Generated HTMLNotice that the cfscript output is all on one line. li one /li li two /li li three /li li four /li Date or time rangeExample for date or time range.QueryConsider the table dbo.state zip, which contains the columns city, statecode and zipcode and hasover 80,000 ringThe variable name of a query object.startrowfalsenumericThe starting row index of the query 1