Category

Programming

Use a LIKE statment on SQL Server XML Datatype

MSSql not allow you to search the XML datatype using the Like keyword, the following is the sample query to allow you to convert your XML datatype data into string, after that you can utilize the MSSql build in string function to query for your data. SELECT * FROM (SELECT…

Salary guidelines of IT professionals in Malaysia

  Do you wondering how much an IT related field people worth? How much the market rate for a employees who are working in an IT company in Malaysia are being paid? Are you an employee? Always wondering what kind of salary you should deserve? A special thanks to Johnson Tan,…

Refreshing Coldfusion Web Service WDSL

Using web service is one of the good solution when you try to consume 3th party or integrate your system with other system without knowing how their internal logic. When you try to call the web service for the first time, CF actually will chace the web service by using…

ColdFusion: ValueList Query to Array List

The most easy way to convert ColdFusion query column to array tech.david-cheong.com There are few ways to do the same thing, you may query out the data from the Database using query, than loop through all the row in the result set and append the item one by one. But…

ColdFusion 10 Server Lockdown Guide

The server lockdown guide for ColdFusion 10 is now available on the Adobe website. The ColdFusion 10 Server Lockdown Guide will help server administrators secure their ColdFusion 10 installations. You will also find several tips and suggestions intended to improve the security of your ColdFusion server.   [download id=”31″]

Merging Two Structs in ColdFusion

The following script showing how to merge 2 ColdFusion structure into one. The following sample showing 2 difference structure which each has two keys tech.david-cheong.com tech.david-cheong.com Notice the commented out version. That is the underlying method to do the same thing as StructAppend. tech.david-cheong.com

ColdFusion 8 Ajax Features Overview

Special thanks for Scott Bennett who is the author of this article, in the article he summarize the CF8 ajax features which is pretty easy to understand the full picture of what CFAjax and provide/do for you.   Enjoy and happy learning.   [download id=”27″]

Looping through A to Z in ColdFusion

There are always more than single methods to accomplish the same job in programming language. To loop through the letters from A to Z in ColdFusion there are also more than one way, but I personally found out the following 2 methods are simpler and strain forward.   Hardcode the…

Looping over ColdFusion Structure

The following are the reference and sample code on how to loop over a structure without knowing its keys.   <cfset testStruct = structnew() /> <cfset testStruct.key1 = "test1" /> <cfset testStruct.key2 = "test2" /> <cfset testStruct.key3 = "test3" /> <cfdump var="#testStruct#" /> <cfloop list="#structKeyList(testStruct)#" index="key"> <cfoutput> Key: #key#, Value:…

Online Web Tools – Webmaster tools for everyone

Online Web Tool is a comprehensive web site for all webmaster that needed such as SEO tools, Domain tools, coding tools, website analysis and stats, etc.   As this is a web tools, there is no any download or installation needed to use it, the most important part is all…