Fusioncube

The online journey of a technophile, by Steve Brownlee

Archive for the ‘database’ Category

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

Figured this one out by sheer, dumb luck. driverManager = createObject("java","java.sql.DriverManager"); conn =...

Preventing SQL Injection

August 28, 2008 | In: cfml, database

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

Visio IDEF1X Format

June 18, 2008 | In: database, tools

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

Latest Tweets

  • Watch video on this page to see a quick shot my family's biz and a heapin' helpin' of Pittsburghese - http://bit.ly/aMxuLN
  • Ever wonder how insignifcant the Earth is on a cosmic scale? http://bit.ly/PV4o
  • How did I miss this highlight??? Hasek takes out Gaborik http://su.pr/1KZtN2
  • Rooted & upgraded my HTC Hero w/#Froyo. Holy shit is it faster and have improved features. Painless, too. http://bit.ly/cBjvuH #fusprint
  • @Antipimp You will do what Father Jobs tell you to do, peon.