On 3/17/07, Pete wrote:
Right before the loop, do this: > <cfoutput> > > ID#TabChar#Title#TabChar#FirstName#TabChar#LastName#TabChar#PrefNam > e#TabChar#BusName#TabChar#Address#TabChar#Suburb#TabChar#StateID#Ta > bChar#Postcode#TabChar#CountryCode#TabChar#Phone#TabChar#Fax#TabChar > #Mobile#TabChar#Email#NewLine# > > </cfoutput> Which should work. If you can use createObject, there's also some stuff over on google code http://code.google.com/p/cfjexcel/ basically just a couple of cfcs that use jExcelApi for import/export of xls. There's a very basic "row level" formula embedder in query2xls.cfc. Not sure if the zip has the latest source, so might wanna download the two cfcs from here: http://cfjexcel.googlecode.com/svn/trunk/ You could loop through the column names too, somelhing tike: <cfset var xlsFile = ""> <cfloop list="#qgetmedicaldelegates.columnlist#" index="fieldNam"> <cfset xlsFile = listAppend(xlsFile,fieldNam,tabChar)> </cfloop> Then whack off the last tabChar, add a newLine, and viola! One more loop using the query values, something like <cfloop query="qgetmedicaldelegates"> <cfloop list="#qgetmedicaldelegates.columnlist#" index="fieldNam"> <cfset xlsFile = listAppend(xlsFile,qgetmedicaldelegates[fieldNam][currentRow],tabChar)> </cfloop> </cfloop> Again, whack off the last tabChar, and that would do it (assuming tabChar would work as a list delim). Someone had a nifty solution to the whole "how do I get rid of the last list thingie", but I don't remember it off hand. :-/ Have Fun! > <cfloop query="qgetmedicaldelegates"> > > <cfoutput> > > #ID##TabChar##Title##TabChar##FirstName##TabChar##LastName##TabChar##PrefNam > e##TabChar##BusName##TabChar##Address##TabChar##Suburb##TabChar##StateID##Ta > bChar##Postcode##TabChar##CountryCode##TabChar##Phone##TabChar##Fax##TabChar > ##Mobile##TabChar##Email##NewLine# > > </cfoutput> > > </cfloop> > > > > Thanks in advance ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272924 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
