<!--- Drop the exist table. --->
<cfquery name="drop">
	DROP TABLE girl
</cfquery>
 
 
<!---
	Create the girls data table. The database I'm using
	is an embeded Apach Derby database, hence the really
	odd auto-increment syntax.
--->
<cfquery name="create">
	CREATE TABLE girl
	(
		id int NOT NULL GENERATED BY DEFAULT AS IDENTITY,
		name varchar(30) NOT NULL,
		hair varchar(30) NOT NULL,
		PRIMARY KEY (id)
	)
</cfquery>
 
 
<!--- Insert a records into the girl. --->
<cfquery name="insert">
	INSERT INTO girl
	(
		name,
		hair
	) VALUES (
		<cfqueryparam value="Tricia" cfsqltype="cf_sql_varchar" />,
		<cfqueryparam value="Brown" cfsqltype="cf_sql_varchar" />
	)
</cfquery>
 
 
<!--- Query for girls. --->
<cfquery name="girls">
	SELECT
		id,
		name,
		hair
	FROM
		girl
</cfquery>
 
 
<!--- Output query records. --->
<cfdump
	var="#girls#"
	label="Girls (Derby)"
	/>