Today (nov. 6th 2012), the book ‘APEX Best Practices’ written by Learco Brizzi, Iloon Ellen-Wolff and Alex Nuijten was finally released. I was curious about the book, for several reasons: I promised the book to the winners of my FifApex…
Uncategorized
Remember Me – APEX Autologin
by Christian Rokitta • • 2 Comments
Let’s start CREATE TABLE my_custom_users( username VARCHAR2(25 BYTE), password VARCHAR2(250 BYTE), token VARCHAR2(25 BYTE)); INSERT INTO my_custom_users(username, password, token)VALUES (‘DEMO’, my_cust_auth.encodeit(‘DEMO’, ‘demo’), NULL);COMMIT; Step 1: setting the cookie during login Step 2: using the cookie on return Now, when do…
Uncategorized
Dynamic Date Range in APEX Datepicker – no Plugin required
by Christian Rokitta • • 0 Comments
The Basics: jQuery Datepicker in APEX Let’s Get Set it Well, it works! This is what the Datepicker looks like after setting the min- and maxDate. Wrap it up If now we combine getting the values of the Min./Max. Date…
Uncategorized
APEX Tabular Form: focus cursor on first element of new row
by Christian Rokitta • • 0 Comments
I just got the question from a fellow developer, how to focus the cursor to the first input field of a newly added row using the ADD button in a standard APEX Tabular Form. Actually, I would expect APEX to…
Uncategorized
Running Standalone APEX Listener as Windows Service
by Christian Rokitta • • 0 Comments
The storm had now definitely abated, and what thunder there was now grumbled over more distant hills, like a man saying “And another thing…” twenty minutes after admitting he’s lost the argument. Source Article from http://rokitta.blogspot.com/2012/08/running-standalone-apex-listener-as.htmlRunning Standalone APEX Listener as…
Apex
Setting an apex-item from PL/SQL
by Richard Martens • • 0 Comments
Got it from Andy’s Blog: Within ApEx PL/SQL Processes, regions and items you can use the bind variable syntax (:PX_MY_ITEM) both to read and set the value of that item held in session state. Like so: :PX_MY_ITEM := ‘wibble’; l_my_local_variable…
