you can use this: <cfoutput>#yourQuery.columnlist#</cfouput>

that will dump a list of your fields.

Shawn Regan
Head Applications Developer
pacifictechnologysolutions

-----Original Message-----
From: cf talk [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 7:10 AM
To: CF-Talk
Subject: How do I tell what fields are in my tables...


I have a site that I have no access to the DB from work (SQL Server).  I am
getting an error with one of my queries.  It looks as if the field is either
not there or spelled wrong.  Can anyone tell me how I can tell what fields I
have for a table?


Thanks,


Brian Yager
President - North Alabama
Cold Fusion Users Group
http://www.nacfug.com <http://www.nacfug.com>
Ground-Based Midcourse Defense JPO
Contractor CSC
(256)313-9668
[EMAIL PROTECTED]
  _____  

[ Todays  
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to