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.
What type of database are you using? Some databases
have the ability to return queries as XML. M$SQL 2K has
the "for xml" options and Oracle (I think) has
something similar... just thought I'd throw that out
there.
Your looking for the query meta data btw that may help
with your seaching. I've done it before but I dont have
the code handy (here at work) so I am a bit useless on
that front.
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]
