Team Ravenglass

The other week I noticed some of the Jobs that we have scheduled in our MSSQL setup had started repeatedly failing. They were giving the message, "MSSQL: The owner () of job <Job Name> does not have server access".

I thought this was weird, especially since other jobs were running fine. I investigated a little further and found this forum that discussed this issue.

What I gathered is that if using the DOMAIN/Username (Windows Login) syntax for the Owner field when setting up a job, sometimes after a server restart it has trouble verifying the admin privileges to allow the job to actually run.

The ways to fix this are:

[More]

This entry was posted on March 11, 2011 at 2:09 PM and has received 856 views. There are currently 0 comments. Print this entry.

One problem that I ran into while creating PDF's in Coldfusion recently was with including images. Despite using what I thought was a valid path (since it would show up in my browser) and using the correct syntax, my images were showing up as red x's. I found out that there is a little trick to including images in a PDF in CF.

[More]

This entry was posted on June 9, 2010 at 5:26 PM and has received 2979 views. There are currently 10 comments. Print this entry.

I figured when I first started this project that it would require the use of CFPDF in order to create a PDF in Coldfusion - wrong. CFPDF is only used to manipulate already existing PDF's.

It is the CFDOCUMENT tag that you use to actually do the initial creation.

Here is an example of how you would create a PDF and output it to the browser window:

[More]

This entry was posted on May 13, 2010 at 12:14 PM and has received 1515 views. There are currently 0 comments. Print this entry.

I ran into an interesting issue today where I was trying to grab some query information from Coldfire but none of the Coldfusion information would load. I went into Coldfusion Administrator and double checked that my IP Address was in the "Debugging IP Addresses" listing. I then opened up a couple other pages and Coldfire was able to pick up the necessary information from them.

[More]

This entry was posted on March 17, 2010 at 5:25 PM and has received 591 views. There are currently 0 comments. Print this entry.

This was an interesting error that I encountered today. About two months ago, I added a bunch of cfqueryparams to the page that began returning this error today, "Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type.". I assumed the value being passed to the cfqueryparam was actually invalid.

[More]

This entry was posted on February 19, 2010 at 6:13 PM and has received 791 views. There are currently 1 comments. Print this entry.

Last week one of my team members gave a presentation to the rest of us on Coldbox. We are using this framework for a project and we were discussing the basics of convention and how to work with the different layers - which brought up the question, where exactly is the optimal place to put the Javascript in this?.

I used this opportunity to bring up the CFHTMLHEAD tag, which allows you to place code into the head tag from anywhere on the page. This would allow us to keep Javascript from loading on unnecessary pages and still keep everything componentized. I also thought this would be a good opportunity to discuss basic CFHTMLHEAD usage.

[More]

This entry was posted on February 9, 2010 at 11:53 AM and has received 850 views. There are currently 0 comments. Print this entry.

I ran into a situation this past week where I wanted to forward a user from one page to another page then send the user back to the original page (using CFLocation). While attempting this, the page that we CFLocation to was returning a blank cgi.http_referer value (I was expecting it to return the HTTP Referer as the page that had the CFLocation on it).

[More]

This entry was posted on January 6, 2010 at 12:23 PM and has received 957 views. There are currently 0 comments. Print this entry.

First off, let me define what exactly a 404 page is. An HTTP 404 error message is a standard response code indicating that the client was able to communciate with the server but the server could not find the page requested. In Coldfusion, by default, the server (IIS) doesn't check that .cfm files exist but rather lets Coldfusion handle that. The result is one of those ugly blue and grey error screens that aren't picked up by the normal 404 methods or by our Application.cfm's error handler.

[More]

This entry was posted on December 23, 2009 at 4:47 PM and has received 860 views. There are currently 1 comments. Print this entry.

Here is a neat Javascript tool that I recently discovered: Firebug Lite – a Javascript library that integrates Firebug into the DOM of any browser (like Internet Explorer, Chrome and Safari).

[More]

This entry was posted on December 10, 2009 at 6:50 PM and has received 522 views. There are currently 0 comments. Print this entry.

This past week, I decided to try using the Coldfusion tag CFTOOLTIP in CF8 for the first time, to show a message to our users.

What this tag does is generate a tool tip when the user hovers over the item that is between the CFTOOLTIP tags. Here is an example:

[More]

This entry was posted on October 30, 2009 at 2:42 PM and has received 1764 views. There are currently 0 comments. Print this entry.