Questions

Hello, all,I've been handed a project - a very simple one - that involves uploading an XML document, parsing the data, and then populating a database with the results.However, what isn't simple is the XML document.  It's slightly over 3mb in size.I'm setting a variable with the XML document contents (XmlParse()), and am using (successfully, for the most part) XmlSearch() to get the data.However, I have run into a bit of a snag; and I'm not having much luck on Google.The data is for locations around the US - each location has one ID, one Name, one City, one State, one Zip code.  But each location has multiple phone numbers and email addresses.  I'm trying to parse the data in such a way as I can loop through child nodes of the main information and grab only one email address and one phone number.But no matter what I do, I cannot seem to extract a "length" or structcount of the child nodes that contain the email and phone contact information.  I have tried StructCount

Hello all,I am having a terrible time parsing an XML doc that is being returned from a service. I think it might be because I upgraded to CF11 and perhaps something is out of date.Normally I try to get this figured out myself but I just have spent too much time on something I'm sure is very easy.Here is what is being returned:<?xml version="1.0" encoding="utf-8"?><WebServiceGeocodeResult version="4.10"><QueryMetadata><TransactionId>512a8c85-8258-498c-88a2-c75289e3cb25</TransactionId><Version>4.1</Version><QueryStatusCodeValue>200</QueryStatusCodeValue><FeatureMatchingResultType>Success</FeatureMatchingResultType><FeatureMatchingResultCount>1</FeatureMatchingResultCount><TimeTaken>0.0390039</TimeTaken><ExceptionOccured>False</ExceptionOccured><Exception /><ErrorMessage /></QueryMetadata><InputAddress><StreetAddress>1 S MAIN ST Akron OH 44308</StreetAddre

Hi,System info: CF10 Update 14, Windows 2012 R2 and JDK 1.8.0_73 I tried to configure connector (AJP1.3) to use more than 256 threads using param "maxThreads", in file server.xml. Also I configure workers.properties to match values properlly. But when I tried it, never exceeds from 256 (using JConsole.to monitorize connector)server.xml<Connector port="8012" protocol="AJP/1.3" redirectPort="8445" tomcatAuthentication="false" maxThreads="500" maxConnections="500" connectionTimeout="60000" />workers.propertiesworker.cfusion.max_reuse_connections=500worker.cfusion.connection_pool_size=500worker.cfusion.connection_pool_timeout=60I can view that the default protocol used by Tomcat is BIO that it's limited to 256 connections. Is it true?Can I use NIO protocol to use more than 256 threads?Thanks in advance.

CF administrator has a handy tool in Mail to verify whether CF is connecting to the mail server (used for CFMail). I'd like to be able to this verification outside the CF Adm. template. For example, create a scheduled task to check this every so often. But, all the administrator files seem to be encrypted or something. Is there a way to view the actual cfml code on various pages?

Guys,We are integrating with a third party app which is making an HTTPRequest call to our IIS server.  Unfortunately, the process is failing on their end (which is using Ruby), because the status_code of 200 is returning as a datatype of string rather then integer.  Is there a way to configure the CFHTTP header or other processes in order to force the status_code to a datatype of integer rather then string. Thanks - N

- ADOBE STAFF PLEASE ANSWER ASAP  - When will ColdFusion 2016 Support Windows 2016 Server?The problem seams limited to just the installer because sadly the product installs and works just fine on Windows 10.I have a $60,000.00 major production system upgrade ON-HOLD over this because our IT policies REFUSE us to install an older operating system for new deployments where the need for the windows server will outlast the life of the OS. We have had to put the vendor ON-HOLD and management is wanting answers.

I'm trying to reduce the width of the border around my cfgrid. I want a 1 px border, but the grid is showing up with a 2 or 3 px border. I tried using the style attribute, but it has no effect on the grid. In fact, I don't even see my style attribute being output anywhere in the document.When I inspect the grid, I see a div (<div id="cfgrid1283278813192"... >) that has an inline style:"width: 625px; border: 1px solid rgb(204, 204, 204); overflow: hidden; height: 500px;"When I change this inline style, and set the border to 0, the grid renders the way I want. But I don't see a way to gain control over this inline style. It seems like my style attribute should be applied in this div.Is this broken or am I missing something?

