Developer of ProgrammingPodcasts.com. Founder of Subwoofr. Author of HTML5 in Action and Beginning CouchDB. IBM developerWorks Contributing Author.
April 24, 2014 • 2 minute read
One of the side projects I'm currently working on is a quick online ONIX for Books file validator utility. The tool is built using Node.js and Express, and I quickly ran into an issue with handling file uploads. Searching Google didn't help all that much, particularly when it com...
December 20, 2007 • 4 minute read
Flickr Services API is nothing new, and if you're using PHP, ASP.NET or any of the other major languages, there is plenty of documentation available to get you started with putting Flickr functionality in your web application. If you're using PL/SQL, however, you're stuck to comi...
December 5, 2007 • 13 minute read
I've put together a comprehensive example for paginating and sorting a table of data in a web page using PL/SQL. This example uses the all_objects table, so should be usable on any Oracle database. It is fully commented and should be pretty self-explanatory. The example uses two...
November 27, 2007 • 3 minute read
Because PL/SQL does not have the same support for arrays that other programming languages have, handling checkboxes in HTML forms can be a bit trickier than you might expect. An example on how to handle checkboxes is available on Oracle's documentation on Developing Applications...
November 23, 2007 • 1 minute read
Today I was working on a data table, output in HTML generated by PL/SQL and I needed to implement a feature that would allow the user to sort the table based on the column header they clicked on. Basically I have a procedure which takes a parameter (p_sort_by) and establishes whi...