Fusioncube

The online journey of a technophile, by Steve Brownlee

Archive for February, 2010

ColdFusion DSN Listing

Thursday
Feb 25,2010

Speaking of ColdFusion DSNs, here’s a fun code snippet. Want to see a list of DSNs that are currently set up on a box?

<cfscript>
factory = createObject("java", "coldfusion.server.ServiceFactory").DataSourceService;

sources = {};
sources = factory.getDatasources();
</cfscript>

<cfdump var="#sources #" />

Pretty simple.

ColdFusion DSN-free Oracle Connections

Thursday
Feb 25,2010

Figured this one out by sheer, dumb luck.

<cfscript>
driverManager = createObject("java","java.sql.DriverManager");

conn = driverManager.getConnection("jdbc:macromedia:oracle://111.11.11.111:1521;SID=mySID;serverName=111.11.11.111;user=**********;password=**********");

stmt = conn.createStatement();
recordSet = stmt.ExecuteQuery("select * from table order by 1 desc");
results = createObject("java", "coldfusion.sql.QueryTable").init(recordSet);
</cfscript>

<cfdump var="#results#">

The trick was to add the username and password as properties of the connection string rather than having them inline.

This fails

driverManager.getConnection("jdbc:macromedia:oracle:username/password/111.11.11.111:1521;SID=mySID;serverName=111.11.11.111;")

CFDude Eclipse Splash Screen

  • Filed under: errata
Thursday
Feb 25,2010

Using LiveBrush and Fireworks, I was able to replace my boring Eclipse splash screen with this new awesomer one starring the CF Dude!!

CFDude Splash Screen

Bumbo Seat Hand-Me-Down

  • Filed under: errata
Thursday
Feb 18,2010

The Bumbo Seat was an invaluable tool for us as parent of infants. It kept both Sabrina and Tessa secure, strengthened their sitting muscles, and allowed them to be wherever we were without the fear of getting into things they shouldn’t be getting into.

It was one of Tessa’s first hand-me-down’s from Sabrina.

Michelle took this video when Tessa was about 2.5 months old because she had recently discovered her own voice and was squawking and squealing on a regular basis. That is, of course, until we turned the camera on (kids have an amazing ability to NOT do what you want when you are filming them).


Kids and Cake

  • Filed under: errata
Thursday
Feb 18,2010

Another video found during the backup process.

We went back home to Pittsburgh for Sabrina’s first birthday so we could celebrate with the whole family. My mother had a cake for Sabrina, and she wasn’t quite sure what to make of it. She’d never even seen a cake before, so she had no idea that it was sugary deliciousness.

Well, after some initial investigation, she decided that cake was pretty darn good…


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.