<cfscript>
dsn = Application.rcms.getAppDSN();

try {
	queryExecute(sql="DROP TABLE TestTable", options={datasource:dsn});
} catch (any e) {}

queryExecute(sql="
	CREATE TABLE TestTable (
		id [int] NOT NULL,
		intColumn [int] NULL,
		dateColumn [datetime] NULL,
		strColumn [nvarchar](24) NULL
	)
	",
	options={
		datasource:dsn
	}
);

queryExecute(
	sql="INSERT INTO TestTable(id, intColumn) VALUES(1, :theInt)",
	params=[{name="theInt", value=1, cfsqltype="cf_sql_integer", null=true}],
	options={
		datasource:dsn
	}
);

results = queryExecute(sql="SELECT * FROM TestTable WHERE id = 1", options={datasource:dsn});
writeDump(results);

queryExecute(
	sql="INSERT INTO TestTable(id, dateColumn) VALUES(2, :theDate)",
	params=[{name="theDate", value=0, cfsqltype="cf_sql_timestamp", null=true}],
	options={
		datasource:dsn
	}
);

results = queryExecute(sql="SELECT * FROM TestTable WHERE id = 2", options={datasource:dsn});
writeDump(results);

queryExecute(
	sql="INSERT INTO TestTable(id, strColumn) VALUES(3, :theStr)",
	params=[{name="theStr", value="", cfsqltype="cf_sql_varchar", null=true}],
	options={
		datasource:dsn
	}
);

results = queryExecute(sql="SELECT * FROM TestTable WHERE id = 3", options={datasource:dsn});
writeDump(results);
</cfscript>