open your DB and goto
Tools --> Options --> View
and check system table sand hidden tables
MSysObjects is the table that contains all the info you need.
Russ Michaels
Macromedia/Allaire Certified ColdFusion Developer
CFDeveloper
The free resource and community for ColdFusion developer.
http://www.cfdeveloper.co.uk <http://www.cfdeveloper.co.uk/>
Join the CFDeveloper discussion lists.
To subscribe send an e-mail to [EMAIL PROTECTED]
-----Original Message-----
From: Angel Stewart [mailto:[EMAIL PROTECTED]
Sent: 05 October 2003 15:13
To: CF-Talk
Subject: Getting Field names and datatypes from MS Access database
Hey all,
this topic was touched on a few threads back, but it was never fully
resolved.
How would I get the fieldnames and their corresponding data types for a
specific table in an access database using coldfusion?
-Gel
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
