Posted By : Dan Wilson     August 10, 2007 8:03 AM

A word of caution. When working with Stored Procedures in a development environment, do yourself a favor and untick the 'Maintain Database Connections' option.

If a stored procedure call results in an error, Maintaining Database Connections will sometimes cache the error and hand it back to you regardless of how the call is altered. These are very annoying symptoms to debug! In fact, when I first figured this out, I had already spent 4 hours the previous day combing through an Oracle stored procedure for any possible error when I logged in fresh at 8AM to find the process magically working. I felt like I was on Candid Camera. When I dug deeper, I found unticking 'Maintain Database Connections' would allow my SQL Stored Procedure calls to process fresh each time.

So you can pull out your hair if you want to, or you can untick Maintain Database Connections in your development environment.

A note, the Maintain Database Connections setting is under the Advanced Settings for a specific Datasource configuration. As far as I know, you will have to alter every datasource individually.

4041 Views Print Comments (0) Rapid Development, ColdFusion

del.icio.us Digg It! Linking Blogs

Posted By : Dan Wilson     August 1, 2007 3:03 PM

I've been humming the tune to Spider Pig all morning. Anybody know where I can get the soundtrack?

11125 Views Print Comments (1) Random

del.icio.us Digg It! Linking Blogs

Posted By : Dan Wilson     July 31, 2007 10:51 AM

On the CFEClipse mailing list today, Sonny Savage posted a link to Eclipse performance settings. I thought I would repost the link for others. Have a look at the Performance Settings for Eclipse.ini

Also, for posterity, the CFEclipse Wiki has other interesting articles such as:
Installing RDS support
Line Numbers (a common question)
Restoring Deleted Files
The Preference Pane

If you use eclipse, you owe it to yourself to read over the Table of Contents for the CFEclipse Wiki.

7819 Views Print Comments (0) CFEclipse

del.icio.us Digg It! Linking Blogs

Posted By : Dan Wilson     July 24, 2007 3:21 PM

Today we will install the Transfer ORM inside our Contact-O-Matic application. To complete this tutorial, you should have the Contact-O-Matic installed and running. If you have not completed this step, please create the database described at the bottom of Series 6 and install the files at Series 10 download link. Test the application by manually adding several ContactTypes to the ContactType table in your database (I chose Co-Worker, Enemy, Friend). Then use the Contact Form in the ContactOMatic application to enter a few contacts.

[More]

13131 Views Print Comments (5) Rapid Development, ColdFusion, Tutorials, Model-Glue

del.icio.us Digg It! Linking Blogs

Posted By : Dan Wilson     July 23, 2007 7:53 PM

I just rediscovered a sweet list of Cheat Sheets at Pete Freitag's blog. I find the cheat sheets very helpful for syntactical questions for common tasks. The list is fairly extensive and covers 30+ topics:

• Apache
• Postgres
• Google
• Java

There are extra links at the bottom of the post...Thanks Pete!

Update: Nick Tong maintains another good list of cheetsheets

4309 Views Print Comments (0) Rapid Development

del.icio.us Digg It! Linking Blogs

Posted By : Dan Wilson     July 23, 2007 12:31 PM

A long time ago in a land far far away, my no-brainer choice for new computers was Dell. I recommended Dell systems over the years as the safe option for businesses, friends and neighbors. In the last year, I have made an about face.

[More]

7022 Views Print Comments (0) Random

del.icio.us Digg It! Linking Blogs

Posted By : Dan Wilson     July 23, 2007 12:14 PM

I was poking around the web today and found a nice post from Doug Hughes about an SQL server issue. The post was commented 88 times. Many people showed their gratitude to Doug for posting the solution to a vexing problem. One commenter takes the cake however:

To which Joe Reinhart replied to, rather Tongue in Cheek:

Then I laughed even harder when I read: (I placed the x's in there. I have a conscience.)

Wow! I'd love to know what happened to that server.....

5205 Views Print Comments (0) Stupidity

del.icio.us Digg It! Linking Blogs

Posted By : Dan Wilson     July 12, 2007 9:26 AM

I recently slicked the development environment on one of my laptops and reinstalled everything; ColdFusion, Flex Builder, Eclipse etc.

While testing, I found I could create and run basic projects but creating a Flash Remoting project does not work.
Even if the new application contained simply an mx:application tag and a mx:panel tag, it would throw two runtime errors:

Tom and João pointed me to a hotfix for FlexBuilder at http://www.adobe.com/go/kb402000. After installation of the hotfix, the errors went away. I should have looked for a hotfix, but since I downloaded a fresh binary, I thought I was above the law! No one is above the law, are they?

5480 Views Print Comments (0) Flex

del.icio.us Digg It! Linking Blogs

Posted By : Dan Wilson     July 11, 2007 11:32 AM

Man, am I glad I am not a resident of Virginia. Those who are should be mindful of a new law put into effect July 1st, the date new laws go into effect in the Commonwealth. Commonwealth, defined as "government based on the common consent of the people", took on on a spurious new meaning July 1st in House Bill 3202 with the addition of Civil Remediation Fees. What is a Civil Remediation Fee, you ask? Allow me to present two scenarios:

[More]

9844 Views Print Comments (0) Personal

del.icio.us Digg It! Linking Blogs

Posted By : Dan Wilson     July 10, 2007 10:44 AM

Taking the decision to learn OO programming can be a confusing route. With all the new and complicated taxonomy, variety of opinions and general annoyances of OO programming, where do you turn for advice?

Doesn't it seem that most OO discussions take place on the ModelGlue or MachII mailing list? While that is true, I would like to point out two resources that are truly gems. The #ColdFusion channel on Dalnel IRC is a great place to ask questions and get help. Staffed by a set of ColdFusion Experts, simply join the channel, introduce yourself and ask away...

The second resource is the CFCDev listserv. This listserv has been in operation since CF6 came out. The focus is on OO programming and spans across the various frameworks and methodologies across the ColdFusion landscape.

I confess to having read each one of the archived posts early on in my transition to OO programming. You can find the Archives for CFCDev as well as the Registration for CFCDev

Happy Programming!

4112 Views Print Comments (0) ColdFusion

del.icio.us Digg It! Linking Blogs