That's the one! It does everything I asked for (though not everything I want).
Thanks for all who replied. I looked at the CFDJ article as well, but it made it sound like it wouldn't work well on Access. If anyone can tell me how to determine primary key, field length, and nullable that would be great as well. (com?) Thanks to all who replied! Steve >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. > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216279 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
