Skip to main content

ColdFusion

The official community for ColdFusion.

10000+ Posts
C
cffiddlerParticipant
 Questions
WolfShade
WolfShadeLegend
 Questions
SpreadsheetAddImage() not working

Hello, all,I'm just playing around with something and wanted to see if I could insert an image into an Excel spreadsheet cell.  I found SpreadsheetAddImage(), and I'm not having any luck with it.  The image is a PNG file, 70 x 70 pixels in width and height.<cfscript>sObj = SpreadsheetNew("testing","true"); // This is for Excel 2013, not the older versions.SpreadsheetSetCellValue(sObj,'Testing Image Insert',1,1);SpreadsheetSetColumnWidth(sObj,1,75);SpreadsheetSetRowHeight(sObj,2,75);imgBytes = FileReadBinary("D:\site\images\emblem70x70.png");SpreadsheetAddImage(sObj, imgBytes, 'png', '2,1,2,1');<cfscript><cfheader name="Content-Disposition" value="attachment; filename=test.xlsx" /><cfheader name="Content-Type" value="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" /><cfcontent type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" variable="#spreadsheetReadBinary(sObj)#" reset="true" />When I open the spreadshe

5332
WolfShade
B
brookdInspiring
 Questions
A
adams69005520Participant
 Questions
macromedia.jdbc.MacromediaDriver$InvalidLicenseException

We have ColdFusion2016 Enterprise, originally installed in trial mode but now licensed.Its running Microsoft SQL server data sources no problem.I tested a JDBC data source against Microsoft SQL Server database no problem.But when I installed Seefusion 5 and tried to use their JDBC wrapper I get an error where the data source will not connect.Here is the stack trace below;A non-SQL error occurred while requesting a connection from test.Timed out trying to establish connectionDec 01, 2017 11:40:16 AM com.seefusion.Driver connectWARNING: Unable to connectmacromedia.jdbc.MacromediaDriver$InvalidLicenseException: Use of Adobe JDBC Drivers is restricted. Drivers can only be used with Adobe server products. Please check that your license supports the requested driver.    at macromedia.jdbc.MacromediaDriver.unlock(Unknown Source)    at macromedia.jdbc.MacromediaDriver.connect(Unknown Source)    at java.sql.DriverManager.getConnection(Unknown Source)

8571
A
I
illiquentParticipating Frequently
 Questions
cfscript syntax for functions(methods) in componets

I've got the following function written in tag syntax:************<cffunction name="myQuery" returntype="query" output="false" access="remote" hint="run some query">   <cfargument name="someRequiredID" required="true" default="24">   <cfquery name="local.getThings">  SELECT ID, entry_title   FROM entries  WHERE blogID = <cfqueryparam value="#ARGUMENTS.blogid#"   cfsqltype="cf_sql_integer">    </cfquery>    <cfreturn local.getThings></cffunction>****************How can I rewrite this using script syntax?iecomponent  displayname="testQuery" {     // confusion starts here ??     // define method myQuery     public query function myQuery() {          //run some query          peopleQuery = new Query(sql="SELECT * FROM PEOPLE").

39143
I
D
danielv9128229Participant
 Questions
Serving static files in ColdFusion

Hello,I'm learning ColdFusion (have a background in web development) and have created a simple test site in ColdFusion Builder 2016. I run my site using the built in server, the one built into ColdFusion Builder 2016, runs locally on port 8600. I am trying to add my own custom CSS file, and ColdFusion can't seem to find it, keeps giving me a 404. It's a very simple CSS file with a very simple link tag:<html>     <head>         <!-- Some code here... -->         <link rel="stylesheet" type="text/css" href="footer.css" />         <!-- Some more code here... -->     </head>     <!-- Rest of the code here... -->Very simple and straightforward, but for the life of me I can't get ColdFusion to find the CSS file. Does ColdFusion not serve static content? I noticed I get the

12162
Charlie Arehart
Community Expert
義
義昭渋27371070Participant
 Questions
C
countofmontepythonParticipant
 Questions
Coldfusion and Docker Licensing

The license at http://wwwimages.adobe.com/content/dam/acom/en/legal/licenses-terms/pdf/ColdFusion-2016.pdf​ pointed me to Adobe - ColdFusion 10 for licensing questions, which simply says "Send a mail to adobecoldfusion@adobe.com for all the queries with respect to licensing".  However, when I sent a message to that address, I got a bounce saying that "adobecoldfusion wasn't found at adobe.com".  When I tried to open a ticket at Adobe ColdFusion Learn & Support, I got "If Adobe ColdFusion is owned by your company or organization, you won’t see it listed under your Adobe ID. Chat with Adobe Customer Care", but when I clicked "Chat with Adobe Customer Care", I got "Chat is currently unavailable. Please contact us during our business hours. If you receive this message during business hours, please try again" (it's currently 8:26 PST).  I guess community support is my only option .My question is about licensing for Docker.  My assumption is that we have Enterprise li

14181
D
Community Expert
Grae Desmond
Grae DesmondInspiring
 Questions
Where do we put suggestions for improving the portal?

