14 Replies Latest reply: Dec 5, 2013 6:25 AM by Pars RSS

    Image galary display based on next & previous button

    Vedant

      Hi,

      I am showing Image galary on next & previous buttons.i am writting this code on region type( pl/sql anonymous block). it i sgiving the error

       

      • ORA-06550: line 24, column 34: PLS-00103: Encountered the symbol "?" when expecting one of the following: ) , * & - + / at mod remainder rem <an exponent (**)> and or using || multiset.

      in code my <img src="images/001.jpg" class="cube" /></a>   line  i want to replace with my table images.what should i write here .In source what should i write.

      my code is:-

       

      {code}

      DECLARE

      rec INT_IMAGE_GALLARY%rowtype;

      v_id varchar2(10);

      begin

      htp.p('

      <html xmlns="http://www.w3.org/1999/xhtml">

      <head>

      <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

      <title>Intercruises</title>

          <link href="#WORKSPACE_IMAGES#skitter.styles.css" type="text/css"

      media="all" rel="stylesheet" />

          <script src="#WORKSPACE_IMAGES#jquery-1.6.3.min.js"></script>

          <script src="#WORKSPACE_IMAGES#jquery.easing.1.3.js"></script>   

          <script src="#WORKSPACE_IMAGES#jquery.skitter.min.js"></script>

       

      <script>

        $(document).ready(function() {

       

        var options = {};

       

        if (document.location.search) {

        var array = document.location.search.split('=');

        var param = array[0].replace('?', '');             // This line is giving Error ?

        var value = array[1];

       

        if (param == 'animation') {

        options.animation = value;

        }

        else if (param == 'type_navigation') {

        options[value] = true;

        if (value == 'dots') $('.border_box').css

       

       

      ({'marginBottom': '40px'});

        }

        }

       

        $('.box_skitter_large').skitter(options);

       

        // Highlight

        $('pre.code').highlight({source:1, zebra:1, indent:'space',

       

       

      list:'ol'});

       

        });

        </script>

      </head>

       

       

      <body>');

      FOR REC IN (SELECT id,dbms_lob.getlength("GALLARY_IMAGE") AS GALLARY_IMAGE FROM INT_IMAGE_GALLARY WHERE upper(IMAGE_NAME) LIKE upper('Interc%'))

      LOOP

      htp.p('

      <table width="560" border="0" cellpadding="0" cellspacing="0">

        <tr>

          <td><div class="box_skitter box_skitter_large">

        <ul>

          <li><a href="#cube"><img src="images/001.jpg" class="cube" /></a>   // i have to add my table images here how can i write code here to display images

        

            <div class="label_text">

              <p>cube</p>

            </div>

          </li>

       

       

      </ul>

      </div></td>

        </tr>

      </table>');

      end loop;

       

       

      htp.p('</body>

      </html>');

      end;

      {code}

       

      thanks & Regards

      Vedant