Windows authentication for coldfusion 9 datasources

Let’s get into the topic right away.

Simple and straight forward steps on how to setup a Coldfusion 9  datasource with SQL Server 2008 in Windows Authentication mode.

Step 1:-  Go to Programs –>  Microsoft SQL Server 2008 R2 –>Configuration Tools –>SQL Server Configuration Manager.

Step 2: Enable the  TCP/IP protocol under SQL Server Configuration Manager > SQL Server Network Configurations > Protocols for SQLEXPRESS

Step 3: Now double-click the TCP/IP protocol to view the properties. Click on the IP Addresses tab and make sure that the TCP Port is set to 1433 for every IP type.

Step 4: Log in to CF9 Administrator and create a new datasource. While setting up the datasource give the Database name and datasource name the same. Give the server name as “localhost” and the port as your TCP/IP port.

Congratulations. You just  created a datasource that connects to a SQL Database with  Windows Authentication.

Command Line API in Firebug

Long time since I have made a  post. This time it is on one of my fav web development tool Firebug. It has got a cool command line API console for writing JavaScript commands that can be executed on the fly. This is particularly important when we debug large JavaScript code. We need to reload the js file each time after making any changes – which can be quite time consuming. Here is where command lines can be of great help.

There are two type of Command lines API:-

  1. One Line Command Line – This is the default command line. We can write a single line of JavaScript code here. Also it supports auto complete feature (i.e by hitting the tab key you can complete your js code just like other well known editors). After writing your code press enter. The code gets executed and you can see the execution details under the  console window. See highlighted area below.

2. Multi Lines Command Line – Here we can write and excute multipe lines of code on the fly. Write your js code and click Run button. The code gets excuted and you can see the execution details under the  console window. Firebug also provides a list of APIs to access the DOM element as well as to monitor and profile the javascript code that is getting executed. Typing these in the command line and executing helps us to  see what is the value of an HTML element,whether a function has been executed or not etc.

Firebug as always Roxx..  :-)

CF Admin glitch while Updating Scheduled tasks?

I faced an issue while working with scheduled tasks long back but though of blogging this now. If the interval specified while creating the task was more than 24 hours then we will not be able to update the task from Coldfusion Administrator.

So here we are creating the schedule task through code. Take a note of the interval.

<cfschedule action = “update”
task = “TaskName”
operation = “HTTPRequest”
startDate = “8/7/98″
startTime = “12:25 PM”
interval = “360000″
resolveURL = “Yes”
publish = “Yes”
file = “sample.html”
path = “c:\inetpub\wwwroot\playpen”
requestTimeOut = “600″>

The interval 360000 is like 100 hours.

Now log into the CF Administrator and try to update the task by changing the frequency to One Time.

The Admin throws error message saying that the interval must be less than one day.

The only way i see to update this schedule task is through code.

Is this a glitch of CF admin? I don’t know.

Security update for ColdFusion versions 9, 8.0.1, and 8 and a word of caution

A new security update for ColdFusion versions 9, 8.0.1, and 8 is available now. Important vulnerabilities have been identified for these versions that could lead to cross-site scripting and information disclosure. So an update is highly recommended.

But after taking updates it was reported that the update killed the datasources in the CF admin. After deleting shf8010001.jar from {CF_HOME}/lib/updates/ and restarting the ColdFusion service CF is up and running again. We are still waiting for Adobe to resolve this issue.

Google Chrome speed tests

With the release of new Chrome,  Google has shown how much importance they are giving for speed and performance. In fact they have gone ahead and compared the browser’s speed with real life objects.  - Just to show how fast the web page is being rendered (Yes that’s right  - loading at 2,700 frames per second!) . This is what Google has showed off:

FaceBook security hole…

Yesterday witnessed a  major security flaw in the social networking site facebook that, with just a few mouse clicks, enables any user to view the live chats of their ‘friends’. Using what sounds like a simple trick, a user can also access their friends’ latest pending friend-requests and which friends they share in common. See by yourself how “secure ” are our social sites:-

By the time I have finished this post  they would have fixed this bug(they better be!!!).

Customizing Ckeditor and adding a new toolbar button

It’s been a long time since i have put a blog entry. This time i will discuss how to customize a Ckeditor and how to  add new plugins(buttons in the toolbar) to the ckeditor. I got little help while googling. Hope this would be helpful.

Step 1: Download and install the Ckeditor js files. This link would get you setup a sample ckeditor in your local machine.

Step 2 : Customizing the toolbar:

We can specify which all toolbar buttons needs to be shown in our ckeditor. You can refer here for the toolbar definition.

Now we need to add a new button with a user defined functionality to our Ckeditor toolbar. In this example we are creating a button that wraps an anchor tag around a selected text inside the Ckeditor(same functionality as existing anchor button in the ckeditor).

Each button in the ckeditor toolbar is a plugin and their definitions are stored in ckeditor\plugins\ folder. In this folder we create a new folder with our plugin name. Here linkbutton. Inside the linkbutton folder we create a plugin.js file which contains the core functionality of the plugin/button.

It will contain the following code:-

//Section 1 : Code to execute when the toolbar button is pressed
var a= {
var theSelectedText = editor.getSelection().getNative();
//Section 2 : Create the button and add the functionality to it
label:’Link Button’,
icon: this.path + ‘logo_ckeditor.png’,
Note in the above code in Section 1  var a will contain the functionality to execute when the button is pressed. Here we are creating a coldfusion window and pass the selected text from the ckeditor. In Section 2 we create the button and add the functionality to it. We also give the path of the image that needs to be shown in the toolbar for the button. Here it is logo_ckeditor.png and is inside the linkbutton folder.
Next open the ckeditor/ckeditor.js file and search for ‘about‘ in the file. It will find a place where all the plugins are registered. Add your plugin name(here linkbutton) here.
UPDATE: Actually you don’t need to edit the ckeditor.js file as this will not work when a newer version comes. You can instead edit the config.js and add the plugin name there.
config.extraPlugins = ‘pluginX,pluginY,yourPluginNameHere’;
Go to this link for more reference.
Now open the ckeditor/config.js file and add your plugin name (here linkbutton) to the toolbar definition.
Note: The name given for the plugin should be consistent everywhere. The folder structure will look as below:-
That’s it!! We created a new plugin for our Ckeditor. For wrapping the anchor tag around the selected text we use the following code:-
function FormatEditorText()
var myEditor = CKEDITOR.instances.editor1;
var theSelectedText = document.getElementById(‘txtSelected’).value;
var theAnchorText = document.getElementById(‘txtAnchor’).value;
var FormattedText = ‘<a href=”‘+theAnchorText+’”>’+theSelectedText+’</a>’;
Helpful links :
I will post a live sample soon ;-).

Previous Older Entries


Get every new post delivered to your Inbox.