> I found a java CFX tag that converts a query to CSV > flat file. The tag is processes 10,000 records very quicky > and does a great job when using a single SQL query to > gather record data. Each query column is a new column > in the flat file.
What is the cfx tag called? Mine is on the dev gallery cfx_querywrite. > After working with the tag, I used a SQL statement with > joins to gather data for the CSV file. On output the tag > places the joined columns on a new line, not in a new > column as per a single table query. This is strange. Have you dumped the query and made sure all is well? > What is different in the Coldfusion query object between > a single table statement and one containing a join? How > do the cf query object structures differ? Nothing as far as i'm aware. Are you storing simple data only in the query, ie text, numerics, etc? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
