The local variable @HTMLCONTENT is declared twice. This is not ideal, and at a minimum the code doesn't work in a DBMS connected to a Rock DB. I don't know if this code works as part of a package. This PR changes the second local variable declaration to use a different variable name, along with modifying the reference to the 2nd local variable.
I'm unsure if any changes would also need to be made to the uninstall sql, as it only references GUID's, and the second 'HTMLCONTENT' local variable is not a GUID, but a Varchar.
The local variable @HTMLCONTENT is declared twice. This is not ideal, and at a minimum the code doesn't work in a DBMS connected to a Rock DB. I don't know if this code works as part of a package. This PR changes the second local variable declaration to use a different variable name, along with modifying the reference to the 2nd local variable.
I'm unsure if any changes would also need to be made to the uninstall sql, as it only references GUID's, and the second 'HTMLCONTENT' local variable is not a GUID, but a Varchar.