Dec 12
Recently I was asked how to programmatically verify ColdFusion DataSources. I came up with a few methods of doing so. Each have their pros and cons.
Method #1 : Try/Catch using cfquery
PROS:
- Can test for “datasource” specific behavior by using a custom cfquery. If you do this, the query may not work for other datasources, thereby not actually testing the validity of the datasource.
CONS:
- Uses try/catch.
- Does not work with all datasources. I don’t know of a cfquery that will work for all datasources / DBs / etc
NOTES:
This is my least favorite, because I couldn’t come up with a cfquery to test *all* datasources. It will work for some datasources, but not all.
SOURCE:
Tagged with: adminapi • ColdFusion • datasources
Dec 08
After receiving a few emails, I’ve decided to create the following FAQ:
http://skratchdot.com/esx-wave-organizer-faq/
Tagged with: Electribe • ESX-1 • Projects
Sep 23
The other month I ran into an issue when trying to run a simple update statement on a table in SQL Server 2005. The error I was receiving was:
Cannot insert duplicate key row in object ‘MyProductView’ with unique index ‘IXCL_MyProductView’
Tagged with: Database • SQL • SQL Server 2005
Sep 22
When creating this blog’s theme, I decided I wanted the links in the side navigation to take up the full width of the navigation. Also, when hovering, I wanted to highlight the whole link/line. This seems like a very simple thing to do with CSS, but by default, a few of the Wordpress widgets do not allow for easy customization of the placement of the post count.