Questions

Bonjour,Je voudrais faire un forum avec question, réponse, commentaire.J'ai fait un select avec un query group mais les réponses ne s'affichent que si elle a au moins un commentaire !!@<CFQUERY name="Details2" datasource="#session.dbname#">   SELECT       Forum_Reponse.RID,    Forum_Reponse.PID,    Forum_Reponse.Rmessage,    Forum_Reponse.RDateReponse,        Forum_Comment.CID,    Forum_Comment.RID,    Forum_Comment.PID,    Forum_Comment.Cmessage,    Forum_Comment.CDateReponse       FROM Forum_Reponse,Forum_Comment    WHERE Forum_Reponse.PID=9    And Forum_Reponse.RID=Forum_Comment.RID   ORDER BY Forum_Reponse.RDateReponse,Forum_Comment.CDateReponse   </CFQUERY>.Merci pour votre aide.Cordialement

Hello community members!I have recently installed Coldfusion 11 standard onto a windows 2012 dedicated server with a hosting provider.  During installation, I chose the production profile.I have 2 main questions that I can seem to find the answers too.1.  How can I connect to the Cold Fusion administrator page via a web browser on my computer without using remote desktop to connect to the dedicated server and running the web browser there.2.  How can I get Dreamweaver and Coldfusion Building to connect to the server using RDS?  The furthest I have gotten on getting this setup, is that I am able to connect to the server, it shows the directory I told settings to connect to, but does not show any of the files or folders.  If I try to create a file or folder, it says I do not have permission.3.  Any web sites I setup in IIS, i have to use the coldfusion configurator in order for it to process coldfusion pages.I am moving the sites from an older hosted server

We have many clients that all have multiple web sites.  The majority of the web sites, we do not host.  If I wanted to look up when their SSL certificate was going to expire and proactively notify them, does anyone know any way to do this through CF9?I've done the following, but I don't get the information from the header that I'm looking for:<cfhttp url="https://www.amazon.com" result="out"></cfhttp><cfdump var="#out#" />However, in PHP, I simply set the following options before calling curl:curl_setopt($ch[$i], CURLOPT_VERBOSE, true);curl_setopt($ch[$i], CURLOPT_CERTINFO, true);VERBOSE enables more infoCERTINFO enables the certificate information to pass in the headerthen curl_getinfo() on my curl handler and it's in an array.I ended up using PHP for this task, but it seems there ought to be a way to do it in CF.Thanks for any thoughts anyone might have!

We are facing CF server going down frequently from last 2 months without any major changes done in code or settings. Please help us to find the root cause of this issue. Current server settings and errors occurring in the logs are as belowCF server version : 9.0.0.251028Edition: EnterpriseOS : UnixOS version: 5.9Adobe Driver version: 4.0 (Build 0005)Java Version :1.6.0_12Web server : ApacheMin JVM Heap size (MB) : 1524     Max JVM Heap size (MB) : 4096JVM Arguments:-server -Dsun.io.useCanonCaches=false -XX:MaxPermSize=1524m -XX:+UseConcMarkSweepGC -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.libPath={application.home}/../libErrors from cfserver.log:error Error while reading header S_ERROR_TITLEjava.net.SocketException: Broken pipeerror Error in getRealPathFromConnjava.net.SocketException: Broken pipeerror Error while reading header Acrobat-Versionjava.net.SocketException: Connection reseterror ROOT CAUSE: java.lang.OutOfMemoryError: Java heap spaceerror

My editor freezes on me every day, at least once, and sometimes a lot more. Today it's happened 4 times. I never know when it's going to happen, but it seems to happen more often when I'm working on large files with a mix of cfscript, cftags and html syntax. To get back to work, I have to close the eclipse window, sometimes clicking the close box 2 or 3 times, then force quit the eclipse process from the task manager, and then I can restart eclipse.I'm running Windows 7 (x64), eclipse 3.5.1 build M20090917-0800  (x32) and ColdFusion Builder 1.0.0.263215I cannot start without errors that show up in my log, even after I clear it.I attached my log file.

