TryCF Gist

trycf-gist-1751477943930-010a8c2a-08e8-3477-520e-e5e16f0b8cd5.cfm

<cfscript>

    // Simulate incoming arguments
    arguments.userID = 101;
 
     // Simulate Query
     users = queryNew(
        "User_ID,UserName,email,updated_at",
        "integer,varchar,varchar,varchar"
    );
    
    // Add a row to the query
    queryAddRow(users);
    querySetCell(users, "User_ID", 101);
    querySetCell(users, "UserName", "johndoe");
    querySetCell(users, "email", "[email protected]");
    querySetCell(users, "updated_at", "232432423");

    
    qryUser = queryExecute("
			SELECT user_id
				, username
				, email
				, updated_at
			FROM users
			WHERE user_id = :userID
		",
		{
			userID: { value: arguments.userID, cfsqltype: "cf_sql_integer" }
		}, { dbtype: "query" });

		users1 = [];

		qryUser.each(function(row) {
			userInfo = {};
			userInfo.userID = row.user_id;
			userInfo.username = row.username;
			userInfo.email = row.email;
			userInfo.lastUpdated = row.updated_at;

			users1.append(userInfo);
		});


 dump(users1);
</cfscript>