As you know that coldfusion added java coding style in
cfscript tag.
Here one example of executing query from coldfusion
cfscript tag.
Retrieve resultset with multiple id's
function getResultSetByIDs(string dsn, required numeric
userIDs) {
// Setup a
variable for the Query Result
var qResult =
'';
// Setup the
Query variable
var q= new
query();
// Add
Parameter
q.addParam(name="ID", value=arguments.userIDs,
cfsqltype="CF_SQL_INTEGER" list="true");
// Create the
SQL String
var
sqlString="
SELECT *
FROM USERS
WHERE
USERID IN (:ID)
";
q.setdatasource(arguments.pDsn);
q.setsql(sqlString);
qResult=q.execute().getresult();
return
qResult;
}
