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>
<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