queryName.ColumnList Will give you a comma-delimited list of the query columns.
-steve -----Original Message----- From: Mike Lau [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 2:31 PM To: [EMAIL PROTECTED] Subject: [CFTALKTor] getting query field name 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) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Steve Budan <[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)
