select top 10 * from table
<cfdump var="#query#">
or output query.columnlist
--
------------------------------------
Thursday, October 2, 2003, 10:09:51 AM, you wrote:
ct> I have a site that I have no access to the DB from work (SQL Server). I am getting an
ct> error with one of my queries. It looks as if the field is either not there or spelled wrong.
ct> Can anyone tell me how I can tell what fields I have for a table?
ct> Thanks,
ct> Brian Yager
ct> President - North Alabama
ct> Cold Fusion Users Group
ct> http://www.nacfug.com
ct> Ground-Based Midcourse Defense JPO
ct> Contractor CSC
ct> (256)313-9668
ct> [EMAIL PROTECTED]
ct
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]