You can read all about Oracle Application Express Release 3.2 new features details here.
Additional info on Joel Kallman's post about the new release.
Today, on the project’s 3rd birthday, the jQuery development team has announced the release of jQuery v1.3, the latest and greatest release of jQuery which includes a lot changes and new features like:
- Sizzle Selector Engine
- Live Events
- jQuery Event Object Overhaul
- HTML Injection Rewrite
- Offset Rewrite
- No More Browser Sniffing
Aditional details on jQuery 1.3 new features can be found via the release notes document.
This time, I'll show how to build a simple image gallery using Oracle Application Express (APEX) and taking advantage of Jquery framework capabilities. But first of all, follow the link to see the magic happening ;)
There are several slideshow or gallery plugins for Jquery. You can choose the one you like more and re-adapt the code to fit the plugin requirements. My choice was Pikachoose.
Pikachoose is a lightweight Jquery plugin that allows easy presentation of photos with options for slideshows, navigation buttons, and auto play.
Lets begin creating a simple database structure to store the images.
Create a sequence to be used by image id:
Create a table to store the images:
Now on APEX, following the wizard, create a data entry form based on "GAL_IMAGES" table.
Go to Shared Components>Application Items and Create an Application Item. Ex: G_IMAGE_ID.
Create an Application Process to retrieve the image from the database. Identify the point at which this process will run as "On Demand". The point of "On Demand" is that it will only fire when requested by a page process.
Now create the page where you want to put the image gallery and then, Edit Page > HTML Header:
On the same page, create a PL/SQL Dynamic Content region: