add an order by clause to your query. If you have to, order each one.
There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown ----- Original Message ----- From: "Troy Montour" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, February 16, 2002 11:09 PM Subject: need columnlist help > 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 > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
