Example of Insert Statement with QueryExecute

QueryExecuteExample.cfc

var params = {
  fieldName = { value = stringVariable, cfsqltype = "CF_SQL_VARCHAR" },
  otherFieldName = { value = otherVariable, cfsqltype = "CF_SQL_VARCHAR" }
};

var sql = "INSERT INTO theTable(
  fieldName,
  otherFieldName) VALUES (
  :fieldName,
  :otherFieldName)"

var qry_saveSomething = '';
QueryExecute( sql, params, {result = "qry_saveSomething"} );