Yes, getMetaData. :)
<cfquery name="test" datasource="blogdev" maxrows="5"> select * from tblblogcomments </cfquery> <cfdump var="#getmetadata(test)#"> On 7/26/07, Peterson, Chris <[EMAIL PROTECTED]> wrote: > 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 involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284649 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4