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…


About Steve

I am a technologist, and have been ever since 1980 when I got my very first TRS-80 and programmed it to do my math homework. I love to share the gift of technology with others and show them the wonderful things it can do for them, and how they should not fear it, but embrace it.

Latest Tweets

  • This is an awesome idea, that would likely be heavily abused..."Connecting Web Apps with Web Intents" http://t.co/QAU4DNcF
  • It is exciting working in a startup in a booming, emerging industry.
  • Absolutely loving the new changes to the Scripts app in Chrome dev tools. Thanks @ChromeBrowser team!
  • AR Will Turn Your Living Room into Mario’s Next Level http://t.co/8gZvmKpu

Subscribe

Entries (RSS)
Comments (RSS)