Joe Lennon

Developer of ProgrammingPodcasts.com. Founder of Subwoofr. Author of HTML5 in Action and Beginning CouchDB. IBM developerWorks Contributing Author.

File Uploads with Express 4.0

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...

Tags: express.js, node.js, node, express, javascript, file upload, upload

Using Flickr API in PL/SQL

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...

Tags: oracle, database, pl/sql, plsql, flickr api, mod_plsql

PL/SQL Pagination and Sorting Example

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...

Tags: oracle, database, pl/sql, plsql, pagination, sorting, mod_plsql

PL/SQL and HTML Form Checkboxes

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...

Tags: oracle, database, pl/sql, plsql, checkboxes, mod_plsql

Using Parameters in Order By Clause in PL/SQL

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...

Tags: oracle, database, pl/sql, plsql, sorting, order by