Questions

HiI have a client that needs to collect data from a standard HTML form, stuff the data in a database and then query and format the data for printing.The printed result has some fairly stringent requirements which I can likely do with CSS (such as field widths, line breaks, etc.).My question is, has anyone identified a good way to do this? How does the CF world handle printing dynamic data into a pre-formatted form? Thanks in advance,Rich

Hi... can't seem to get the site wide error handler to work on my new CF11 server....I built a simple error handler cfm page and put it into my CF server root (not the site root) and created a test.cfm with an intentional CF error (a cfinclude tag that points to a missing file) that I put into my site root.In CF admin I pointed the Site wide error handler to my error handler page and clicked submit, and CF admin came back with a confirmation message saying all is well.Any Coldfusion errors are still being handled by the default template and not my custom error page. Does anyone know anything else I could try?Thanks in advance,Rich

Hello,  I am looking into a concurrent requests issue that has just recently come to my attention with ColdFusion 9. It appears that ColdFusion can only process 12 requests at the same time using windows launched from one browser (IE 11) from one client computer. I launch 30 instances of a page that writes a file then sleeps for 30 seconds. I notice that 12 files are written at once, then more come in waves after the sleeps are complete. This is with ColdFusion 9 set to run a max of 50 requests, no limits on requests for IIS, and no limits on requests for the browser. After some searching, I read that request queuing can be caused by memory management or the aforementioned setting. With this, I have a few questions:  Is this a known limitation on ColdFusion? If so:Is memory or processor power the limiter?Are there any other ColdFusion or IIS settings that be tweaked to increase the number of requests?Is there a “per client” limiter in place?Would using ColdFusion 11 remedy th

I am getting the error below when trying to create an object in CF 11 using cfscript. In the CF Admin Java VM settings are the default setting. I have placed xmlsec-1.5.8.jar file under \cfusion\lib and cfusion\wwwroot\WEB-INF\lib I have also restarted the CF service.java.lang.NoClassDefFoundError: Could not initialize class org.apache.xml.security.signature.XMLSignaturesun.misc.Unsafe.ensureClassInitialized(Native Method) at sun.reflect.UnsafeFieldAccessorFactory.newFieldAccessor(UnsafeFieldAccessorFactory.java:43) at sun.reflect.ReflectionFactory.newFieldAccessor(ReflectionFactory.java:142) at java.lang.reflect.Field.acquireFieldAccessor(Field.java:1082) at java.lang.reflect.Field.getFieldAccessor(Field.java:1063) at java.lang.reflect.Field.get(Field.java:387) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav

I am using the CF10 Report Builder.I need to convert a 6 character string and compare it to a 20 character string.Input = 201516 needs to be converted to 201508 and 201601. I am trying to handle the conversion in my query and not pass any records that I do not want to count to my report. IF the is a better way I am open to suggestions. Here is the code in my query that gives me a "Conversion failed when converting the varchar value 'E' to data type int'WHERE name.soc_sec = transact.soc_sec          AND name.soc_sec = prospect.soc_sec         AND name.soc_sec = approg.soc_sec         AND name.soc_sec = nmcrs.soc_sec         AND name.soc_sec = transact.soc_sec         AND transact.accept <> 'v'          AND transact.tcodes = 'AW'   &nbs

Hello,I am trying to re-index my cold fusion collection from verity to solr. But I am getting following error while re-indexing. It will let me continue if I wait for some minutes or after restart the solr service.Please see the error below :==============================================Error_opening_new_searcher_exceeded_limit_of_maxWarmingSearchers4_try_again_later Error_opening_new_searcher_exceeded_limit_of_maxWarmingSearchers4_try_again_later request: http://localhost:8983/solr/adsausagesite/update?commit=true&waitFlush=false&waitSearcher=false&wt=javabin&version=1==============================================Do anybody have a solution against this error ? My coldfuison version if 9.Thank you.

