RE: How do I tell what fields are in my tables...

[Aunger, Mitch]

I'm confused... won't this just list the columns in your query? It doesn't list all of the columns in the table does it? (Which is what the original question was).

Mitch

Shameless plug for my wife's business:
http://www.mygccandle.com/showmescents

-----Original Message-----
From: Angel Stewart [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 9:47 AM
To: CF-Talk
Subject: RE: How do I tell what fields are in my tables...


Where'd you find that out?

I've been looking through CFWACK for the CFQUERY tag, and I can't find
anything that mentions the columnlist variable for CFQuery.

Is there also some other variable that stores field type?

-Gel



-----Original Message-----
From: Shawn Regan [mailto:[EMAIL PROTECTED]


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

that will dump a list of your fields.




  _____  

---

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

---