Any chance you could make it a csv file? You can then cfhttp name="querycsv" the csv file and the first line will be considered the columns so querycsv.columnlist will work.
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 20 January 2004 10:21 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] CFMX - Dreamweaver > > > > Oh god I wish I could ..... > > I have fixed it in FTP for now...... > > Another question though. > > I am using an excel spreadsheet as the datasource. > Is there a way I can extract all of the column names with a query to save > me typing them all in .... > > So that I can do a cfoutput like column name = #columname# > Then I can cut & paste em nicely .... > > > Regards - Paul > > > > > ****************************************************************** > ******************************* > The information contained within this e-mail (and any attachment) > sent by Birmingham City Council is confidential and may be > legally privileged. It is intended only for the named recipient > or entity to whom it is addressed. If you are not the intended > recipient please accept our apologies and notify the sender > immediately, or telephone +(44) 121 303 6666. Unauthorised > access, use, disclosure, storage or copying is not permitted and > may be unlawful. Any e-mail including its content may be > monitored and used by Birmingham City Council for reasons of > security and for monitoring internal compliance with the office > policy on staff use. E-mail blocking software may also be used. > Any views or opinions presented are solely those of the > originator and do not necessarily represent those of Birmingham > City Council. We cannot guarantee that this message or any > attachment is virus free or has not been intercepted and amended. > > ****************************************************************** > ******************************* > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