Curious where we would put suggestions on improving the portal experience?Yesterday, I noticed the ColdBox question in the discussion category so passed it along to Brad Wood via Twitter that he may know the answer.  He made a good suggestion that there could be a Twitter bot that sent out when these posts come in.  I know i subscribe to @CFOverflow which pushes Stack Overflow questions to Twitter.  I agree with Brad it would be good to have something similar in the portal.Reading through his thread, when he did answer the question, he noted that he wasn't being notified when there were new posts in the discussion.  I think that would also be a great feature to have put in because its easy to forget to come back to check for new posts.Thanks

3371
S
R
rustyr75886939Participant
 Questions
J
johnnyo63Participant
 Questions
J
jbrock777Participating Frequently
 Questions
Missing include files - Class data cache write error issue

Good morning CF friends,   Yesterday I finally debugged an ongoing issue that we had determined was an undocumented issue with the past hotfix for CF2016 - which we now know was not entirely true.   The issue was that every so often one of our 8 JVM instances in our CF Cluster would show an error for an application that was looking at the same code base for the same application.  The cfcatch error was for missing include template files that were working great after a reboot of the same instance and fine on the other instances.   What was discovered, is that during the last update (5) the ownership had been changed to root:root on the /opt/coldfusion2016/sec-apps-2/wwwroot/WEB-INF/cfclasses contents that were existing at the time on that single instance (default behavior when applying the update).  However, there were no indicators of what the problem actually was since during a reboot everything worked great again with no errors showing up in any

5031
WolfShade
S
SoSayWeAllParticipant
 Questions
imadhasan1711
imadhasan1711Participant
 Questions
S
SemperVIKnown Participant
 Questions
D
dcjonesInspiring
 Questions
E
ectobuilderParticipant
 Questions
R
Adobe Employee
raksh nareshAdobe Employee
 Questions
ColdFusion Community Portal is now live!

At the Adobe ColdFusion Summit this year, we announced the launch of the new Community portal for ColdFusion developers.The ColdFusion community portal is a one stop portal for anything ColdFusion. Ask a question, post a blog, showcase your work, post your ColdFusion testimonial or even start a discussion. The Ask a question is linked to Adobe forums where a post will be made on your behalf on the Adobe forums.You accumulate points for every contribution you make to the community portal. You start as a newbie and move up the ladder based on the points you accumulate. For instance, if you reach the highest level, which is legend, you get incentives such as a free pass to Adobe ColdFusion Summit, including travel (within the US) and accommodation during the event.Start exploring and start sharing with your fellow developers from the ColdFusion community!

8471
A
A
Anonymous
 Questions
M
mmertelParticipant
 Questions
Andri Senjaya
Andri SenjayaParticipant
 Questions
Write Java Code In Coldfusion

Currently i use pd4ml API to generate the pdf. In pd4ml there is a feature to manipulate the header and footer. Base on tech do in java we can do the code like:PD4PageMark header = new PD4PageMark() {       public String getHtmlTemplate(int pageNumber) {            if ( pageNumber > 1 ) {                 return "<html><body>some document header stuff...";               } else {                 return "";               }           }       };  pd4ml.setPageHeader(header);currently I can call the object likepd4ml = createObject("java","org.zefer.pd4ml.

2760
Andri Senjaya
A
Anonymous
 Questions
Coldfusion 11 on windows 10

I am running ColdFusion 11 on Windows 10. My http://localhost pulls up my windows page but when I added cfm files to wwwroot it won't run anymore and I get this error code.I am simply using notepad and save my code files as cfm.Help me HTTP Error 404.3 - Not FoundThe page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.Most likely causes:It is possible that a handler mapping is missing. By default, the static file handler processes all content.The feature you are trying to use may not be installed.The appropriate MIME map is not enabled for the Web site or application. (Warning: Do not create a MIME map for content that users should not download, such as .ASPX pages or .config files.)If ASP.NET is not installed.Things you can try:In system.webServer/handlers:  Ensure that the expected handler for the current page is mapped.Pay extra attention to preconditions (for e

121944
Charlie Arehart
Community Expert
tims73796864
tims73796864Participant
 Questions
manass10781009
manass10781009Participant
 Questions
After migration from http to https, all the scheduled tasks stopped running. But URL runs in browser successfully

I am using Cold Fusion MX7 on one of many application.After the migration from http to https, all the scheduled tasks shows below error while executing from scheduled task in cf administrator :There was an error running your scheduled Task, Reason for which scheduled tasks might fail include:>The URL is a redirection URL>The URL is protected by IIS NT Challenge/Response or Apache .htaccess password. The Username and Password text fields for editing a scheduled task are intended to support Basic Authentication Only.>The Domain Name lookup failed. Try using the IP address of the domain whenever possible.> The URL is a n SSL site, but the SSL port was specified incorrectly.>The web site is not responding.>The directory specified for published results does not exists.Below are the observations against above error points.*The URL saved in scheduled tasks have https protocols- hence its not a redirection URL.*The URL does not asks for any authentication.*Domain name is corr

36504
pete_freitag
C
CSA ChemicalsParticipant
 Questions

Resources

Community Guidelines Help Center Learn tutorials
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices