On Mon, Mar 20, 2006 at 05:12:21PM -0400, Steve Bryant wrote:
> Unless I am mistaken, that requires a purchased CFX tag. I need a solution
> that I can use (for free and without extra install) from my component.
>From the archives:
Subject: RE: Get fields in an Access table
From: "Todd Mathews" <[EMAIL PROTECTED]>
To: CF-Talk <[email protected]>
Date: Wed, 24 Aug 2005 14:26:59 -0500
If you are using MX, you could do something like this:
<cfquery name="getRecs" datasource="cfbookclub">
SELECT TOP 1 * FROM Authors
</cfquery>
<cfset querymeta=getMetaData(getRecs)>
<cfdump var="#querymeta#">
This will give you an array of structures that contain all of the field
names, case sensitivity and field type.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235838
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
