Padding LOV with spaces

A quick way to take escaped characters back to their “expected” form.

Script Used:  This script searches for all of the OPTION tags that are used in the page, then does a regular expression to replace them with values that will be interpreted by the browser.
It is recommended to place this script at the bottom of the page in a standard – no tempalte region with a name that identifies it’s purpose.
 
<script>
    $(‘option’).each(function(index) {
      $(this).html($(this).text().replace(/\&NBSP;/g,’&nbsp;’));
    });
</script>

Updated Slides from KScope 11

For those interested in seeing the updated slides from KSCOPE 11 – you are in the right place.

 

The final copy will be placed in this post.

KScope 11

If you are interested in learning about Oracle development technology, or just heading to California, Check out the ODTUG KScope 11 conference.  It is a great time and a great way to learn about what other developers are doing with the Oracle tools you may already own!  Leverage you investment and come to the KSCOPE 11 conference!

Final Perparations for APEXposed 2010

I am getting ready for my presentations in Dallas, TX this year.  New stuff for me. I will be posting updated presentations back here.

Oracle Open World 2010

On the first day of OpenWorld – I had the privelage of being one of the first presenters.  It was a great venue in Moscone West.  It should be an amazing week with so much information, the challenge is deciding what to go see.  You have not choice – you will miss something.

I have uploaded my presentation “Open World – Case Study – Prioritization”  here for sharing.

Word Press – Duplicate Home Links

If you find yourself using WordPress as a framework for maintaining a webseite, and you are interested in having a STATIC home page, rather than the BLOG, you may have encountered the issue where you have TWO home links on your navigation bar.

WordPress Two Homes

One option is to use the WordPress suggested “parent page selection” option.  Basically, this option allows you to identify your static home page as having a parent.  If the template only shows the TOP of this tree, this will work.

If the template also shows “Children” this may not produce the results you want.

The more direct option is to modify the template you are using.  Depending on who and how your template is written, it may have a hard coded HOME link.  The one that I was testing at the time did.  I was able to find the link under:

Appearance – Editor – Header.php

Looking through the code, you will find something similar to this.  The note here is the <li tag and the HOME text.

<li <?php if(is_front_page()) { ?>class="current_page_item"<?php } ?>><a href="<?php echo get_option('home'); ?>/">Home</a></li>

All I did was comment out this list item with html comment tags.

<!--li <?php if(is_front_page()) { ?>class="current_page_item"<?php } ?>><a href="<?php echo get_option('home'); ?>/">Home</a></li -->

That should result in only a single home link.. The PAGE link.  This process removes the DEFAULT home that would normally point to the BLOG page.

Note – Fix the order by the order value in the page setup.  Results may very depending on your source template.

APEX and AJAX – Where to Start

For those looking for the demonstration link given at the ODTUG Kaleidoscope 2010 in DC session APEX and AJAX – Where to Start. I have updated the presentation to also include an example of how to use the new Dynamic Actions to accomplish a similar goal.

I have also uploading the new version of the  APEX & AJAX – Where to Start Presentation.  If you have questions – or find this useful, let me know.

UPDATE – Apex and AJAX – Where to Start Application Download is now available.  This is both the 3.2.1 and 4.0 versions of the application.  Static files are included to support the syntax highlighter.

APEX 4.0 Released

Oracle has released the APEX 4.0 today!  This is a big release for APEX and should open several doors to the developers who use the technology.  Very exciting day, and I will be attempting an upgarde as soon as I get 15 minutes to rub together!

BI Publisher – Patch 9546699 – Left and Right Justify

As I go on in my career, I have been learning the adage – “If it ain’t broke, don’t fix it.”  Sometimes that is much very hard for me to remember.  Case in point today is Oracle’s BI Publisher.  Patch 9546699 was released in March 2010.  No major or minor revision – but was touted as having additional functionality buried inside.  Oooooo…  How I love new stuff.  And by golly – Tim Dexter even blogged about it.

So – Let’s give it a whirl.  Looks Good.  Standard stuff.  Installed fine.  A few little bits and pieces here and there.  A credit to testing: we kept the new version in development for a while, then one of my developers came across an anomaly.

Issue:
Tables do not center and right justify correctly from the templates to the output.

Now this is difficult to explain because some justification works..  Text IN a table seems to work fine, but small tables – that are defined as stand alone (not 100% width) templates are not justifying correctly.

The best way to see this is with pictures.

This is the behavior of the base 10.1.3.4.1 installation

After the Patch 9546699 is applied

I reviewed the notes on the patch – and it outlines that you should also update BUILDER to make sure you have a standard expectation of what will be seen.  The funny part is that the BUILDER also produced the same issue when replacing the xdocore.jar as outline in the notes.  (see Oracle note 797057.1)

Points for consistency – and narrowing down the real source of the issue.

At the moment – with something as basic as the Left and Right justification being damaged in the patch – I would not recommend deploying the update at this time.

Also – to Oracle – PLEASE PLEASE update the minor revisions so that we can better keep track of when errors occur.  So many updates have been done to the 10.1.3.4.1 platform.. it is hard to determine which versions have issues and which do not.

ODTUG Kaleidoscope 2010

ODTUG Kaleidoscope 2010

ODTUG Kaleidoscope 2010

If you work with the Oracle Database or any of the related technologies, you would be well served to take a look at the Oracle Developer Tools User Group conference in DC.

I will be presenting this year.  The topic titled “APEX and AJAX – Where to Start“.

I will be posting follow up material here.  Check back soon.