I've written a simple CFML Custom Tag which created a "properly" ordered list of columns in a query. This gets around the problem that the CF-supplied ColumnList is in an unpredictable order. If the SELECT clause is a list of columns, the tag returns a list of those columns in the same order as they appear in the SELECT clause. If the SELECT clause is "*", the tag returns a list of those columns in the same order as they appear in the database. It works by simply converting the input query into a WDDX packet and then extracting the packet's list of columns. It so happens that the data in the WDDX packet is in the proper order. I tried submitting it to Allaire, unsuccessfully. If anyone wants it, just send me email and I'll send it. (Posted to CF-Talk and CFDJList) -David ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