A few weeks ago my CF MX 6 (yes I know - I hope to upgrade to at least 10 in January) app quit being able to send emails.  I looked in the log files for those tasks that did not send emails and found the following message.  "An exception occurred when setting up mail server parameters.  This exception was caused by coldfusion.mail.mailSessionException...".  I restarted the CF server because in the past that seems to remedy issues that have worked for years and quit working for some whatever reason.  I got into the CF Administrator after the restart to look at my mail settings, and got this error message "Unable to retrieve mail settings.  The selected method getServer was not found ...".  Now the Mail Server box is empty and when I try to enter my mail server name and save my update I get the "Unable to retrieve mail settings.  The selected method getServer was not found ..." message again.   Does anyone know how to fix this?

Hello all,I am very new to ColdFusion and am trying to create an instance of an assembly. Here is the two different paths I have tried so far:*Note* Calculator is the name of the assembly/namespace and Calc is the class inside of the assembly.<cfobject type="dotnet" name="calcInstance" class="Calculator.Calc" assembly="C:\ColdFusion2016\cfusion\wwwroot\WEB-INF\cfclasses\dotNetProxy\Calculator.dll">and<cfscript>  calculatorInstance = CreateObject(".NET", "Calculator.Calc", "C:\ColdFusion2016\cfusion\wwwroot\WEB-INF\cfclasses\dotNetProxy\Calculator.dll");  myVar = calculatorInstance.addition(1, 1);</cfscript>Both return "The error occurred in C:/inetpub/wwwroot/Test/index.cfm: line"There's no specific error that is given, just tells me that there was an error. I have JNBDotNetSide.exe running. I'm really not sure what I'm doing wrong. Does anyone have any suggestions on what to do?

HelloI'm running ColdFusion 11 (11,0,06,295053) in a SLESS 12 with Apache 2.4.10I found my logs full of messages like that:application.log:     "Error","scheduler-2","11/26/15","09:46:51",,""     "Error","scheduler-2","11/26/15","09:46:51",,""     "Error","scheduler-2","11/26/15","09:46:51",,""     "Error","scheduler-2","11/26/15","09:46:51",,""     "Error","scheduler-2","11/26/15","09:46:51",,""     "Error","scheduler-2","11/26/15","09:46:51",,""     "Error","scheduler-2","11/26/15","09:46:51",,""     "Error","scheduler-2","11/26/15","09:46:51",,""     "Error","scheduler-2","11/26/15","09:46:51",,""     "Error","scheduler-2","11/26/15","09:46:51",,""     "Error","scheduler-2","11/26/15","09:46:51",,""     "Error","scheduler-2","11/26/15","09:46:51",

Hi,We are using <cfdocument> tag to generate ~50 pages pdf with styled text only (no images).Sometimes the library unexpectedly stop working and the pdf generation hangs forever.We are forced to restart ColdFusion to make it working properly again.Can you suggest us a way to debug the underlying java library (icebrowser,iText) to collect some useful information about the circumstances that causes the problem?Some additional server data:SUSE Linux Enterprise Server 12 on VMwareServer Details   Server Product ColdFusion Version 11,0,09,299201 Edition Enterprise   Operating System UNIX   OS Version 3.12.28-4-default   Update Level /opt/coldfusion11/cfusion/lib/updates/chf11000009.jar   Adobe Driver Version 5.1.3 (Build 000094)   JVM Details   Java Version 1.8.0_25   Java Vendor Oracle Corporation  

