%%[
var @EmailAddress, @CCID, @SubmitDate, @Brand, @sendId, @cereal_brand, @want_highinfibre, @want_classicbreakfast, @want_tastytreat, @want_glutenfree, @want_easyonthego, @want_kidfriendly
SET @CCID = RequestParameter("CCID")
SET @EmailAddress = RequestParameter("EmailAddress")
SET @SubmitDate = now()
SET @sendId = RequestParameter("sendId")
SET @Brand = "Cereal MB"
SET @want_highinfibre = IIF(RequestParameter("want_highinfibre")=="y",'y','n')
SET @want_classicbreakfast = IIF(RequestParameter("want_classicbreakfast")=="y",'y','n')
SET @want_tastytreat = IIF(RequestParameter("want_tastytreat")=="y",'y','n')
SET @want_glutenfree = IIF(RequestParameter("want_glutenfree")=="y",'y','n')
SET @want_easyonthego = IIF(RequestParameter("want_easyonthego")=="y",'y','n')
SET @want_kidfriendly = IIF(RequestParameter("want_kidfriendly")=="y",'y','n')
UpsertData("Cereals_BB_Submissions",1,"CCID", @CCID,"EmailAddress", @EmailAddress, "Brand", @Brand,"SubmitDate", @SubmitDate, "sendId", @sendId, "want_highinfibre", @want_highinfibre, "want_classicbreakfast", @want_classicbreakfast, "want_tastytreat", @want_tastytreat, "want_glutenfree", @want_glutenfree, "want_easyonthego", @want_easyonthego, "want_kidfriendly", @want_kidfriendly)
]%%