Technical Forum

For fixing cyrillic character issues, we can use the ways given below: way 1:  Keep <cfprocessingdirective pageenc oding = "utf-8"> line so that issue will get resolved. For example, <cfcomponent displayname="testCyrillic" hint="Replace special characters"> <!---To Fix Cyrillic character issue : starts---> <cfprocessingdirective pageencoding = "utf-8"> Way 2:  Create jdbc datasource and add use Unicode=yes&charactorEncoding=UTF-8 with JDBC URL. Driver class as usual:  com.mysql.jdbc.Driver For example, jdbc:mysql:// localhost:3306/mySite? useUnicode=yes& charactorEncoding=UTF-8

For creating password protected PDF documents, we can use the tag <cfdocument> with attributes userpassword,encryption . For example, the below code will create a PDF document which is protected by a password 'password'. <cfdocument format="PDF"  userpassword="password" encryption="128-bit">     <cfdocumentsection>         This document is password protected     </cfdocumentsection> </cfdocument>

For finding the execution time of particular code blocks, we can use the ColdFusion function GetTickCount().  Without enabling the debugging information in the Administrator, we ca use the metho d GetTickCount() for finding the time used for executing a partcul ar code block. For example,  <cfset t1 = GetTickCount()> code block begin s.. ------------------------------------- code bloc k ends. <cfset  t2= GetTickCount()> <cfset t otal=t2-t1> <cfoutput> Time take n for execution was #total#</cfoutput >    

<cfscript> adminObj = createObject("component","cfide.adminapi.administrator"); createObject("component","cfide.adminapi.administrator").login("CF admin password"); myObj = createObject("component","cfide.adminapi.datasource"); </cfscript> <cfdump var="#myObj.getDatasources()#">

To find the mappings in the server, we can use the following code.     <cfset  mappings = StructNew()>     <cfset ServiceFactory = createObject("java","coldfusion.server.ServiceFactory")>         <cfset mappings = ServiceFactory.runtimeService.getMappings()>        <cfdump var="#mappings#">

For validating a required input field for blank space, we can use the attribute 'Validate="noblanks"  in the cfinput tag. For example, <cfform name="test" method="post" action="" > Name:<cfinput type="text" name="firstname"  required="yes" validate="noblanks"  message="Please Enter Your firstname"> <cfinput type=" submit" name="submit" value="Submit"> </cfform>

If we have a table 'account' with fields 'accountid' and 'balance', 1. Query to find highest balance from 'account' is:  select balance from account order by balance desc limit 0,1; 2.  Query to find second highest balance from 'account' is:    select balance from account order by balance desc limit 1,1;   3.  Query to find third highest balance from 'account' is: select balance from account order by balance desc limit 2,1;