<!--- Create a new part query. --->
<cfset qPart = QueryNew(
	"id, serial_number, price",
	"cf_sql_integer, cf_sql_varchar, cf_sql_decimal"
	) />
 
 
<!--- Create some record. --->
<cfloop
	index="intI"
	from="1"
	to="1000"
	step="1">
 
	<!--- Add a row to the query. --->
	<cfset QueryAddRow( qPart ) />
 
	<!--- Populate row with random data. --->
	<cfset qPart[ "id" ][ qPart.RecordCount ] = JavaCast( "int", qPart.RecordCount ) />
	<cfset qPart[ "serial_number" ][ qPart.RecordCount ] = JavaCast( "string", CreateUUID() ) />
	<cfset qPart[ "price" ][ qPart.RecordCount ] = JavaCast( "float", RandRange( 1, 100 ) ) />
 
</cfloop>
 
 
<!--- Get the CSV value. --->
<cfset strOutput = QueryToCSV(
	qPart,
	"id, serial_number, price"
	) />