Tip : Getting unsorted query columns in coldfusion

nerdscubecom    Coldfusion     cfquery, Coldfusion, column, getmetadata, sorting, sql

This one gave me a headache for 15 min, making all the possible tricks to make my query return the unsorted columns.

Generally Coldfusion always sort the columns in the query that has been returned, irrespective of the order you have specified in the SQL statement. Most of the time its a blessing, but not always.

There is no documented way to get the unsorted columns otherthan using some thirdparty customtags and function. But there is a tweak for this case.

Tweak #1
Use getMetaData() function to get the column list which is as per the sql statement which you have written.

<!--- use GetMetadata to get the names and data types of the fields in the
            cfdocexamples Employees table --->
<cfquery name="getemployees" datasource="cfdocexamples">
SELECT *
FROM Employees
</cfquery>
<cfset employeemeta=getMetaData(getemployees)>
 
<h4>The Employees table has the following columns</h4>
<cfloop index="i" from="1" to="#arrayLen(employeemeta)#">
    <cfoutput>
        #employeemeta[i].name#
    </cfoutput>
</cfloop>

Tweak#2
Use queryObj.getColumnNames() function to get the unsorted list of column from the query. this function is not documented in CF docs. Thanks to Richard

<cfset queryColumnlist = ArrayToList( qryObj.getColumnNames() )>

Tip : Show hide columns in cfdump

nerdscubecom    Coldfusion    

Small tip for the day, In Coldfusion MX7 the CFdump was pritty much dump that it just do the variable dump and nothing more.

CF8 dump is much more capable like writing the dump out to file like i did in my last blog , plus you even can control the fields that you need to show or hide during the dump. This could pretty much save time when dumping big queries which contains long columns
Continue

Tip : Using cfdump inside CFscript

nerdscubecom    Coldfusion     cfdump, Coldfusion, tip, tricks

One simple tip for the day, How to use cfdump inside the cfscript block !!!

cfscript block does not support cfdump tag or indeed any tag inside it. So the trick is to create function which dumps the value using cfdump and call the function inside cfscript by passing the variable as parameter.
Continue

What is Augmented Reality ?

nerdscubecom    Technology     Android, augmented, Augumented, Definitions, future, Iphone, Reality, realtime, Technology, virtual world

Augmented Reality or in short AR is the term used to describe the mixture of real vs Virtual.  Its the real time mixing of virtual environment to a real world.
Continue

Coldfusion 9 : Feature improvement history

nerdscubecom    Coldfusion     cf8, CF9, Coldfusion, Coldfusion programming technology features new, compare, comparison, mx7, new feature, programming, Technology

Check out the new Coldfusion 9 feature comparison with its predecessors which includes CF8 and MX7. PDF download at the bottom of content.
Continue

Ask Neo: What is Digitization?

nerdscubecom    Project Management     Definitions, Digitization, programming, project, Project Management

Today somebody asked me the question on the definition of Digitization specific to computer projects.

So I went back to my seat and did my googling and found some simple paragraphs defining Project Digitization.
Continue

TIPS : Best Practices when creating email Newsletter Part:1

nerdscubecom    HTML     HTML, Inspirations

When creating a new Newletter for your business promotion email , you have to make sure that the email is views in a vast range of borwsers, mail services and applications like Outlook and thunderbird. So i thought to consolidate some best practices that you should consider when creating a News letter. Continue

2009 Must watch movies

nerdscubecom    Movies     movie, Movies, mustwatch, top

Call us greedy, but we’ve said it once, and we’ll say it again: Ten is not enough. While nearly all movie critics engage in the time-honored tradition of ranking their picks for 10 best flicks of the year, we prefer to take this time of year to recognize the admirable quantity of quality movies being produced, despite our occasional moaning that says otherwise. Therefore, like we have the past several years, we count to 50.
Continue

How to add dynamic rows in a table with javascript

nerdscubecom    HTML, Javascript     design, dynamic, element creation, HTML, Javascript, web development

A good web design involves the better user interaction and ability to fetch the data in a better way. For most User experience in your site, you have to ease out the user actions like form filling, searching etc.
Continue

Avatar : My joy ride to Pendora

nerdscubecom    Movies     Adventure, avatar, Movies, si-fi

Avatar : The movie by James Cameron , came out to be a movie of wonder land where creatures resembling human beings ” The Na’vi’s”. They live like us , They civilize, they love and care like us.  At one point, I really started to live with them through the 3D glasses.
Continue