We recently updated the JVM Arguments (highlighted in Red below) in ColdFusion 10.-server -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch -Dcoldfusion.home={application.home} -Dcoldfusion.rootDir={application.home} -Dcoldfusion.libPath={application.home}/lib -Dorg.apache.coyote.USE_CUSTOM_STATUS_MSG_IN_HEADER=true -Dcoldfusion.jsafe.defaultalgo=FIPS186Random -Dhttps.protocols=TLSv1.2,TLSv1.1Ever since this JVM configuration change was made our scheduled tasks in ColdFusion have stopped working.  I am still getting the Connection Failure: Status code unavailable error after updating the Key store.Microsoft Windows [Version 6.0.6002]Copyright (c) 2006 Microsoft Corporation.  All rights reserved.C:\Users\su-jc01>cd c:\ColdFusion10\jre\lib\securityc:\ColdFusion10\jre\lib\security>dir c:\ColdFusion10\jre\bin\keytool.exe Volume in drive C has no label. Volume Serial Number is 3CCC-0D9D Directory of c:\ColdFusion10\jre\bin11/11/2014  04:42 PM     

Configuration: Coldfusion 2016 Standard 64-bit on Windows Server 2012 R2 Standard - 64bit, Java 1.8.We need to create datasources to several Access databases. (Comments regarding Access not helpful; we do not control this). We do see that Access is not listed on the Systems Support Matrix, however the April 2016 post referenced below seems to indicate that connections can still be made.We have successfully created such connections in ColdFusion 11 Standard (Server 2012 R2 Standard), but so far cannot create them in Coldfusion 2016 Standard.   The error is 'The specified data source is not defined'.Have followed to the letter the solution mentioned in this post, to no avail.  Have compared the registry values for both Software/ODBC/ODBC.INI/[datasource] and Wow6432Node/ODBC/ODBC.INI/[datasource] in CF 2016 to those in CF11, no differences.Have successfully installed Ucanaccess  (jdbc driver for Access) and can connect to databases.  However, driver does not prop

Hello, all,I was just wondering if there is a way to set folder attributes using CFDIRECTORY in CF10 Server, or CF11.I'm specifically looking for a way to use CFDIRECTORY to create a folder (if it doesn't already exist) and set it so that file execution is disabled.  Set it so that all files within are strictly read/write/delete, nothing else.I notice that *nix servers can take advantage of the 'mode' attribute for CFDIRECTORY.  Very nice, sadly we are in a Windows environment, so that will do no good.V/r,^_^

Hello,I am using Coldfusion 9 with the built-in web server. I edited jrun.xml to uncomment the SSL section and directed it to my keystore in which I imported my certificate.Yet, when I start the server, I receive the following error :No available certificate or key corresponds to the SSL cipher suites which are enabled.javax.net.ssl.SSLException: No available certificate or key corresponds to the SSL cipher suites which are enabled.Where can this come from?Thanks in advance for your help!

Windows 2012, CF11,  IISFirst, I have the following in my application.cfc:    this.ormenabled=true;    this.ormsettings.dbcreate = "update";    this.ormsettings.flushAtRequestEnd = false;    this.ormsettings.cfclocation=expandpath('/model'); // I've also tried "C:\full\path\model"My models are in my /model folder.My error:Error while executing the Hibernate query.org.hibernate.hql.internal.ast.QuerySyntaxException: List is not mapped [  from List  where listtypeid = 2  and user.userid = ? ] The specific sequence of files included or processed is: C:\inetpub\vhosts\xxxx\xxxx\sms\index.cfm, line: 7 "SMS/index.cfm:<Cfquery name="lists" dbtype="hql">from Listwhere listtypeid = 2and user.userid = <cfqueryparam cfsqltype="cf_sql_integer" value="#session.userid#"></Cfquery>I have a few calls prior to the cfquery dbtype=hql using entityloadbypk() such as<cfset user=entityloadbypk("User",session

