I am always forgetting the syntax for the APEX URL construction.
http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21674/concept_url.htm
f?p=App:Page:Session:Request:Debug:ClearCache:itemNames:itemValues:PrinterFriendly
1-App:
2-Page:
3-Session:
4-Request:
5-Debug:
6-ClearCache:
7-itemNames:
8-itemValues:
9-PrinterFriendly
Martin always seems to have figured out a question I currently have, but he did it months ago. This is a great article and example of doing an APEX backup using a windows Batch File. This does not replace database backups, but will let you recover a single application if needed. In DBA terms, only the records needed are extracted.
http://www.talkapex.com/2012/04/command-line-backups-for-apex.html
For my notes and reference:
http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21676/apex_mail.htm
-- send to the APEX mail API APEX_MAIL.SEND( P_TO => V_TO, P_FROM => V_FROM, P_BODY => V_BODY, P_BODY_HTML => V_BODY_HTML, P_SUBJ => V_SUBJ, P_CC => V_CC, P_BCC => V_BCC, P_REPLYTO => V_REPLYTO ); -- Push the e-mail out APEX_MAIL.PUSH_QUEUE;
/* APEX_MAIL.SEND( p_to IN VARCHAR2, p_from IN VARCHAR2, p_body IN [ VARCHAR2 | CLOB ], p_body_html IN [ VARCHAR2 | CLOB ] DEFAULT NULL, p_subj IN VARCHAR2 DEFAULT NULL, p_cc IN VARCHAR2 DEFAULT NULL, p_bcc IN VARCHAR2 DEFAULT NULL, p_replyto IN VARCHAR2); */
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,’ ’));
});
</script>
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.
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!
I am getting ready for my presentations in Dallas, TX this year. New stuff for me. I will be posting updated presentations back here.
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.
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.
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.
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.