Recent content by shammack

How do you get ColdFusion to export to MS Word? I used the CFCONTENT tag as follows, but that does not work for me. <cfcontent type=&quot;application/msword&quot; > also tried <cfcontent type=&quot;application/vnd.ms-word&quot; > Neither work. Any advice?

ColdFusion MX does not appear to support drill down on graphs at the data bar or pie slice level (whereas ColdFusion 5 did). Is this feature really gone?!! If so, does anybody have any suggestions for how to produce dynamic drill down graphs?

Nevermind. The problem was with the driver.

The error message seems to suggest that you have not assigned a value to the variables AGCY_AGENT_CODE. Is this really a variable, or is it the name of a column in your table? The syntax in the SUBSTR command is probably wrong. Try this if AGCY_AGENT_CODE is actually a column name select...

I have an Oracle stored procedure that returns a result set. It works fine in SQL+, but I am having trouble with the syntax in ColdFusion. I keep getting an error WRONG NUMBER OR TYPE OF PARAMETERS. Does anybody have any examples of CF code that actually works?

Does anyone have any ideas of how to resolve a '500 Internal Server Error' related to using CFX_ZIP on a Cold Fusion server. The error is being generated when one scheduled task creates a zip file of the inetpub/wwwroot directory and all subdirectories on a CF server. When this was tested on...

Is it company specific? Maybe it is, I don't know.

Is there a way to derive the fiscal year from a date?

Have you tried using the SETDOMAINCOOKIES attribute in the <CFAPPLICATION> tag?

Does anyone have any ideas of how to resolve a '500 Internal Server Error' related to using CFX_ZIP on a Cold Fusion server. The error is being generated when one scheduled task creates a zip file of the inetpub/wwwroot directory and all subdirectories on a CF server. When this was tested on...

I don't know of any existing code to do this either. You could write a custom tag to do it though. If you really need it in your app, it wouldn't be that difficult.

You may want to consider making your ID's numeric. This problem with the quotes in the IN clause when you pass it a list does not exist for lists of numeric data. Alternatively, another option is to use a stored procedure to parse your list rather than attempting to do it with ColdFusion in...

I have a reply to your original question. This isn't very elegant, but it should work. <CFQUERY NAME=&quot;qTrainer&quot;> select FirstName,LastName from trainer where <cfloop list=&quot;#session.Event.selTrainerID#&quot; item=&quot;i&quot;> userid = '#i#' or...

The O'Reilly book on ColdFusion 5.0 is excellent.

Seems like there are three different kinds of differences you might be interested in. This might require three queries or one query with two unions inside of it. For the natural inner join between the two tables, i.e., rows with the same key, you can easily extract the rows whose non-key...