I have a file uploaded to my site http://www.mysite.org/coned/media/106.mp4I looked in the folder, the file is definitely there.It's a new project, and there are only a couple of other files in the folder, one is an mp3 one is a wmv.  Both of those open.This mp4 file is giving me a 404 error.Any thoughts on why?Thanks

Hi AllI followed this thread:Coldfusion 10 Case Sensitive URLs?!? By editing the context.xml file as suggested.  This resulted in the following error:HTTP Status 500 - java.lang.NullPointerExceptiontype Exception reportmessage java.lang.NullPointerExceptiondescription The server encountered an internal error that prevented it from fulfilling this request.exception javax.servlet.ServletException: java.lang.NullPointerException coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.java:129) coldfusion.bootstrap.BootstrapServlet.init(BootstrapServlet.java:59) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:450) org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) org.apache.coyote.AbstractProto

Using ColdFusion 9 and SQL Server 2008. Have cfgrid with dates. The date columns are not displayed but text boxes are bound to those columns and are displayed. The SQL Server data types are datetime which store in this format - mm/dd/yyyy hh:mm:ss. The cfgrid displays the date as 2011-01-20 14:52:32.167. In the cfgrid code I have tried "mask" and "number format" and neither alter the date display. Any suggestions?Could I possibly change the format in the text boxes. I use the data in the text boxes for emails and a more conventional date presentation would better suit the email.Thank you - JSsample code for cfgrid<cfgrid name="reqInfo" query="Req" width="510" visible="yes" format="html" rowheaders="yes" rowheaderwidth="50" selectcolor="orange" selectmode="row" maxrows="25" colheaderbold="yes" colheadertextcolor="Blue" selectOnLoad="no">  <cfgridcolumn name="ID" width="8" display="no" />  <cfgridcolumn name="PIN" display="no" />  <cfgridcolumn name="N

I'm getting the following error when trying to use cfcompile: "Webroot specified does not exist"This is the command I've used:  cfcompile –deploy D:\website D:\website\cfcompilein D:\website\cfcompileoutMy default website which I would think would be my webroot is defined in IIS as D:\website. I've defined the same path as "\" in CF mappings.ColdFusion is installed in C:\coldFusion2016I'm getting the same result on our CF9 installation.Any idea what I'm doing wrong? ThanksBob

Hi,I did a standard Installation on Windows 2008 R2. After creating a solr Collection everything is fine, but the configuration isn't saved in solr.xmlAny idea?And where I can get a actual description for cfindex and cfsearch?BestThomas

I am using the developer version of CF 11 for my test environment.  I tried adding a site in IIS yesterday morning and it wouldn't process CF pages.  So I used the web server connector and added the site.  However, it didn't work.  Every CF page just comes up blank.So I removed everything in the web server connector and re-added for ALL sites.   It looks like everything installed okay. I've checked that the config files are there (in C:\ColdFusion11\config\wsconfig\1\), and I checked that the handlers are correctly configured and they are.  The CFIDE and Jakarta virtual directories are there and pointed to the right place and the Jakarta has execute permissions.  The ISAPI filter is in place as well.  However, now everything including the CF admin comes up blank.Any ideas on where I might look to troubleshoot?

Hi,I'm evaluating ColdFusion Builder 2016 (3.1.0) as a plugin for Eclipse (4.3.2) and with ColdFusion 10. I think it has a lot of nice features that would improve my current development environment but the performance when using it for a large CF project is poor unfortunately and some functionality is not even possible to use. I'm now trying to find out if this is normal and if I can do anything about it. Performance for a small test project is ok, it is when I use it on a big CF project I run into issues. The project has a couple of hundreds cfm files and a couple of thousands cfc files. It also has several thousands other file types (.js, .sql, .html, etc.).Refactoring/renaming: Runs forever (>15 minutes) and sometimes terminates with an out of memory exception. I start Eclipse with 2048m as initial and maximum Java heap size. Using a local web server. Obviously it will be slower with a larger number of files but is this normal? Will it only process cfm and cfc files?Line debuggin

