Features

• Convert ColdFusion query to CSV string
• Query can be from anything. ColdFusion query from database, Query Of Query (QoQ), <cfhttp> call, <cfdirectory>, or even code generated query using #querynew#
• CSV string result. Means you can later save this string as text file, send it over to other application using <cfhttp> and so on...
• Works with all type of CSV delimiter
• Ultra fast performance
• Ability to select which rows and columns you want to convert
• Multi-platform. Can be installed in any operating system ColdFusion supports.
• Fastest deployment. No 3rd party application required. No CFX tags to install. Shared hosting friendly.
  Just copy this custom tag in the working directory and you are set.

Requirements

Supported ColdFusion Server:

• ColdFusion MX 6, 6.1
• ColdFusion MX 7

on all operating systems.
Note: For this tag to run, #createobject# function has to be enabled.

Supported browsers:
This tag works on server side, so all browsers are compatible

Usage

<cf_query2csvmx	query="[queryname you want to convert]"
	result="[csv string result]"
	delimiter="[delimiter, default is comma]"
	linebreak="[linebreak, default is carriage return followed by line feed (chr(13) & chr(10))]"
	textqualifier="[text qualifier, default is a double quote]"
	columnlist="[list of column names]"
	startrow="[the first row to process]"
	endrow="[the last row to process, if 0 all the rest rows will be processed]">
	header="[Text before the CSV data]"
	footer="[Text after the CSV data]">