Tuesday, December 22, 2009

Follow-up on my "Flexible Parameter Passing" post

I had some reactions on my post, describing an issue that occurred when using the DHTMLX library in combination with APEX:

From Bharadwaz (Bharat) Pappu , Subject: ODTUD- Oracle APEX + DHTMLX integration

Hello Christian,

The presentation at APEXPOSED will be similar to the one I did at ODTUG.

There is one huge change though…Instead of making changes to the .js files or the DHTMLX APIs I use a very powerful DHTMLX API to integrate it  with Oracle APEX.

As promised to you earlier here is a snippet of the code that will work without changing any APEX or DHTMLX APIs:

<link rel="STYLESHEET" type="text/css"
      href="/i/javascript/.../dhtmlxSuite/dhtmlxtree/samples/common/style.css">
<link rel="STYLESHEET" type="text/css"
      href="/i/javascript/.../dhtmlxSuite/dhtmlxtree/codebase/dhtmlxtree.css">
<script  src="/i/javascript/.../dhtmlxSuite/dhtmlxtree/codebase/dhtmlxtree.js"></script>
declare
lv_url varchar2(1000):='f?p='||v('APP_ID')||':31:'||v('SESSION')||'::::P31_ID,P31_UID:';
BEGIN
htp.p('
<div id="treeboxbox_tree" 
   style="width:350; height:600;background-color:#f5f5f5;border:1px solid Silver;overflow:auto;">
</div>
<br><br>
<script>
  tree=new dhtmlXTreeObject("treeboxbox_tree","100%","100%",0);
  tree.setImagePath("/i/javascript/.../dhtmlxSuite/dhtmlxtree/codebase/imgs/csh_bluebooks/");
 
  tree.setXMLAutoLoadingBehaviour("function");
  tree.setXMLAutoLoading(function(id){
       tree.loadXML("'||lv_url||'"+id+","+(new Date()).valueOf());
     });

  tree.loadXML("'||lv_url||'");

  tree.attachEvent("onOpenStart", function (id, state) {
       tree.setItemImage(id, ''ajax-loader.gif'',''ajax-loader.gif'');
       return true
    });  

  tree.attachEvent("onOpenEnd", function(id, state) {
       tree.setItemImage(id, ''folderOpen.gif'',''folderClosed.gif'');
    });
</script>');
END;

The highlighted piece of code is the substitution for my previous integration technique (which worked but not a classy way to do bussiness)…hope you like it.

Thanks

Bharadwaz (Bharat) Pappu

From Peter Raganitsch, Subject: Your Blog posting about mod_plsql flexible parameter

Hi Christian,

I found your blog posting and learned something about flexible parameters.
Very interesting!

I just wanted to tell you, that most dhtmlx-components have a method called preventIECaching(false); to turn off sending of the additional parameter in IE.

brgds
Peter

0 comments:

Post a Comment