Questions

Hello, all,I'm attempting to use (within CFSCRIPT) queryNew() and querySetCell() to create a database object, then use qry.execute() to SELECT data from it.I have tried many variations, each giving a different error message.  I cannot figure out what I'm missing, and I'm pretty sure it is something really simple.<CFSCRIPT>    cities = queryNew('cityID,cityName','varchar,varchar');    queryAddRow(cities,10);    querySetCell(cities,'cityID','1',1);    querySetCell(cities,'cityName','New York',1);        ...    querySetCell(cities,'cityID','10',10);  querySetCell(cities,'cityName','St. Louis',10);    myQry = new Query();    myQry.setSQL("SELECT cityID, cityName FROM cities");    myQry.setDatasource('cities');    qryRes = myQry.execute();    return qryRes;</CFSCRIPT>The above is within

We were running the 2016 trial, which expired.  Our application is currently a bit crippled. Now trying buy the 2016 version or extend our trial (a week or so) until we have time to plan a migration to 2018.  We have already purchased 2018.  Any help would be fantastic.  I have spend over 3 hours trying to reach someone to talk to.  Submitted a support request via chat and they said I may not receive a call back until tomorrow. Scott T.

Today, we’re very excited to announce the 2018 release of Adobe ColdFusion. This release builds on Adobe’s industry-leading solution for creating and deploying scalable, high-performing web applications in CFML. Now in ColdFusion, we’ve added an all-new Performance Monitoring Toolset, a standalone server with low overhead to control and optimize applications and a new auto lockdown installer to help increase security in the Production Server. In addition, web developers can now boost the performance of their applications by taking advantage of Asynchronous programming and various other language enhancements. And, upgrading to the 2018 release immediately allows applications to run 30 percent faster.“The enormous digital transformation that we are witnessing around us has made it an absolute necessity for organizations to quickly adapt to changing market developments,” said Tridib Roy Chowdhury, senior director of products, Print and Publishing, Adobe. “A secure platform, that is not on

Hi,I have the following cfdiv that works just fine.Is there away to capture the value in DaysAvailable when it comes back and place it in another variable?<cfdiv name="DaysAvailable" bindonload="no" bind="cfc:#this.LOC#.common.hcbsservicemath.getDaysAvailable({StartDate@change},{EndDate@change})">Thanks,Mike

We're trying out CF-2018 with an application that uses FrameWork/1 and one of the first thing we have hit is:coldfusion.compiler.ASTliteral cannot be cast to coldfusion.compiler.ASTtagAttributeThe error occurred in ...\framework\one.cfc: line 1842 Called from ...\framework\one.cfc: line 1869 Called from ...\framework\one.cfc: line 260 Called from ...\framework\one.cfc: line 2967 Called from ...\framework\one.cfc: line 9911839: private string function normalizeQueryString( any queryString ) {1840: // if queryString is a struct, massage it into a string1841: if ( isStruct( queryString ) && structCount( queryString ) ) {1842: var q = '';1843: for( var key in queryString ) {1844: if ( isSimpleValue( queryString[key] ) ) {I've googled and found no references to "coldfusion ASTliteral ". Help.

Hello,I am hoping that someone else has done this.I am working on a modification to a ColdFusion site I have inherited and I have to admit that I am more or less a newbie to ColdFusion, although I have worked web applications and Databases for many years.I am working on a reporting application that output information on requests. The requests can either be completed or delegated. If they are completed the database column comp_time will be populated. If the request is delegated the comp_time column will be null and a column named delegate_date will be populated.I have come up with the query that will look at both of these fields and and make them into one field. (That part was easy and is highlighted in red)select sr.request_id,sr.supp_id,sr.entry_date,sr.po_num,(NVL(sr.comp_time, sr.delegate_date)) comp_time,sr.first_article,rd.detail_id,rd.po_line,rd.qty_ready,st.surv_name,rd.qty_expected,rd.qty_accepted,s.supp_name,s.city,sr.delegate_date from source_request sr,request_detail rd,surv

Its a new setup on my laptop, all configuration is exact similar to prior. I see an issue now with cfinput type datefield 11/30/2018 is an invalid date or time string. i have tried changing system date and time to mm/dd/yyyy format. Reinstalling Coldfusion multiple times. Someone please suggest whats wrong here ? As the same set of code works on other systems.<cfinput type="DateField" class="gcText9pt" name="end_dt" value="#DateFormat(end_dt, "mm/dd/yyyy")#" required="Yes" validate="USdate" size="10" maxlength="16" message="Enter a valid Fiscal End Date (e.g. mm/dd/yyyy )" mask="mm/dd/yyyy">

