I'm working on an application with a friend of mine and we're taking full advantage of all the great new functions and features in Open BlueDragon. One of the new functions I wasn't sure I'd use all that much is QueryRun(), which lets you run a query in a CFSCRIPT block like this:
<cfscript>
QueryRun(datasource, sqlStatement, queryParams);
</cfscript>
<cfscript>
getUsersSQL = "SELECT id, email, first_name, last_name FROM user";
users = QueryRun("myDSN", getUsersSQL);
</cfscript>
<cfscript>
getUsersSQLParams = [{value = "matt@mattwoodward.com", cfsqltype = "cf_sql_varchar", maxlength = 100}];
getUsersSQL = "SELECT id, email, first_name, last_name FROM user ";
getUsersSQL &= "WHERE email = ?";
users = QueryRun("myDSN", getUsersSQL, getUsersSQLParams);
</cfscript>
<cfscript>
getUsersSQLParams = [{value = "Matt", cfsqltype = "cf_sql_varchar", maxlength = 100},
{value = "Woodward", cfsqltype="cf_sql_varchar", maxlength = 100}];
getUsersSQL = "SELECT id, email, first_name, last_name FROM user ";
getUsersSQL &= "WHERE first_name = ? AND last_name = ?";
users = QueryRun("myDSN", getUsersSQL, getUsersSQLParams);
</cfscript>
<cffunction name="save" access="public" output="false" returntype="void">
<cfargument name="user" type="User" required="true" />
<cfscript>
var commonSQLParams = [{value = arguments.user.getEmail(), cfsqltype = "cf_sql_varchar", maxlength = 100},
{value = arguments.user.getFirstName(), cfsqltype = "cf_sql_varchar", maxlength = 100},
{value = arguments.user.getLastName(), cfsqltype = "cf_sql_varchar", maxlength = 100}];
// if the ID is 0 do an insert, otherwise do an update
if (arguments.user.getID() == 0) {
var insertUserSQL = "INSERT INTO user (email, first_name, last_name) ";
insertUserSQL &= "VALUES (?, ?, ?)";
var insertUser = QueryRun("myDSN", insertUserSQL, commonSQLParams);
} else {
ArrayAppend(commonSQLParams, {value = arguments.user.getID(), cfsqltype = "cf_sql_integer"});
var updateUserSQL = "UPDATE user SET email = ?, first_name = ?, last_name = ? ";
updateUserSQL &= "WHERE id = ?";
var updateUser = QueryRun("myDSN", updateUserSQL, commonSQLParams);
}
</cfscript>
</cffunction>
WOO: Rise, and speak wisely, man--but hark; I see thy rug, as woven i'the Orient, A treasure from abroad. I like it not. I'll stain it thus; ever thus to deadbeats.
