<cfstoredproc> - Executes a stored procedure in a server database. It specifies database connection information and identifies the stored procedure.
<cfstoredproc procedure="" datasource="" >
<cfprocparam cfsqltype="" value="">
Posted Date:- 2021-11-29 07:17:16
we can have multiple queries with union or union all. with out this if we use multiple queries system will execute only first query and it will not throw any error.
Posted Date:- 2021-11-29 07:16:34
No we cannot query multiple databases in one single query. we can query multiple databases in cftransaction with multiple cfquery statements.
Posted Date:- 2021-11-29 07:15:52
ArrayToList, ArrayAppend, ListLen, ListGetAt
Posted Date:- 2021-11-29 07:14:46
Geofencing is a location-based service that businesses use to engage their audience by sending relevant messages to smartphone users who enter a pre-defined location or geographic area.
Posted Date:- 2021-11-29 07:13:16
Ensures the integrity of shared data. Instantiates the following kinds of locks:
Exclusive - Allows single-thread access to the CFML constructs in its body. The tag body can be executed by one request at a time. No other requests can start executing code within the tag while a request has an exclusive lock. ColdFusion issues exclusive locks on a first-come, first-served basis.
Read-only - Allows multiple requests to access CFML constructs within the tag body concurrently. Use a read-only lock only when shared data is read and not modified. If another request has an exclusive lock on shared data, the new request waits for the exclusive lock to be released.
Posted Date:- 2021-11-29 07:12:20
SOAP stands for Simple Object Access Protocol whereas REST stands for Representational State Transfer. ... SOAP only works with XML formats whereas REST work with plain text, XML, HTML and JSON. SOAP cannot make use of REST whereas REST can make use of SOAP.
SOAP is a protocal, any webservice comes with wsdl it is a SOAP webservice else REST webservice.
Posted Date:- 2021-11-29 07:10:25
<cffile> tag is used to move,read,delete,copy,upload a file etc
<cffile action="upload" destination=""> - Copies a file to a directory on the server.
Posted Date:- 2021-11-29 07:09:22
For enterprise database management systems that support transaction processing, instructs the database management system to treat multiple database operations as a single transaction. Provides database commit and rollback processing. We can execute multiple databases queries in one cftransaction, but after every database query execution it has to be commited.
Posted Date:- 2021-11-29 07:08:50
Application.cfm is used to define the Application Management, Session Management, Client Management, Error Handling, Logging the errors to particular Log Files.
Application.cfm is used to set the application time out, session time out, client timeout etc.
We can have multiple Application.cfm files, Application.cfm that is in root folder will give first priority.
Posted Date:- 2021-11-29 07:07:57
cfinclude tag includes a part of code, cfc is set of functions which can be used as webservice.cfc has multiple entry points.
Posted Date:- 2021-11-29 07:06:53
cfmodule is used to call the custom tag and helps from name conflicts.
cf_xxx is used to call the custom tag.
Posted Date:- 2021-11-29 07:06:12
<cflocation template="/test/test.cfm">
cflocation tag stops the processing of page till the cflocation tag and redirects to the file placed in the template attribute(test.cfm).
Posted Date:- 2021-11-29 07:05:30
1) Sql Injection - cfqueryparam
2) Cross Site scripting - encodeforhtml,encodeforjavascript etc
3) Cross Site Request Forgery - generate crpf token and use it in your code and session. if match yes else no.
4) Encode Coldfusion Code
Posted Date:- 2021-11-29 07:04:38
A query that retrieves data from a record set is called query of queries. The typical use behind this concept is retrieve an entire table into memory with one query, and then access the record set with subsequent filtering and
sorting queries.
Benefits:
If we need to access the same tables multiple times, then we can reduce the access time, because the record set is already in memory. This is restricted to the memory of coldfusion host computer.
We can perform joins and unions operations on results from different data sources.
We can efficiently manipulate cached query results in different required
ways.
We can use this in report definitions to generate sub report data.
Posted Date:- 2021-11-29 07:02:40
ColdFusion structures consist of key-value pairs. Structures let you build a collection of related variables that are grouped under a single name. You can define ColdFusion structures dynamically. You can use structures to reference related values as a unit, rather than individually.
Posted Date:- 2021-11-29 07:01:56
Nth element - ListGetAt
count - ListLen
length - Len
For more list functions follow below reference.
Posted Date:- 2021-11-29 07:01:06
<cfoutput> tag is used to display the output. ex:- <cfouput>#query.variable#</cfoutput>
we can loop query with cfoutput. ex:- <cfoutput query="nameofthequery">#nameofthequery.variable#</cfoutput>Nested cfoutput - using cfoutput inside cfoutput is not possible, instead you can use cfloop inside cfoutput loop or you can use group attribute in the cfoutput.
Posted Date:- 2021-11-29 07:00:00
<cfwddx> tag is used to serialize and deserialize the wddx to xml and xml to wddx.
<cfwddx action="cfml2wddx" input="#MyQueryObject#" output="WddxTextVariable">
Posted Date:- 2021-11-29 06:59:24
By using the tags <cfdocument>,<cfdoumentitem>,<cfdocumentsection> we can generate a report in pdf.
Example:-
<cfdocument format="PDF">
<cfoutput>
Bacon ipsum dolor sit amet sirloin fatback #dateformat(now(), "short")#
</cfoutput>
</cfdocument>
Posted Date:- 2021-11-29 06:58:31
ColdFusion can deliver forms to the client in Flash (SWF file) format. ColdFusion automatically generates the Flash binary from your CFML code and displays it on the client. Flash forms are browser-independent.
Posted Date:- 2021-11-29 06:57:20
We can create tab strips using cflayout and cflayout area.
Posted Date:- 2021-11-29 06:56:53
cfobject create an object and call component, cfinvoke creates object and call component in same statement.
Posted Date:- 2021-11-29 06:56:24
For enterprise database management systems that support transaction processing, instructs the database management system to treat multiple database operations as a single transaction. It provides database commit and rollback processing. See the documentation for your database management system to determine whether it supports SQL transaction processing.
Syntax
1. <cftransaction
2. action = "begin|commit|rollback|setsavepoint"
3. isolation = "read_uncommitted|read_committed|repeatable_read"
4. savepoint = "savepoint name">
5. </cftransaction>
Posted Date:- 2021-11-29 06:55:59
Method 1:
view plaincopy to clipboardprint?
1. <cfinvoke>
2. <cfinvoke component="user" method="Get" returnvariable="usr">
3. <cfinvokeargument name="id" value="#id#">
4. </cfinvoke>
Method 2:
view plaincopy to clipboardprint?
1. <!--- Load CFC as an object --->
2. <cfobject component="user" name="userObj">
3. <!--- Invoke method --->
4. <cfinvoke component="#userObj#" method="Get" id="#id#" returnvariable="usr">
Method 3:
view plaincopy to clipboardprint?
1. <cfscript>
2. // Load CFC as an object
3. userObj=CreateObject("component", "user");
4. // Invoke method
5. user_id=userObj.Get(id);
6. </cfscript>
Posted Date:- 2021-11-29 06:53:58
A ColdFusion component (CFC) file contains data and functions that you define in related, multiple methods. You use CFC pages to organize related actions in one file, which provide can simplify your programming.
Posted Date:- 2021-11-29 06:52:29
ColdFusion Extension (CFX) tags are custom tags that you write in Java or C+. Generally, you create a CFX tag to do something that is not possible in CFML. CFX tags also let you use existing Java or C+ code in your ColdFusion application. Unlike CFML custom tags, CFX tags cannot have bodies or ending tags.
Posted Date:- 2021-11-29 06:51:31
In coldfusion we dont support method overloading(with different parameters). We support only Overriding.
Posted Date:- 2021-11-29 06:51:00
Create the .cfm which you want to convert to custom tag and call the file with cf_xxx(name of the .cfm file). Suppose you created the .cfm file with name test.cfm. you can call it as custom tag like <cf_test>.
Create a ColdFusion page(.cfm) which you want to convert to custom tag that shows the current date:
<cfoutput>#DateFormat(Now())#</cfoutput>
Save the file as date.cfm.
Create a ColdFusion page, the calling page, with the following content:
<html>
<head>
<title>Date Custom Tag</title>
</head>
<body>
<!--- Call the custom tag defined in date.cfm --->
<cf_date>
</body>
</html>
Save the file as callingdate.cfm.
View callingdate.cfm in your browser. This custom tag returns the current date in the format DD-MMM-YY.
Posted Date:- 2021-11-29 06:50:22
The differences are
Custom Tags:
-A single entry point is available for custom tags
-Custom tags does not support formalized parameter passing and validation mechanism
-Persistence is not possible for custom tags
-Custom tags are accessible locally and only by ColdFusion
ColdFusion Component:
-Multiple entry points are available for CFC
-CFC does support formalized parameter passing and validation mechanism
-Persistence is possible for CFC
-CFCs can be accessed as web services
Posted Date:- 2021-11-29 06:49:49
Following support Coldfusion to communicate
JMS
Mobile phones with support of SMS
XMPP or Lotus IM Clients
CMS and File systems
Java Socket Components
Posted Date:- 2021-11-29 06:48:41
We can use the cfimport tag to import either of the following:
All ColdFusion pages in a directory, as a tag custom tag library.
A Java Server Page (JSP) tag library. A JSP tag library is a packaged set of tag handlers that conform to the JSP 1.1 tag extension API.
<cfimport path = "the CFC namespace to import" prefix = "custom" taglib = "tag library location">
Posted Date:- 2021-11-29 06:48:19
Advantages :-
Query and Stored Procedure do the same thing but the difference is that a query should be compiled everytime the query is executed,while the stored procedure is in compiled form when executed first time.
Stored Procedure Results can be returned as a result set, or as an OUT parameter cursor.
Stored procedures can have parameters for both passing values into the procedure and returning values from the call.
Disadvantages :-
Only one dataset is allowed in a stored procedure
Can contain several statements, loops, IF ELSE, etc.
Posted Date:- 2021-11-29 06:47:37
One approach would be to generate the emails in timed batches to spread the load evenly. The batch size and delay between batches can be adjusted to suit your environment.
Posted Date:- 2021-11-29 06:45:08
cfmail - Sends email
cfmailparam - used for attachments
<cfmail from="rajamucharla5@gmail.com" cc="rajamucharla5@gmail.com" to="rajamucharla5@gmail.com">
<cfoutput>we are sending this to test the mail communication</cfoutput>
</cfmail>
Posted Date:- 2021-11-29 06:44:35
This tag supports the following types of loops:
cfloop: index loop.
cfloop: conditional loop.
cfloop: looping over a date or time range.
cfloop: looping over a query.
cfloop: looping over a list, a file, or an array.
cfloop: looping over a COM collection or structure.
Posted Date:- 2021-11-29 06:44:13
CFSET is used to set the value of a variable whether the variable is already defined or not. If the variable already has a value in it, CFSET will step on that value.
<cfset reportName = "QM Audits Summary Report">
CFPARAM should be used when you want to set the value of a variable only if it isn't already defined. It will assign a default value. It will initialize and/or define the datatype of a variable.
<cfparam name="reportName" default="" type="string">
Posted Date:- 2021-11-29 06:43:55
In the ColdFusion Administrator, select Data & Services > Data Sources.Under Add New Data Source, enter a data source name,Select a driver from the drop-down list; for example, Microsoft SQL Server.Click Add.
A form for additional DSN information appears. In the Database field, enter the name of the database.In the Server field, enter the network name or IP address of the server that hosts the database, and enter any required Port value and click Submit.
Posted Date:- 2021-11-29 06:43:28
Application Variables :-
Application Variables are used across the application as Global Variables. These are stored in server memory.
1. <!--- To delete all application variables--->
2. <cfset StructClear(Application)>
3. <!--- To delete a particular variable in session --->
4. <cfset StructDelete(Application, "varName")>
Session Variables :-
Session Variables are used across application as Global Variables. These are stored in server Memory. Session variables can store complex variables like structures and arrays. Client variables cannot store complex variables.
1. <!--- To delete all session variables --->
2. <cfset StructClear(Session)>
3. <!--- To delete a particular variable in session --->
4. <cfset StructDelete(Session, "varName")>
Posted Date:- 2021-11-29 06:43:04
The scope of a variable determines a number of properties about the variable, such as its life span, timeout, storage location and where it can be used. ColdFusion variables can be global or local, so accordingly the scopes are either persistent or non-persistent.
Posted Date:- 2021-11-29 06:42:12
Before CF6 MX coldfusion was implemented in Microsoft Visual C++.
CF6 MX
Coldfusion was rebuild by using JAVA EE platform.
CF 7 MX
- Addition of the Coldfusion Gateways
- Support for the MAC OS
- CFC
Coldfusion 8
- Few tags have been added and enhanced
CFPDF,CFPRESENTATION,CFZIP,CFEXCHANGE,CAPTCHA generation enhancement using CFIMAGE
Coldfusion 9
- New tags CFFINALLY,CFCONTINUE
- ORM like hibernate in JAVA
- Server.CFC file with onServerStart () and onServerEnd() methods
Coldfusion 10 (Zeus)
- Enhencements in Scheduler, webservices ,Security,HTML5,ORM features
Coldfusion 11 (Splendor)
- Mobile development and chart engine changes using Zing Chart previously it was using webChart engine for chart generation
- CFHTMLTOPDF
ColdFusion 2016 (Raijin)
* Command Line Interface (CLI)
* PDF generation enhancements
* Security enhancements
* External session storage (Redis)
* Swagger document generation
* NTLM support
* API Manager
ColdFusion 2018 (Aether)
* Asynchronous programming, using Futures
* Command line REPL
* Auto lockdown capability
* Distributed cache support (Redis, memcached, JCS)
* REST playground capability
* Modernized Admin UI
* Performance Monitoring Toolset
Posted Date:- 2021-11-29 06:41:54
When we have Application.cfm in root and child folders, root folder one will be given priority.
Posted Date:- 2021-11-29 06:39:54
Application.cfc and .cfc files are first introduced in CF MX 7.
Application.cfc is similar to Application.cfm which is used to set application management, session management,client management.
Application.cfm loads on top of every page, where as Application.cfc is executed function wise like
onApplicationStart
onSessionStart
onRequestStart
onRequest
onRequestEnd
onSessionEnd
onApplicationEnd
onError
So Performance wise Application.cfc is better than Application.cfm.
When there is Application.cfm and Application.cfc then Application.cfc is given preference.
Posted Date:- 2021-11-29 06:38:10
Application.cfm is used to define the Application Management, Session Management, Client Management, Error Handling, Logging the errors to particular Log Files.
Application.cfm is used to set the application time out, session time out, client timeout etc.
We can have multiple Application.cfm files, Application.cfm that is in root folder will give first priority.
Posted Date:- 2021-11-29 06:36:54
Mail Settings :-
In the ColdFusion Administrator, select Server Settings > Mail. In the Mail Server box, enter the name or IP address of your SMTP mail server. (Optional) Change the Server Port and Connection Timeout default settings. Select the Verify Mail Server Connection option to make sure ColdFusion can access your mail server.
Reference Link :- https://www.cfguide.io/coldfusion-administrator/settings-mail/
Debugging Settings :-
Before you can use the Debugger, enable debugging in the ColdFusion Administrator.
. In the ColdFusion Administrator, select Debugging & Logging > Debugger Settings.
. Enable the Allow Line Debugging option.
. Specify the port to use for debugging if different from the default that appears.
. Specify the maximum number of simultaneous debug session if different from the default.
. Click Submit Changes.
Reference Link :- https://helpx.adobe.com/coldfusion/developing-applications/developing-cfml-applications/using-the-coldfusion-debugger/set-up-coldfusion-to-use-the-debugger.html
Schedulers :-
We can Schedule a task from server settings -> Schedulers.
Reference Link :- https://www.cfguide.io/coldfusion-administrator/server-settings-scheduled-tasks/
Posted Date:- 2021-11-29 06:36:30
ColdFusion administrator is a web based application just like the Cpanel this has many sub options through which you can control many functions such as data sources, global server settings, debugging settings, Mail Settings, Sanabox Secuirty, Database Settings, Schedulers and application security settings. If you are having multiple administrator services then password must be provided for all those services. Also multiple user instances are provided where by a server can be split into cluster of Coldfusion administrators where a specific work can be provided to a specific individual who cannot alter changes.
Posted Date:- 2021-11-29 06:35:30
When a request comes to browser contacts webserver through HTTP, Webserver checks whether it is a normal html request or any other extension.
If it is normal html it will reply directly to web browser and display output,
If it is cfm extension webserver requests Application Server to check through TCP/IP.
Application Server Contacts Database through JDBC or FileSystem or Mail Server based on the requirement and pulls the data and send back to webserver.
Webserver Displays the Data on the Browser to user.
Posted Date:- 2021-11-29 06:35:14
ColdFusion is RAD(Rapid Application Development) Environment to develop the applications in faster phase than other technologies.
ColdFusion in PlatForm Independent. It runs on all operating systems
ColdFusion is Database Independent. It supports to all databases.
ColdFusion is Easy to learn and develop as it is a tag based language.
Posted Date:- 2021-11-29 06:34:51
ColdFusion is a platform like other technologies java and .net. It has multiple components like CFML(ColdFusion Markup Language) Programming Language, ColdFusion Administrator, CF Chart Engine, ColdFusion Application Server etc.
ColdFusion is a commercial rapid web-application development computing platform created by J. J. Allaire in 1995. (The programming language used with that platform is also commonly called ColdFusion, though is more accurately known as CFML.) ColdFusion was originally designed to make it easier to connect simple HTML pages to a database. By version 2 (1996), it became a full platform that included an IDE in addition to a full scripting language. Latest Version is Coldfusion 2018.
Posted Date:- 2021-11-29 06:34:27