Hi,I’m migrating from cf11 project to CF18 with the help of this resource (https://forums.adobe.com/message/10661306#10661306). I have kept a copy of cf11 neo*.xml files and uninstalled cf11. Proceeding further and installing cf118 and done kept the neo*.xml files in the cfuion/lib folder, I have done the configurations of IIS and CFAdmin properly. But after all the setup I’m facing Java.null.pointer exception. I have checked the java and jvm section of cfadmin where the JVM Argumentslooks like this (-Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=5005 -server –add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED –add-opens=java.base/java.nio=ALL-UNNAMED –add-modules=java.xml.ws –add-opens=java.base/java.lang=ALL-UNNAMED –add-opens=java.base/sun.util.cldr=ALL-UNNAMED –add-opens=java.base/sun.util.locale.provider=ALL-UNNAMED -XX:MaxMetaspaceSize=192m -XX:+UseParallelGC -Xbatch -Djdk.attach.allowAttachSelf=true -Dcoldfusion.home={application.home} -Duser.language=en -Dcoldfu

Hello,Years ago I buyed a Coldfusion 10 with a 64 bits license, currently I developed some tools to Coldfusion but the services are in 32 bits.So, I need to uninstall Coldfusion 10 64 bits and install 32 bits.My question is this: Can I use a Coldfusion 10 64 bits license to Coldfusion 10 32 bits?Thanks!

Hello everyone, I have cfml code that needs to be converted to cfscript. The most of the code I was able to convert but the cfquery part that has the loop seems little complicated. Here is example of the cfml code:<cfquery name="insertRec" datasource="db" result="qryInsert">     INSERT INTO Contacts (First, Last, Email, Subject, Description)     <cfif trim(form.type) EQ 1>           VALUES(                 <cfqueryparam cfsqltype="cf_sql_varchar" value="#trim(form.first)#" maxlength="50">,                  <cfqueryparam cfsqltype="cf_sql_varchar" value="#trim(form.last)#" maxlength="50">,                  <cfqueryparam cfsqltype="cf_sq

I created a data source in ColdFusion to connect to a CFusion user in SSMS (SQL server management studio) but when I try to connect to the user through CF admin I keep getting a login failure, I have the user mapped to the database I want to connect to and the user is also a dbo, the password is the same and I have all of the right settings in the CF administrator I have TCP enabled I've tried reinstalling both ColdFusion and SQL server yet nothing is working, I don't know what I'm missing.[Here is the list of all Adobe forums... https://forums.adobe.com/welcome][Comments is to ask about the operation of the Forum, not a specific program][Moved from the Comments forum to the specific Program forum... Mod]

When i open /cf_scripts/scripts/ajax/ckeditor/plugins/filemanager/upload.cfm ,have a error.so, how can solve the problem ？

Hi,I have a CF 11 for my testing environment.I have set an instance in that application. The issue is I can open my instance administrator page but can't open the cfusion one.It just gave me a blank screen and when I look the server log it said the session manager is failed.Has anyone has a similar issue and know how to solve it? Please let me know if you need more information. Thank you.Kind Regards,Raquel Septiane

I have a cfm page with 30-40 links on it. These links send emails with attachments to different clientsI need to un this page and all of these links via a scheduled eventRather than creating 30-40 scheduled events to open each link and send the emails, is there a way to go to the page and have CF open all the links?Link1Link2Link3Link4....Link40

Uisng CF11 and need to set up a SAML SP, are there recommendation from Adobe?  Currently my organization is an Enterprise customer.  Not finding a ton of useful info online relate to this.

Persistent cookie(CFID and CFToken) have default expiry date 30 years ahead from the current date.In our application, the security team finds this data vulnerable and here is the dump snippet provided :Set-Cookie: CFID=576199; Expires=Wed, 15-Jul-2048 10:26:57 GMT; Path=/;Secure; HttpOnlySet-Cookie: CFTOKEN=d52d0264379150e2-C2C656EB-9A1E-386D-0418A9B7776141C5;Expires=Wed, 15-Jul-2048 10:26:57 GMT; Path=/; Secure; HttpOnlyX-Xss-Protection: 1; m...TRUNCATED...How can the expiry date of CFID and CFToken be modified?Is there any configuration present in Cold fusion Admin ? And after the modification, how can the change be checked ?

Помогите, пожалуйста, решить проблему с установкой ColdFusion 2018. Я не могу установить ее как администратор. Это ссылка на скриншот. https://drive.google.com/file/d/0ByTjaoWa086rWVBTa1JsdW1rdWc/view?usp=sharing

Hello,I'm wondering if there is a method to create and configure multiple ColdFusion instances from the script after the initial silent installation? Note: I have already figured out how to silently install and update default ColdFusion instance (And including multiple instances if I can create them using scripts)What I'm tying to do is to completely script multiple ColdFusion instances installation (instances with their own Apache websites and configuration files) and configuration ( Ex. deploy settings using .car file) for use in the rapid deployment using docker in the load balanced environment. If this is not possible any other suggestions are welcomed.

Hi All,Can someone suggest if CF 10 application will support in Azure cloud or not.[Here is the list of all Adobe forums... https://forums.adobe.com/welcome][Comments is to ask about the operation of the Forum, not a specific program][Moved from the Comments forum to the specific Program forum... Mod]

Our staging and production servers installed with Secure+Production profile.  Our dev server installed in Development profile.  Our dev server is able to startup within 30seconds.   However staging and production stalls excessively.  the Starting security step takes over 2 minutes.    Any ideas?    Server Details  Server Product  ColdFusion 2016  Version  2016.0.06.311392  Tomcat Version  8.5.32.0  Edition  Enterprise    Operating System  Windows Server 2016    OS Version  10.0    Update Level  C:/ColdFusion2016/cfusion/lib/updates/chf20160007.jar    Adobe Driver Version  5.1.4 (Build 0001)    JVM Details  Java Version  1.8.0_191    Java Vendor  Oracle Corporation   coldfusion-out.logNov 12, 2018 09:01:23 AM Information [localhost-startStop-1] - Starting loggi

Hello,The requirements for update 13 sound not quite clear: At the very top it says "This security update requires ColdFusion to be on JDK 7u131 or higher.". At the same time at the bottom for post installation the document states: "After installation, point the JDK to JDK 7u131 or JDK 8u121 or higher.". So, should it be just JDK 7u131, JDK 8u121 or higher? We are having Java Version 1.8.0_25 . Does it mean we are OK? Or do we have to update?TIA

I have created a simple REST service that when I register it to the built in CF server at localhost:8500 it runs without issue.  If I register it to myFQDN.com and try running it I just get an empty response within web browser and in the CF Exemption log file I see:"Error","ajp-nio-8018-exec-10","11/08/18","21:53:15","","Application test could not be found. The specific sequence of files included or processed is: '''' "Within the CF admin if I use the following to register the REST and access the URL from a browser on the server itself things run fine:Root Path: G:\Webs\myApp\TestRestService Host: localhost:8500Service Mapping: testIf I instead use the following to register things and access the URL from either a browser on the server itself or my client machine then I get the above mentioned error:Root Path: G:\Webs\myApp\TestRestService Host: myFQDN.com:443Service Mapping: testThis is a shared webserver running IIS 10 on Windows 2016 with just one single IP address, IIS has seve

I updated our dev server (CF installed in development profile) to update7 using the CFIDE.  no issues.Tried to update our staging server (CF installed in secure+production profile).   I see the System Info Update Level corrected, but the top navbar still shows the update is pending install?Server Product ColdFusion 2016 Version 2016.0.06.311392 Tomcat Version 8.5.32.0 Edition Enterprise   Operating System Windows Server 2016   OS Version 10.0   Update Level C:/ColdFusion2016/cfusion/lib/updates/chf20160007.jar   Adobe Driver Version 5.1.4 (Build 0001)  JVM Details Java Version 1.8.0_191  JVM has been updated since original CF2016 release.so did update7 actually successfully install?

Hello,I am using coldfusion 11. I inherited an application which uses the mm_wizard_login coldfusion feature  for their login functionality. Now i have to implement the change password functionality in this application.  So if the user logs in and the application finds that this user is logging in for the first time, it should redirect the user to the change their initial password.So i decided to use a jquery third party modal plugin.I have added the jquery plugin functionality in the mm_wizard_login.cfm page. During the authentication process, the scenario where the user needs to change password, the mm_wizard_authenticate.cfc denies the login and redirects them back to mm_wizard_login.cfm page and then the plugin opens up and allows user to type in their new password. After the user clicks the submit, in jquery i am intercepting their submit and i am making an ajax call to another cfc which is accepting the new password and calling a sql server SP to change their password.

Yesterday windows updates were installed on my laptop, and afterwards many features of ColdFusion were out of configuration.I am using ColdFusion 2016  and SQL Server 2016 RC.I fixed a number of issues (see below) but still get the message Connection verification failed for data source: MT_ELjava.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 8500:1433. Reason: Network is unreachable: connectThe root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 8500:1433. Reason: Network is unreachable: connect.The DSNs had been verifying for at least a year before the problems occurred.So far I have done the following:(1)      Both SQL Server and CF Server had to be started again. SQL Server was not a problem but the CF Server would not start. I went to the jvm.config file and reduced the -xms setting. This