i am facing issues when upgrading coldfusion 6 to coldfusion 10 (Enterprise) using oracle 12c database. in CF10 Administrator data & sources tab selecting others drop down here providing  jdbc:macromedia.oracle:<servername>:port:SID;Driver class name  : macromedia:jdbc:MacromediaDriverhaving jar files are OJDBC7 & OJDBC 14 in my Web sphere CFFUSION/LIB folder .When calling one of the Stored Procedure in my application procedure using 3 reference cursors Getting error message like : Error executing database query : Jdbc  [macromedia ][oracle jbbc drivers][oracle][ora-20001].error encountered -2074-ORA-06512 : cannot set nls in Distributed transcations..There is other senarion which i can able to get the data from other stored procedure if the procedure using 1 or 2 reference cursors..using cfprocresult tag for results in stored proc..Please let me know how do I achieve result by using 3  reference cursors ..Thanks in advance..

I am trying to use Bootstrap with a CF site that makes heavy use of CFChart. Bootstrap has worked fine in the past with pages that don't use CFChart.Bootstrap requires 3 meta tags to appear first in the HTML header:<!DOCTYPE html><html lang="en">  <head>    <meta charset="utf-8">    <meta http-equiv="X-UA-Compatible" content="IE=edge">    <meta name="viewport" content="width=device-width, initial-scale=1">    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->    <title>Bootstrap 101 Template</title>With a CFChart tag in the page, tags are injected into the header above the Bootstrap tags, thus breaking some of the Bootstrap functionality:<!DOCTYPE html><html lang="en">  <head><script type="text/javascript">/* <![CDATA[ */_cf_loadingtexthtml="<img alt=' ' src

This is less a request for help and more a beware for the unexpected...I’m using CF11 and encountered a strange issue when trying to use UTC timestamps for comparison. It appears there is a hidden time zone indicator associated with CFs datetime object -- and I’m guessing it with the underlying Java datetime object. If all datetime comparisons happens during the request and no string conversion or database storage of the datetime objects happen, no issues. But if you convert a UTC converted datetime object to a string or store it in a database for a future comparison, you will receive some unexpected result as the comparison seems to take into account the hidden time zone and this field is not preserved when converted to a string or retrieved from a database. Example:<cfscript>            local.dttm1 = createDateTime(2017,02,01,01,00,00);            local.dttm1UTC = dateC

CF Version: 2016,0,03,300466 (Standard)DB Driver: com.microsoft.sqlserver.jdbc.SQLServerDriverI don't know if this is a bug or a feature, but when a query fails within a cftry/cfcatch block that is surrounded by a cftransaction tag, and that query is executed again in the cfcatch block (i.e. for timeout or deadlock purposes), all queries that ran before the cftry/cfcatch block are rolled back. For instance:<cftransaction><cfquery name="query_1" datasource="#my_ds#">     INSERT INTO Table1(Field1, Field2)     VALUES(          <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#val1#"/>,          <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#val2#"/>     )</cfquery><cfquery name="query_2" datasource="#my_ds#">     UPDATE Table2     SET Field1 = <cfqueryparam cfsq

Hello, all,I am just fiddling around, a bit, trying to learn something new:  setting up and using an MS Access db in CF10.  Simple, right?No.. not really.  But I didn't start this thread to give you the details and minutiae regarding getting it to work.  It works.The issue I'm having is that I wrote a simple query to fetch data from the FIRST table I created (Games) and am retrieving six columns of data.I'm running a query, using CFDUMP to display it.I went into the Access database and added three rows of info.  When I refresh the page, the CFDUMP shows only the first three rows.I deleted those three rows from the Access db, refreshed the page, and still see those three rows of data - nothing else.  Not the new rows I entered.  Nothing changes.Not sure what to do next.  Please help?V/r,^_^

Hi,I am in the process of translating a CF application to PHP.I have a question about queries, please tell me if I'm right:If I understand well, the major difference  between CF queries and PHP queries is that in CF, the whole set of records is fetched and an array is generated containing all data in one shot. On the other hand in PHP, only one row is returned and one has to fetch rows one by one so it takes very less memory at a time.Is this right ?My application uses only rather small queries and the use of memory has never been a problem in the CF version, so I intend to emulate the way CF works in PHP to simplify the work of translation.Any comment ?