We are using CF9 64-bit and setting up a SOLR collection for an HR application. The database contains several million records and includes resumes that we want to do full text searches on.We started out by using cfindex to create the index but it would bomb out after just a few thousand records with an error about "warming threads" (I don't have the exact error handy but can get it later) and the indexing would have to be manually restarted. This wasn't a good solution for a multi-million record operation..Next, we created a custom Data Import Handler (DIH) outside of CF using the instructions in the SOLR wiki. This index worked great and was very fast. However, the ColdFusion tags (cfsearch, etc.) would not work with this index. We even made sure to duplicate the required nodes (<custom1> <custom2>, etc.) that the cfindex tag would have created. Still cannot search that index.We'd really rather not reinvent the wheel and have to write custom search code. Obviously, we like

I have a headless install of Ubuntu 14.04.1 LTS and want to install ColdFusion 11 thereon.The download I was able to retrieve was ColdFusion_exp_11_WWEJ_linux64.zipI downloaded that on a Windows machine, then ftp'd it to the linux box.HOWEVER, ALL the install documentation I find always refer to a file: ColdFusion_exp_11_WWEJ_linux64.bin which I don't have. Where is this file?I am not particularly conversant with Ubuntu or linux, and the unzipped files are not doing it for me, and I have no idea how to proceed. Where is the .bin installer? Where is the install information from a zip? It shouldn't be this hard to continue, It looks like the assumption is that the downloader is already an expert in CF or Java or both - I am not.Thanks.nalex in NH

How to update coldfusion 9.0.1 to 9.0.2 in a linux server. I have been using centos.Please provide any reference links or steps to do this

When I run my query and the award is not found a null value is returned, I'd like to show that as a 0 value on my excel report.Is there a way to do this?

I am using CF10 Report Builder. I have a main report that show counts/amounts by award type for admitted and deposited students. I have a sub report that shows counts/amounts by award type and level for current students who have registered and those who have not yet registered. I need to show the totals of current students by level and weather they have registered or not.I tried adding a sub report to show the totals but the sub report does not show up on the main report. Is there a way to do this that I am missing?

I have established an SFTP connection with a client site but I cannot see the files in the directory because they do not have valid extensions. If I upload a file to the directory and add .txt to the end cfftp sees the file just fine but ignores all other files in the directory.Is there a way to view all contents of a directory regardless of MIME type?

We have a very simple query that executes instantly in SSMS, returning about 45,000 rows.  Whenever I run the same query on a CFM page it takes about 47 seconds to execute.I've tried reindexing, turning it into a stored procedure, etc.. but nothing seems to help.   My other queries are also running a little slower, but not nearly as noticeable because they are smaller queries.I have an additional CF10 server that seems to run the query perfectly fine on a test page.The query is pretty much this:Select X,Y,ZFROM TABLEWHERE BLAH BLAH BLAHCan someone offer me some advice on what can cause this or how to find the issue?Thanks!

I have been a coldfusion developer for several years now.  I always get people asking me to built a front-end website for them.  Basically, all they want is a brochure type site where they can manage the content, images, etc.  So, I point them to squarespace and they are good to go until they want some database related items.  The requests are relatively simple.  Basically a form that the user submits and a back end admin page to view submissions.  Most cms's including squarespace have tags and ways to do simple functionality.  But, I would like a solution that would allow the users to utilize a cms type site to manage their site, but allow for advanced functionality.  I prefer to utilize coldfusion rather than having to switch to php.  I use hostek as my host and they list joomla, mura, gocontentbox.org, and wordpress as applications that I can install on my customer sites.A major concern of mine is the fact that a customer may design a pag

I think the WSCONFIG folder for other site is 2 and I created VD jakarta to point to 2. for the site I am seeing issue - it is pointing to 1 and seeing some restriction file.I tried to create multiple times new site so it creates and point to new folder in wsconfig, but everytime it is pointing to 1.is there anyway I can manually update ?This site has .NET componenets, if I enable 32 bit - my CFM pages give above error, IF I don;t enable .NET is giving an error.but, this issue is not there on the other site  on same VM.

We need to upgrade our existing servers to CF11, and we're considering saving money by installing the Standard version on our development servers, and the Enterprise version on production. We need PDF generation and more threads in production, but we don't need these things in dev, and the price difference is significant.We're wondering if we will run into unforeseen problems by having different versions on dev and prod. Has anyone tried this? Does it work? Any reason to think we'd be causing ourselves future headaches?Thanks in advance-David

I have a large (9700pg) PDF that has 15 top-level bookmarks as well as hundreds of sub-bookmarks within those 15. My goal is to have each individual bookmark as a separate PDF. I tried split document under Tools>Pages, but that only allows me to split into the 15 top-level bookmarks. When I open each of those 15 new files all of the children bookmarks are gone. Any ideas?

Hello Everyone, I have this code that works great, but there is one little problem.When user inputs index.cfm it does not forward to plain dynamic.cfmSo it seems to me that i need to modify this code so it can handle at least one more option The script works very well when user inputs index.cfm?myID=#url.myID then redirects to dynamic.cfm?myID=#url.myIDHow could I make it work? Any help greatly appreciated <!-- File name: index.cfm --><cfoutput><cfif isDefined("url.myID") AND IsNumeric(url.myID) AND url.myID NEQ 0>     <cfheader statuscode="301" statustext="Moved Permanently">     <cfheader name="Location" value="dynamic.cfm?myID=#url.myID#"></cfif></cfoutput><cfabort>

  I am using CF10 and have been working on an application that connects to a secure server using cfhttp.  It was working fine but then the host moved their application to a Windows server 2012 box using IIS8 with SNI enabled and now I cannot connect.   After reviewing the Internet I found that CF has a bug; # 3598342 registered in its Adobe bug database and that it has “apparently” been fixed with upgrade 14 for CF10.  I actually applied upgrade 15 so am now running build 10,0,15,292620 and java version 1.7.0_15.  However, after completing this upgrade and ensuring that the server’s SSL certificate is installed in the CF certificate store, I still cannot connect to the SNI enabled server using cfhttp.  I'm not sure where to go from here.  Am I missing something?  Any guidance would be appreciated.    

I installed update 5 last week for ColdFusion 11. Now the Browse buttons don't work in any of the ColdFusion Admin screens and the Settings Summary page has an error with non-root administrator. Is anyone else having the same issues? Thanks

I have made the changes I found in the Coldfusion 11 - Web Sockets via SSL discussion and I am getting "The connection was interrupted" in firefox when I try and go to the coldfusion administrator.  I have successfully gotten https working in a Apache Tomcat server without Coldfusion.  Is there something I am missing.  Here is my connector page from the server.xml file:<Connector port="8443" protocol="org.apache.coyote.http11.Http11NioProtocol" SSLEnabled="true"           maxThreads="150" scheme="https" secure="true"           clientAuth="false" sslProtocol="TLS"    keystoreFile="C:\keystore.jks"    keystorePass="MyPassword"   keystoreType="JKS"/>

Hi,I am facing an issue with my CF11 scheduler and I was hoping someone can help.My application has 2 servers which are load balanced. I have created a schedule through CF Admin console which is on one server. The scheduler just needs to run a URL which I have defined in the scheduler. When I run this URL manually (by copying it in the address bar and running it) it works fine. However, when I trigger it through the CF scheduler, it gives a message saying "This scheduled task was completed successfully."But when I go to my log (scheduler.log), I see "404 Not Found". I do not understand what is stopping this from running through the scheduler. We recently migrated from CF8 to CF11 and these scheduler used to run fine on CF8.

Hello,I'm new in ColdFusion development and I'm trying return some value from de function on component.But independent of the return type, the value is aways "undefined".This is my function:<cffunction name="getAll" returntype="query" access="remote" returnformat="JSON"   hint="Fetches employee rows from Employee table and returns array of EmployeeTO components">  <cfquery datasource="cg_sindicontaba" name="empRs" result="test">  select * from tab_001_tes_car   </cfquery>  <cfreturn empRs>  </cffunction>And here I call:<cfset empMgr = new cfc_tes_car_mob() /><cfset qEmp = empMgr.getAll() />Thanks.

First, let me say that I would have loved if this post was about how I was working with cfexchange and Exchange Server 2010, but its not, because cfexchange does not work with Exchange 2010 and never has.  See Bug report 82576 and vote!Now, since I was not able to use cfexchange, I wrote an email parsing script using CFIMAP that was working until recently.  About the same time, I upgraded Exchange to SP1, I also upgraded CF9 to CF9.01.  Now, I am unable to use the GETHEADERSONLY or GETALL actions of CFIMAP.  I consistently get the following error:The cause of this exception was: javax.mail.MessagingException: Unable to load BODYSTRUCTURE.Does anyone else have a similar environment to test to see if CF9 or 9.01 works with CFIMAP on Exchange 2010 SP1?  Your input would be much appreciated.--Sean

We are running ColdFusion10 Ent. on Windows Server 2008 R2 Standard and IIS ver. 7.5. Java Version: 1.7.0_45We have also implemented the CF lockdown guide.Things have been running quite smoothly for some time now. However, after applying CF update 14 on our QA server we noticed an huge performance hit for all CFHTTP calls when security sandbox is enabled. If we disable the ssb then performance returns to normal. Disabling the sandbox is not an option for us.Here is the difference for a simple cfhttp request.Sandbox enabled: 9109 ms.Sandbox disabled: 79 ms.Rolling back to update 12 fixes the issue.We've since applied update 15 and now 16 with no change in this performance. After applying all update we always re-run the connectors as stated by Adobe.Our local dev machines (mac and PC) do not seem to experience this behaviour so I'm a bit concerned it might have something to do with IIS/connectors etc. on the server.Any suggestions/advice would be much appreciated as we cannot apply updat