On #2, I assume then that you know which column you would be removing, so how about:
get the list of current columns, whatever they are: <cfset colList = employees.columnList /> remove a known column, in this example "phone": <cfset colList = listDeleteAt(colList, listFindNoCase(colList, "phone")) /> now, requery QofQ based on the reduced column list: <cfquery dbtype="query" name="employees"> SELECT #colList# FROM employees </cfquery> That allows the actual list of columns to be entirely dynamic, while still removing whichever known columns you want to remove, AND still re-uses the same variable, so there's no additional server overhead, or at least not anything noticeable. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
