gistfile1.cfm

<cfquery name="test" datasource="#this.dsn#" result="testResult">
	INSERT INTO contacts (
				firstname
				,lastname
	)
		SELECT <cfqueryparam cfsqltype="cf_sql_varchar" value="Marko">
				,<cfqueryparam cfsqltype="cf_sql_varchar" value="Simic">
	
		UNION ALL
	
		SELECT <cfqueryparam cfsqltype="cf_sql_varchar" value="Boris">
				, <cfqueryparam cfsqltype="cf_sql_varchar" value="Huskic">
</cfquery>


<cfdump var="#testResult#">
<cfdump var="#testResult.IDENTITYCOL#">