Ask Ben: Converting A Struct To A Query (And More Java)

<!--- Create a new query. --->
<cfset qPartsTwo = QueryNew( "" ) />
 
<!--- Loop over keys in the struct. --->
<cfloop index="strKey" list="#StructKeyList( objParts )#" delimiters=",">
	 
	<!--- Add column to new query with default values. --->
	<cfset QueryAddColumn( 
		qPartsTwo, 
		strKey, 
		"VARCHAR", 
		objParts[ strKey ] 
		) />
 
</cfloop>

For Cut-and-Paste