%%[
var @EmailAddress, @CCID, @SubmitDate, @Brand, @sendId, @cereal_brand, @flavour_addmyown, @flavour_chocolatey, @flavour_honey, @flavour_cinnamon, @flavour_nutty, @flavour_fruity
SET @CCID = RequestParameter("CCID")
SET @EmailAddress = RequestParameter("EmailAddress")
SET @SubmitDate = now()
SET @sendId = RequestParameter("sendId")
SET @Brand = "Cereal MB"
SET @flavour_fruity = IIF(RequestParameter("flavour_fruity")=="y",'y','n')
SET @flavour_honey = IIF(RequestParameter("flavour_honey")=="y",'y','n')
SET @flavour_chocolatey = IIF(RequestParameter("flavour_chocolatey")=="y",'y','n')
SET @flavour_cinnamon = IIF(RequestParameter("flavour_cinnamon")=="y",'y','n')
SET @flavour_nutty = IIF(RequestParameter("flavour_nutty")=="y",'y','n')
SET @flavour_addmyown = IIF(RequestParameter("flavour_addmyown")=="y",'y','n')
UpsertData("Cereals_BB_Submissions",1,"CCID", @CCID,"EmailAddress", @EmailAddress, "Brand", @Brand,"SubmitDate", @SubmitDate, "sendId", @sendId, "flavour_addmyown", @flavour_addmyown, "flavour_chocolatey", @flavour_chocolatey, "flavour_honey", @flavour_honey, "flavour_cinnamon", @flavour_cinnamon, "flavour_nutty", @flavour_nutty, "flavour_fruity", @flavour_fruity)
]%%
