2 Replies Latest reply: Feb 9, 2012 1:32 AM by fac586 RSS

    Replace current header and footer with new header and footer in text area

    914341
      Hi,

      We have a page 1 where i am inserting header and footer with body(Message- the field name) and it is updating one of my table called table1. The datatype for this field is CLOB. In the message field which is text area contains header,footer,body as stated below
      <p>
            </p>
      <style type="text/css">
      .headerTop { background-color:#FFCC66; border-top:0px solid #000000; border-bottom:1px solid #FFFFFF; text-align:center; }
       .adminText { font-size:10px; color:#fcaf5f; line-height:200%; font-family:verdana; text-decoration:none; }
       .headerBar { background-color:#FFFFFF; border-top:0px solid #333333; border-bottom:10px solid #FFFFFF; }
       .title { font-size:20px; font-weight:bold; color:#CC6600; font-family:arial; line-height:110%; }
       .subTitle { font-size:11px; font-weight:normal; color:#666666; font-style:italic; font-family:arial; }
       .defaultText { font-size:12px; color:#000000; line-height:150%; font-family:trebuchet ms; }
       .footerRow { background-color:#FFFFCC; border-top:10px solid #FFFFFF; }
       .footerText { font-size:10px; color:#fcaf5f; line-height:100%; font-family:verdana; }
       a { color:#FF6600; color:#FF6600; color:#FF6600; }</style>
      <table bgcolor="#CCCCCC" cellpadding="20" cellspacing="0" class="backgroundTable" width="100%">
           <tbody>
                <tr>
                     <td align="center" valign="top">
                          <table cellpadding="0" cellspacing="0" width="540">
                               <tbody>
                                    <tr>
                                         <td align="center" style="background-color:#CCCCCC;border-top:0px solid #000000;border-bottom:1px solid #FFFFFF;text-align:center; ">
                                              <br />
                                               </td>
                                    </tr>
                                    <tr>
                                         <td style="background-color:#FFFFFF;border-top:0px solid #333333;">
                                              <center>
                                                   <img src="http://www.abc.com/images/header.png" width="550" /></center>
                                         </td>
                                    </tr>
                               </tbody>
                          </table>
                          <table bgcolor="#FFFFFF" cellpadding="20" cellspacing="0" width="550">
                               <tbody>
                                    <tr>
                                         <td bgcolor="#F6923E" valign="top" width="50px">
                                               </td>
                                         <td bgcolor="#FFFFFF" style="font-size:12px; color:#000000;line-height:150%;font-family:Arial, Helvetica, sans-serif;color:#666; text-align:justify;" valign="top">
                                              <center>
                                                   <img src="http://www.abcl.com/images/BRAND_MGMT.png" width="400" /></center>
                                              <center>
                                                   <br />
                                                   <font size="+2"><strong>EVENT NOTIFICATION</strong></font><br />
                                                   <font size="+1"><strong>Quality Performance Improvement</strong></font></center>
                                              <br />
                                              An Assessment visit has just been processed for ${param2}<br />
                                              <br />
                                              Date: ${param3} .<br />
                                              <br />
                                              Status: <b> ${param4}</b>.<br />
                                              <br />
                                              Assessor Name: ${param1}.<br />
                                              <br />
                                              To View MY BRAND MANAGER on line, click <a href="http://www.abc.com/apex/f?p=101:101"> HERE </a> to view your events and reports.<br />
                                              Regards,<br />
                                              <br />
                                              <strong>Your Quality Performance Improvement Team</strong>
                                              <p>
                                                   <br />
                                                    </p>
                                              <p>
                                                   <a href="#" title="Visit Our Website">www.abc.com</a></p>
                                              <img align="middle" src="http://www.abc.com/hstd_img/water_footer.jpg" width="460" /></td>
                                    </tr>
                                    <tr>
                                         <td style="background-color:#CCCCCC;">
                                               </td>
                                         <td align="center" style="background-color:#CCCCCC;border-top:0px solid #000000;text-align:center; ">
                                              <span style="font-size:10px;color:#333;line-height:200%;font-family:verdana;text-decoration:none;"></span></td>
                                    </tr>
                               </tbody>
                          </table>
                     </td>
                </tr>
           </tbody>
      </table>
      <br />
      I have a new table called table 2 which has two fields PID and HEADER_FOOTER. We have made an GUI for inserting the new header and footer to table 2. And we have a drop down list for all header and footer. My requirement is, suppose if i select the one set of header and footer from drop down list then it should replace the header and footer of message text area of page 1 with the selected header and footer from drop down list. Please let me know the approach for the same.

      Thanks in advance
        • 1. Re: Replace current header and footer with new header and footer in text area
          914341
          my question is still not answered can anyone just look into it.
          • 2. Re: Replace current header and footer with new header and footer in text area
            fac586
            911338 wrote:
            my question is still not answered can anyone just look into it.
            It's not really clear what you are talking about.

            Start by updating your profile with a real handle instead of "911338".

            Then provide the following information about your APEX set-up:

            <li>Full APEX version
            <li>Full DB/version/edition/host OS
            <li>Web server architecture (EPG, OHS or APEX listener/host OS)
            <li>Browser(s) and version(s) used
            <li>Theme
            <li>Template(s)
            <li>Region/item type(s)

            With APEX we're fortunate to have a great resource in apex.oracle.com where we can reproduce and share problems. Reproducing things there is the best way to troubleshoot most issues, especially those relating to layout and visual formatting. If you expect a detailed answer then it's appropriate for you to take on a significant part of the effort by getting as far as possible with an example on apex.oracle.com before asking for assistance with specific issues, which we can then see at first hand.

            Import what you've done so far to apex.oracle.com, post shared developer credentials to your workspace here, and re-describe the problem with reference to that implementation.