<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Learning ColdFusion 9: Application-Specific Data Sources Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:1642.view Date Posted: Jul 13, 2009 at 10:27 AM ---- --------------------------------------------------------------------------------------- ---> DROP TABLE girl 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) ) INSERT INTO girl ( name, hair ) VALUES ( , ) SELECT id, name, hair FROM girl