wrote:
> >I'm going to ditch using DOM and create my XML using
a
> bunch of CFSET
> >calls in a query loop. That said, is there any way
> that I can dynamically
> >determine the names of the recordset column names?
My
> DBA just told me
> >there are changes coming down the pike and I don't
> want to change my code
> >for every change in the tables. I was thinking of
> something akin to
> >Form.fieldnames/Form[field] for web forms.
> >
>
> You can simply use queryName.ColumnList to get the
> column names returned in
> the set.
Jezz I feel like a moron. I was mixing up getting the
type (varchar etc) with the name :-/ good call Dave
Embarrassingly,
Rob
O CH3
H3C || /
\ / \ N
N \/ \
| | //
//\ / \ //
O N N
|
CH3
http://treebeard.sourceforge.net
http://ashpool.sourceforge.net
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
