May 19, 2010 | In: coldfusion, oracle, paging
I learned something new today. Using ROWNUM in an Oracle query, while it does limit the resultset to the number specified, does not limit it to the top n results. It’s basically a random sample because it appears that ROWNUM is calculated...
February 25, 2010 | In: coldfusion, oracle
Figured this one out by sheer, dumb luck. driverManager = createObject("java","java.sql.DriverManager"); conn =...
An old client of mine recently contacted me with a problem. Their home page, several sub-pages, and the administrative section weren't displaying properly and functionality was broken. Turns out, they were a victim of the recent swarm of SQL injection...
I just discovered, about 4 days ago, that you can format Visio database diagrams in the IDEF1X format. While IDEF1X has many shortcomings, I have to say I find it much easier to understand the relationships and constraints at a quick view in this format...
Ok, I just learned how to do levels and partitioning in an Oracle query today, and I have to say it's pretty cool. Basically, I have a view that returns groups of data; i.e. multiple rows with matching "key" attributes but different non-prime...