UPDATE pal_Template
SET templateContent = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml">     <head>         <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />         <title>Email Template</title>         <style type="text/css">             <!--         body, td, th {             font-family: Trebuchet MS, Arial, Helvetica, sans-serif;             font-size: 12px;             color: #666;         }          body {             background-color: #CCC;         }          a:link {             text-decoration: none;         }          a:visited {             text-decoration: none;         }          a:hover {             text-decoration: underline;         }          a:active {             text-decoration: none;         }          h1 {             font-size: 14px;             color: #F60;         }         -->         </style>     </head>     <body link="#BA4C14" alink="#BA4C14" class="RadEditorContentStyle">         <table width="700" border="0" align="center" cellpadding="0" cellspacing="0">             <tbody>                 <tr>                     <td style="background-color: #ffffff;">                     <table width="100%" border="0" cellspacing="0" cellpadding="8">                         <tbody>                             <tr>                                 <td style="background-color: #007833;"><img alt="" src="{logo}" style="width: 300px;"/></td>                             </tr>                             <tr>                                 <td>                                 <p><strong>Subscribe Request</strong></p>                                 </td>                             </tr>                             <tr>                                 <td>                                 <p><strong>Name: </strong>{SubscribeRequest_ContactUsDetails_Name}</p>                                 </td>                             </tr>                             <tr>                                 <td>                                 <p><strong>Email:</strong> {SubscribeRequest_ContactUsDetails_Email}</p>                                 </td>                             </tr>                             <tr>                                 <td>                                 <p><strong>Mobile:</strong> {SubscribeRequest_ContactUsDetails_Mobile}</p>                                 </td>                             </tr>                             <tr>                                 <td>Thank you,<br />                                 Olivedale SPAR Team</td>                             </tr>                             <tr>                                 <td>...............................................................................................</td>                             </tr>                             <tr>                                 <td><br />                                 </td>                             </tr>                         </tbody>                     </table>                     </td>                 </tr>             </tbody>         </table>     </body> </html>'
WHERE templateName = 'Subscribe Request';

UPDATE pal_Template
SET templateContent = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml">     <head>         <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />         <title>Email Template</title>         <style type="text/css">             <!--         body, td, th {             font-family: Trebuchet MS, Arial, Helvetica, sans-serif;             font-size: 12px;             color: #666;         }          body {             background-color: #CCC;         }          a:link {             text-decoration: none;         }          a:visited {             text-decoration: none;         }          a:hover {             text-decoration: underline;         }          a:active {             text-decoration: none;         }          h1 {             font-size: 14px;             color: #F60;         }         -->         </style>     </head>     <body link="#BA4C14" alink="#BA4C14" class="RadEditorContentStyle" contenteditable="true">         <table width="700" border="0" align="center" cellpadding="0" cellspacing="0">             <tbody>                 <tr>                     <td style="background-color: #ffffff;">                     <table width="100%" border="0" cellspacing="0" cellpadding="8">                         <tbody>                             <tr>                                 <td style="background-color: #007833;"><img alt="" src="{logo}" style="width: 300px;"/></td>                            </tr>                             <tr>                                 <td>                                 <p><strong><br />                                 Website Contact Request</strong></p>                                 </td>                             </tr>                             <tr>                                 <td>                                 <p><strong>Name: </strong>{ContactRequest_ContactUsDetails_Name}</p>                                 </td>                             </tr>                             <tr>                                 <td>                                 <p><strong>Organisation:</strong> {ContactRequest_ContactUsDetails_Organisation}</p>                                 </td>                             </tr>                             <tr>                                 <td>                                 <p><strong>Email:</strong> {ContactRequest_ContactUsDetails_Email}</p>                                 </td>                             </tr>                             <tr>                                 <td>                                 <p><strong>Number:</strong> {ContactRequest_ContactUsDetails_Number}</p>                                 </td>                             </tr>                             <tr>                                 <td>                                 <p><strong>Enquiry Type:</strong> {ContactRequest_ContactUsDetails_EnquiryType}</p>                                 </td>                             </tr>                             <tr>                                 <td>                                 <p><strong>Comment or Enquiry:<br />                                 </strong><span style="background-color: transparent;">{ContactRequest_ContactUsDetails_CommentorEnquiry}</span></p>                                 </td>                             </tr>                             <tr>                                 <td>                                 <p><span style="background-color: transparent;"><br />                                 Thank you,<br />                                 </span><span style="background-color: transparent;">Olivedale SUPERSPAR Team</span></p>                                 </td>                             </tr>                             <tr>                                 <td><br />                                 </td>                             </tr>                             <tr>                                 <td><br />                                 </td>                             </tr>                         </tbody>                     </table>                     </td>                 </tr>             </tbody>         </table>     </body> </html>'
WHERE templateName = 'Contact Request';