Anyone run into a problem with calls to CFINDEX after having applied HotFix 21?  I'm getting the following stack after the hotfix (looks like during the indexing of a Word or Excel file):java.lang.NoSuchMethodError: org.openxmlformats.schemas.wordprocessingml.x2006.main.CTFFData.getCheckBoxList()Ljava/util/List; at org.apache.poi.xwpf.usermodel.XWPFRun.text(XWPFRun.java:1001) at org.apache.poi.xwpf.usermodel.XWPFRun.toString(XWPFRun.java:971) at org.apache.poi.xwpf.usermodel.XWPFParagraph.getText(XWPFParagraph.java:215) at org.apache.poi.xwpf.usermodel.XWPFTable.<init>(XWPFTable.java:117) at org.apache.poi.xwpf.usermodel.XWPFDocument.onDocumentRead(XWPFDocument.java:152) at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:166) at org.apache.poi.xwpf.usermodel.XWPFDocument.<init>(XWPFDocument.java:118) at org.apache.poi.xwpf.extractor.XWPFWordExtractor.<init>(XWPFWordExtractor.java:59) at coldfusion.tagext.search.MSDocument.readDocx(MSDocument.java:164) at c

After creating some charts using the built in cfchart tags, I've been told that the ability to right click is not 508 compliant. Looking at the zingchart website, I have been able to work out most of the JSON, and I can see that to disable it you would use the following"gui":{    "context-menu":{        "visible":"false"    }},My issue is that I don't know how to add this to the cfchart tag to get it to work. Thanks

Hi. I am trying to create a CFIF statement to search for part of our part numbers. For instance, we have part numbers like C1000 or C1300, etc. We also have part numbers like SG-BGA-6000 or PC-PLCC-2000. What I would like the If statement to do, is to tell me if there are any C Numbers, then send an email. How do you create an If Statement for part numbers that begin with C and have numbers after it? Thanks for anyone's help.Andy

I have been testing out Global Script Protection at the CF Admin level (v9.01). But it does appear to have any effect on the form posted data.... or maybe I am not understanding what it can/should do.With it on and if I post a form field with something like this entered:Test<script>alert('hello');</script>  On the resulting page I get a pop-up alert - I would expect Global Script Protection to stop this?Restarted both IIS and CF App and the variable not getting setting at the application level.I am looking for simple way to add some XSS protection to a legacy cf app that has come across my desk.  lots of forms and I do not have access to the source (encrypted).Cheers!

Hello, all,I'm overly concerned about XSS attempts on my sites.  I cannot seem to find a decent solution.I know that as far as using URL parameters on server-side processing, you should use canonicalize() to reduce encoded script to what a potential bad actor intended to run on the server, and sanitize from there.  Apparently, whitelisting is a very effective method.  But, what about when whitelisting isn't an option (like, for example, input into a database, or used as a conditional for database processing)?Also, what about client-side effects?  I've seen where URL parameters can be used to inject JavaScript code into a page.  Now, I know that EncodeForURL() and others should be used, but how can one manipulate the URL so that XSS would be rendered useless??  Without using a redirect like CFLOCATION??V/r,^_^PS:  It's the day before Thanksgiving Day, in the USA, so I won't be on much between now and Monday.  Happy Thanksgiving Day to all American

Hi All,What is the difference between #VARIABLES.ID# and #ID#?Thanks!John

The advertising for ColdFusion Builder 2016 clearly states it has a Tag Editor. It's on this page: Features | Adobe ColdFusion Builder Where is it? I tried every keyboard shortcut. I've looked all over the help files. I can't find it. The feature page reads:Tag editorEasily maintain existing code and minimize code errors by identifying required tag attributes and assigning values with the tag editor.Is this feature in the program or is it a case of false advertising? This claim of having a Tag Editor goes back to CF Builder 3. It did not have one either yet it was advertised as having one.

Hello,I'm trying to use the same method that I would typically used to create a anchor text in ColdFusion that I would do using HTML. I knew to use ## in ColdFusion but the link pointing to the anchor is giving me a 404.<a href="mylink"> Skip </a> -- This links returns a 404 <a name="##mylink"> </a>How do I create an anchor link that will point to a particular section on a new page?I'm trying to create a "Jump to Content" or "Skip Block Content" on my page and figured using an anchor link would be the best solution. Thanks.

