hi all,
i know that we can loop through the Form object to get the field name from
the submitted data set, like the following:
<CFLOOP INDEX="FormField" LIST="#Form.FieldNames#">#FormField#</CFLOOP>
OR
<CFLOOP INDEX="FormField" LIST="#StructKeyList(Form)#">#FormField#</CFLOOP>
so I guess we can do the same thing for Query, ie: loop through the db query
and get all the column name.
In ASP it's something like
<% for i = 0 to RecordSet.Fields.Count - 1 %>
<%=RecordSet.Fields(i).name%>
<%next%>
in java it's just about the same thing using
ResultSetMetaData.getColumnName(i)
what about in CF? anybody can tell me how to do this?
rgds,
=============================
Mike Lau
Web Developer
[EMAIL PROTECTED]
User In Mind Creative Group Inc.
http://www.userinmind.com
Toll Free: 1-866-294-6644
T: (416) 490-7556
F: (416) 490-6889
=============================
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "Mike Lau" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
