Man..

I’am wasting my time using coldfusion. One month in Balikpapan from the plan of two weeks. There are a lot of something that is easy to be programmed with PHP but not so in CF. There are a lot of bunch to be added to the script to make a good layouting from database retrieving.

The most problem I faced, when I query with “IN” condition, such:

SELECT bla FROM tbl WHERE bli IN ( <cfoutput>#blu#</cfoutput> )

With variable blu as a list separated with coma “,”. Coldfusion add single apostrophe automatically, and so forth the query wont give a result. DAMN! The solution is by split the query, and then loop it manually with single apostroph added (this looping action must be located inside cfquery tag). Man.. what a waste of time.

There are still tons of problem I faced, later Ill add it.