Hello,
Trying to do queryname.columnlist and it is putting it in a
different order then the database any idea why or how to fix.
code below and looking for it to be in the order of the select part.
<cfquery name="Excelfile" datasource="#query_datasource#"
username="#query_username#" password="#query_password#">
SELECT CON_title, CON_first_name, CON_middle_initial,
CON_last_name, CON_contact_type, CON_company_name, CON_addr_ln1,
CON_addr_ln2, CON_city, CON_ST, CON_zip, CON_tel_nbr, CON_fax_nbr,
CON_email, CON_notes_comments, CON_biz_type, CON_referred_by
FROM Contact
</cfquery>
<cfoutput>
#Excelfile.columnlist#
</cfoutput>
Output
CON_ADDR_LN1,CON_ADDR_LN2,CON_BIZ_TYPE,CON_CITY,CON_COMPANY_NAME,CON_CONT
ACT_TYPE,CON_EMAIL,CON_FAX_NBR,CON_FIRST_NAME,CON_LAST_NAME,CON_MIDDLE_IN
ITIAL,CON_NOTES_COMMENTS,CON_REFERRED_BY,CON_ST,CON_TEL_NBR,CON_TITLE,CON
_ZIP
Thank You
Troy
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
