I know that CF is 'typeless', but how can I view what data types are in a query result? I have 2 queries from different systems (one from DB2, one from SQL) that I am trying to union together using QoQ. I get an error about field 2, one being Decimal and the other Char. Is there any way to get meta-information that would show the CF-calculated data type in a query result?
Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284645 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4