Browsing all articles tagged with cfquery
Tip : Getting unsorted query columns in coldfusion
nerdscubecom 
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() )>Take it with you!
DandyID
Delicious
Google Reader
Linkedin
Twitter
FacebookRecent Posts
- Instant Method Finder : My first Coldfusion Builder extension!
- Create coldfusion builder snippets from cflib repository
- Tip:Difference between resistive and capacitive touch screen.
- Why QR code is cool and easy with smartphones !!!!!
- Tip : Getting unsorted query columns in coldfusion
Categories
- Coldfusion
- Coldfusion Builder
- HTML
- Javascript
- Jquery
- Movies
- Project Management
- Technology
- Tips and Tricks
- whatsNew
Tags
Adventure
Android
augmented
Augumented
avatar
cf8
CF9
cfdump
cfquery
Coldfusion
Coldfusion programming technology features new
compare
comparison
debugging
Definitions
design
Digitization
dynamic
element creation
form
future
getmetadata
HTML
Inspirations
Iphone
Javascript
Jquery
movie
Movies
mustwatch
mx7
new feature
programming
project
Project Management
Reality
realtime
si-fi
Technology
tip
top
tricks
validation
virtual world
web development
Archives
- January 2011 (2)
- October 2010 (2)
- February 2010 (2)
- January 2010 (5)
- December 2009 (5)
CF Libs
- arrayTrim January 31, 2012This method trims an array to the specified number of elements. […]
- longTime January 25, 2012Returns a list like 3 years, 2 months, 12 days, 1 hour, 10 minutes, 45 seconds from a seconds count argument. […]
- quickSort January 15, 2012Implementation of Hoare's Quicksort algorithm for sorting arrays of arbitrary items. […]
- GetHostAddress January 12, 2012Performs a DNS lookup. […]
- GetFileFilterCount January 4, 2012Accepts a directory path & a file filter. Returns number of matching files. […]
- replaceSpecialChars January 4, 2012Replaces all special characters in a string of text. […]
- solrClean December 30, 2011Like VerityClean, massages text input to make it Solr compatible. […]
- rjustify2 December 21, 2011Same as built-in RJUSTIFY, but allows optional parameter character to pad with. […]
- RowColor December 21, 2011Returns alternating color based on list of colors. […]