Coldfusion has a beautiful feature called Query of Queries which is mainly used for improving performance of the application.
Query of Queries is the result of an existing database query result.
This will be done by using coldfusion “cfquery” tag and need to specify dbtype = ‘query’.
where ColumnName = 'SomeValue'
Coldfusion provides us many debugging options in order to trouble shoot a coldfusion program.
The important are:
CFDUMP, eg: <cfdump var="#abcd#">
CFABORT, eg: <cfabort>
On the debugging settings in coldfusion administrator. (you will see the lengthy debugging information at the bottom of the coldfusion result).
By using coldfusion <cfftp> tag, we can send data from local computer to the server and also retrieve the data from server to the local computer.
By using Get file, we can retrieve data from server:
By usingPut file, we can send data to the server:
While debugging is mainly used to debug the code and to see run time values. Especially for trouble shooting. How ever, once the programs are in production server, we can not debug, but to avoide users seeing all the error messages when a program unexpectedly failed and throwing errors, we can use error handling methods.
TRY and CATCH is the best among them to handle any database related errors.
Here is your actual code…of coldfusion….
Write your message to the user in case of any error.
i.e basically we are packaging our code using cftry and cfcatch tags.