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

  • Ok... stayed up way too late trying out website designs for my wife's new nonprofit. The kids will be getting me u... — http://t.co/QrKh5iBI
  • Am I the only one who likes Google’s new privacy policy? http://t.co/qwcym5wH
  • All that time wasted learning the .NET framework - Fusioncube - http://t.co/krANoWmg
  • @marcesher libraries like Less only do what you tell them. You can make a mixin to do that, but it doesn't assume anything (which is good)
  • Circus about to start. Girls are so excited they can't stand it!!!! (with Sabrina and Tessa at @BrdgstoneArena) [pic] — http://t.co/PXwi5emj

Subscribe

Entries (RSS)
Comments (RSS)