This worked like a charm.
I'm alos going to look at what you recomended Philip.
Thanks to all!
Brian
oi cf!!
select top 10 * from table
<cfdump var="#query#">
or output query.columnlist
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]