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="application/msword" >
also tried
<cfcontent type="application/vnd.ms-word" >
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?
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?
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="qTrainer">
select FirstName,LastName
from trainer
where
<cfloop list="#session.Event.selTrainerID#" item="i">
userid = '#i#' or...
...rows in table B whose keys do not match any keys in table A.
Assuming that both tables have exactly the same column names and datatypes:
select *
from A,B
where A.key = B.key
and (A.non-key-col1 <> B.non-key-col1 or A.non-key-col2 <> B.non-key-col2 or ...)
union
select *
from A,B...
Oops! I put an extraneous semicolon in there. The correct syntax should be this.
<cfset x = ListLast("http://www.mysite.com/cats","/")>
If all you want to do is capture the word "cats", try this
<cfset x = ListLast("http://www.mysite.com/cats","/")>
x should equal cats.
I would first look at the code being executed rather than the server. Sounds like there could be a problem with application or session variable locks locking eachother out.
You can set the server for single thread access and see if this addresses the problem.
How do you set up a virtual directory (sometimes called a web server mapping) in Apache? I want to be able to reuse images on various subsites of a site, and I would like to just be able to specify the path to the images as /images/image1.gif regardless of which directory I am in. Anybody know...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.