Hello, all,I was just shown that an application written by someone else over ten years ago is working fine under CF9 and CF10; but it's breaking in CF11.I have something like:<cfinclude template="../myComponent.cfc" />Now, in myComponent.cfc, I have a function:<cffunction name="getThisAttribute" returntype="string" output="no">  <cfargument name="part1" /><cfargument name="part2" />  ...  <cfreturn thisValue /></cffunction>Under CF11, in the first page (again, this works in CF9 and CF10), if I do the following:<cfset thisVar = getThisAttribute(part1,'part2') />I get "getThisAttribute undefined".  Am I going to have to completely re-write how all this works if we switch to CF11???V/r,^_^

Why, when I initially launch Administrator, am I seeing this "double NavBar"?  When I select an item, it goes away. It returns when I logout and then log back in.  I uninstalled and reinstalled, but still have this issue.  Any assistance would be most appreciated.

I'm writing an application which needs to store a time interval as a value in an Oracle database. There is a datatype INTERVAL HOUR TO SECOND that accepts properly formatted varchar2 string values as such:insert into ar_tint (duration)values (interval '29:03:20' hour to second)The above SQL executes properly inside a <cfquery> block. Note that the argument must be in single quotes (per Oracle's own documentation on this subject), double quotes will throw an ORA-00917 'missing comma' error.As this argument is a string, I expected the following to work after a <cfset igg='29:03:20'>:values (interval <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value='#igg#'> hour to second)What actually happens is that Oracle returns the following:Error Executing Database Query.ORA-00917: missing commaThe error occurred in D:/webroot/path/to/interval.cfm: line 2119 :20 : INSERT into ar_tint (duration)21 : values (interval <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value='#igg#'> hour to

I am using CF Server 11 and CF Builder 3.Everything was fine, but suddenly I got a message "The 127.0.0.1 page isn’t working".  I get a similar message if I try to access the CF Administrator.I am using Apache Tomcat, 11.0. listening on port 8500 and Opera 41.0, Windows 10, 64 bit.I have checked firewalls but found no blocking. According to the message at the bottom of the CF Builder Page, CF Server is running.Anyone any ideas as to what could have happened? Thanks in advance for comments.

I created subdomains on my server for development part of my website and the cfajaxproxy is working great on the live version and on my subdomain dev.mydomain.com. I created a new subdomain name dev2.mydomain.com and now the cfajaxproxy isn't working on that one. I've check my admin panel and all but I'm enable to find anything that can change the configuration specificaly for cfajaxproxy.Anyone have a clue about that ?Thanks all lot !

Hello, I get the attached error when loading CF Builder 2016. I have tried unistalling/reinstalling but it does not show up in add/remove. I also updated Java to the latest release thinking it might have been that since it is the first item listed in the error. Machine is a newer I7 with Windows 10(anniversary update). Wanted to check out CF Builder(longtime DW user). Any ideas on what I can do?

I'm getting the following error indexing my collection. "SOLR Advance Feature is not available in this edition of ColdFusion server." I was able to successfully setup the data handler mappings and reload the collection. I have Coldfusion Server 11 Standard. According to Adobe's website Solr data handler is a standard feature. Features | Adobe ColdFusion Standard.Has anyone got the import data handler to work in the standard edition?

Hi -I installed CF10 Enterprise on a Windows 2008 R2 Enterprise 64-bit system.I updated with the mandatory cf10_mdt_updt.jar updateI applied Update 21 hotfix_021.jarAfter installation, I used the Web Configuration Tool to remove 'All IIS Sites', and allowed the server to be restarted to complete the removal.Then I re-added 'All IIS Sites'. This was to ensure that the wsconfig/1/isapi_redirect.dll was updated to the 8/19/2016 version.After this, almost everything works correctly, except for PDFs. The server returns the correct number of pages, but all are blank, when I try to display this way (angle brackets removed): cfcontent type="application/pdf" reset="yes"                cfoutput#toString(request.printable.viewOutput)#/cfoutputI have other code which can display PDFs, so it is not iText doing this. It might be CF cutting off binary content, which was a problem earlier in the CF10 saga, but I thought this wa