Pengcheng's Blog

现在自己写CFML程序，除非老的代码修改，已经不再使用Tags，基本上是用Script了。

有时候花了很长时间在Google或Stackoverflow上查到的cfscript snippets，是已经用到了项目上，但是没有记录，可能过了有一段时间，再有用到这写cfscript snippets时，绞尽脑汁去回忆之前用在什么地方。

这样，挺浪费时间的，于是有想法在此Post里记录下，用到的时候就直接来这里Copy了。懒人么，就是这样：）

setting

setting enablecfoutputonly="true" requesttimeout="150" showdebugoutput="false";

param

param name="form.role" type="string" default="user";

directory

if(!directoryExists(filesDir)){
	directory action="create" directory="#filesDir#";
}

if(directoryExists(empFilesDir)){
	directory action="delete" directory="#filesDir#" recurse="true";
}

transaction

transaction {
	try {
		// do something
		transaction action="commit";
	} catch (any e) {
		writeDump(e);
		transaction action="rollback";
	}
}

query insert

queryObj = new query();
queryObj.setDatasource(request.dsn);

queryObj.setName("qryName");
queryObj.setSQL("
	INSERT INTO table_name (
		name,
		age,
		status
	) VALUES (
		:name,
		:age,
		:status
	)
");
queryObj.addParam(name="name",value="#mid#",cfsqltype="cf_sql_varchar");
queryObj.addParam(name="age",value="#empId#",cfsqltype="cf_sql_integer");
queryObj.addParam(name="status",value="#status#",cfsqltype="cf_sql_varchar");
queryPrefix = queryObj.execute().getPrefix();
newId = queryPrefix.generatedKey;
queryObj.clearParams();

query delete

queryObj.setName("deleteUser");
queryObj.setSQL("
	DELETE FROM users
	WHERE id = :id
");
queryObj.addParam(name="id",value="#id#",cfsqltype="cf_sql_numeric");
queryObj.execute();
queryObj.clearParams();

query update

queryObj.setName("updateTbl");
queryObj.setSQL("
	UPDATE tbl SET
		page = :page,
		status = :status
		modified_date = GETDATE()
	WHERE id = :id
");
queryObj.addParam(name="page",value="#form.page#",cfsqltype="cf_sql_numeric");
queryObj.addParam(name="status",value="#form.status#",cfsqltype="cf_sql_varchar");
queryObj.addParam(name="id",value="#form.id#",cfsqltype="cf_sql_numeric");
queryObj.execute();
queryObj.clearParams();

query select

queryObj.setName("getStuDtl");
queryObj.setSQL("
	SELECT	*
	FROM	students
	WHERE	id = :stu_id
");
queryObj.addParam(name="id",value="#form.stu_id#",cfsqltype="cf_sql_integer");
qryStuDtl = queryObj.execute().getResult();
queryObj.clearParams();

coldfusion query of queries

queryObj.setName("getOldTeachers");
queryObj.setDBType("query");
queryObj.setAttributes(questions=qryAllTeachers);
queryObj.setSQL("
	SELECT	*
	FROM 	qryAllTeachers
	WHERE	age > :max_age
	ORDER BY id
");
queryObj.addParam(name="max_age",value="55",cfsqltype="cf_sql_integer");
qryOldTeachers = queryObj.execute().getResult();
queryObj.clearParams();