TryCF Gist

trycf-gist-1751474582437-baa2d572-7c72-4f85-65d7-7103d78eb49e.cfm

<cfscript>

    // Simulate incoming arguments
    arguments.userID = 1;
    user_id = 1;
     // 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 = [];

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

			users1.append(userInfo);
		});


 dump(users1);
</cfscript>