Questions

Hello, all,I have been trying to use a modulus in a QoQ, and it's not working.SELECT cola, colb, colc FROM queryName WHERE cola % 2 = 0 /* cola is an integer 1 - 10 */.. and I get..Encountered "cola 2 =. Incorrect conditional expression, Incorrect conditional expression, Lexical error at line 1, column 45. Encountered: " " (32), after : "%" The error occurred on line 445.(There are 16 lines of code, so I assume that the line 445 is in query.cfc.)Can you use % or mod() in a QoQ???V/r,^ _ ^

Found a minor issue with running 2016 Enterprise (update 5) on 2016 Win Server, versus 2016 Dev (update 5) on Win 10.the cfif construct <cfif variable is "something"> or <cfif variable is not "something"> while was working in Dev 2016 fine, and earlier editions of CF, does not function on CF 2016 Enterprise.Workaround was to convert the Is and is not to EQ and NEQ.Not sure why there is a difference between the two platforms, but posting it as an awareness. Has anyone else seen this behavior?

Dear,I am using coldfusion8.And when trying to connect to a sql server data source which need to provide a servername. I had provided one domain name.But cfusion said that the IP cannot be established the connection.I guess cfusion has parsed the domain name to IP and using IP to connect.That will not be allowed by the sql server data source.How should I configure to make cfusion accept a domain name without paring it?Thanks.

Hello, I have been using a Dynamic Dependent PHP Drop Down Box extension for the last 2 years .I have just updated my web site to PHP7 mysqli and I cannot get it to work as it will only accept mysql. Any one got any ideas as to  how I can get it working Any updates for this extension, Help appreciated

I have a CFC that works fine. I can access it directly and get data etc. I even have it working find on another server with the same datasource. I am binding the cfc to a cfselect like so.<cfform><cfselect name="category" bind="cfc:cfc.GetCategory.getCategory()" bindonload="true"></cfselect></cfform>My cfc is located in a directory name cfc. The name is GetCategory.cfc and the method is getCategory. I an access it fine by goign to the URL as so.http://siteurl/cfc/GetCategory.cfc?method=getCategoryIt displays the data fine.However when I try to look at the page the cfselect is on it shows me an empty drop down box with no selections. I can see using the cfdebug in the url that the cfc is being executed properly and returning data. It is just not showing up in the drop down. I have been banging my head against this one for a few days now so any outside eyes would be helpful. Anybody else run into this issue where the cfc works fine but does not appear to be bindin

HelloI do not understand why the following phrase is good:<CFFORM action="../../Admin/_modules/inc_Modale.cfm?fen=Pop.LoginEntry.cfm&PageUrl=#PageUrl###oModal" method="post">and the next one does not pass:<CFINCLUDE template="../../Admin/_modules/inc_Modale.cfm?fen=Pop.cookies.cfm##oModal">thank you in advance for your help

Hello everyone,I'm looking for answers to why a webservice is failing.First a little background:Running coldfusion2016 multiple instancesapache 2.4.27openssl 1.0.1lUnix virtual environmentI have this .cfc application that runs fine http but when we force https by apache vhost redirect I start seeing the following in coldfusion exception logs and the service fails."Error","ajp-nio-8030-exec-3","10/16/17","17:24:10","Planning_Complete","The web service operation caused an invocation exception.The root cause was that: javax.servlet.ServletException: https is forbidden The specific sequence of files included or processed is: /webservices/planning/planning_project_complete.cfc'' "coldfusion.filter.AxisFilter$WebServiceInvocationException: The web service operation caused an invocation exception.at coldfusion.filter.AxisFilter.invoke(AxisFilter.java:95)at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505)at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)at coldfu

I have query which should filter the where clause condition depends on the URL parameter to the page?With CFQuery:<cfquery name="GetUser" datasource="Sample">    Select *from Users     where <cfif url.type EQ 1>userid=123<cfelse>userid=456</cfif></cfquery>the same query i am tryinng to write with ORMExecuteQuery, i am failing to write it.Please help me on this.Thanks in advance

Hi,I am re-writing all the CF charts on out website and want a stylesheet to hold our coperate colours.I am using the below JSON code at the moment by i cant find the code that specifes chartseries colours?I want to be able to use this style sheet for any chart. There used to be a cf tag called colorlist but i belive this is only for pie charts.Test Chart below calling cf_style_sheet_test<!--Chart--><CFCHART title="Test"  format="png" style="cf_style_test" chartheight="900" chartwidth="900" yaxistitle="Spend £k" xaxistitle="Years" plot="#plot#"> <!--- Baseline - LINE---> <CFCHARTSERIES type="line" serieslabel="Baseline">   <cfchartdata item="15/16" value="10">   <cfchartdata item="16/17" value="20">   <cfchartdata item="17/18" value="30">   <cfchartdata item="18/19" value="40">   <cfchartdata item="19/20" value="50">   <cfchartdata item="20/21" value="60"> 

I'm looking into install ColdFusion 11 Server Enterprise. I like to know if there is a limitation on the number of processors.

So after I've finish installing Coldfusion 11 Enterprise version, the "Launch the Configuration Wizard in the default browser." checkbox was checked. I click the Done button and the default browser was launched to http://localhost/CFIDE/Administrator/index.cfm  but here's the error page.Network Access Message: The page cannot be displayed Explanation: There is a problem with the page you are trying to reach and it cannot be displayed.   Try the following:  Refresh page: Search for the page again by clicking the Refresh button. The timeout may have occurred due to Internet congestion.Check spelling: Check that you typed the Web page address correctly. The address may have been mistyped.Access from a link: If there is a link to the page you are looking for, try accessing the page from that link.   If you are still not able to view the requested page, try contacting your administrator or Helpdesk.   Technical Information (for support personnel) Error Code: 502 P

Hello,I don't know if it is possible or not.I generate and Excel document with ColdFusion 10.I would like to activate the "Track Changes" with Coldfusion or how can I activate the track changes automatically?Is it possible or not?Thank you in advance for your supportBest regardsAndré

I had the following PHP code that posts XML data and retrieves the status as successful post or not This is a valid code and running fine using PHP. This code was sent by the company to test the api, but as the development is done using ColdFusion I wrote a code, given below in ColdFusion, Its sends an OK response but returns an error code as per behavior or the API.PHP Code:<?php define('blueEx', "http://benefit.blue-ex.com/api/post.php");$xml = '<?xml version="1.0" encoding="utf-8"?><BenefitDocument><AccessRequest><DocumentType>1</DocumentType><TestTransaction>Y</TestTransaction>*For Testing purpose, after testing leave it blank<ShipmentDetail>   <ShipperName></ShipperName>   <ShipperAddress></ShipperAddress>   <ShipperContact></ShipperContact>   <ShipperEmail></ShipperEmail>   <ConsigneeName>Tayyab</ConsigneeName> &nbsp

Hi, i'm using Aurigma image uploader to upload photos for a used tire website and i want to have specific names for the photos so they dont get overwrite so i use my clientID and the next ID in my tire databasse plus i want to add the loopcount and the end so i upload the image then i rename them but my index i stays a 0 in destination = "D:\MYPATH\#clientID#_#nextID#_#i#" i only get 1 out of my 5 images in my directory somthing like 12_176_0.jpg and its the last one that got uploaded so why is my i index not adding up ? <cfset fileCount=(#Form.PackageFileCount#-1) /><cfloop index="i" from="0" to="#fileCount#">    <cfset name="#Form["SourceName_#i#"]#"/>    <!--- Get source file and save it to disk. --->    <cffile action="UPLOAD" filefield="File0_#i#"         destination="D:\MYPATH\"         nameconflict="MakeUnique">    &

I have the following PHP Code that uses an AES/ECB/PKCS5PaddingPHP Code:$hashRequest = '';$hashKey = 'HM53BC0C176Z58PV';$mapString='amount=30.0&autoRedirect=0&emailAddr=fakhar.munir88@gmail.com&expiryDate=20190721 112300&mobileNum=03345400644&orderRefNum=1008&paymentMethod=MA_PAYMENT_METHOD&postBackURL=http://shopweb.windsorparking.com/php/getToken.php&storeId=3528'// Encrypting mapStringfunction pkcs5_pad($text, $blocksize) {      $pad = $blocksize - (strlen($text) % $blocksize);      return $text . str_repeat(chr($pad), $pad);}$alg = MCRYPT_RIJNDAEL_128; // AES$mode = MCRYPT_MODE_ECB; // ECB$iv_size = mcrypt_get_iv_size($alg, $mode);$block_size = mcrypt_get_block_size($alg, $mode);$iv = mcrypt_create_iv($iv_size, MCRYPT_DEV_URANDOM);$mapString = pkcs5_pad($mapString, $block_size);$crypttext = mcrypt_encrypt($alg, $hashKey, $mapString, $mode, $iv);$hashRequest = base64_encode($crypttext);// end encryptio

Can I manipulate spreadsheets of Excel or OpenOffice with ColdFusion 11 Standard Edition?At the following linkhttp://www.adobe.com/it/products/coldfusion-family/buying-guide.htmlit seem that on Standard Edition there are restricted functionality...Thanks a lotLiciof

Dear,I'm try to install my coldfusion 8 by following the steps in Aaron West's Technology Blog: Super Guide: Installing ColdFusion 9 on CentOS Linux But then I'm facing with permission problem and could not start cfusion 8 properly.Is there any expertise can help me a look?Thanks.Last login: Mon Oct  9 08:29:39 on ttys002You have new mail.Thais-MBP:~ chuong$ ssh hai.tranthi@10.10.134.10hai.tranthi@10.10.134.10's password: Authentication failed.Thais-MBP:~ chuong$ ssh hai.tranthi@10.10.134.10hai.tranthi@10.10.134.10's password: Last login: Mon Oct  9 00:10:18 2017 from ip-10-10-0-72.eu-west-1.compute.internal       __|  __|_  )       _|  (     /   Amazon Linux AMI      ___|\___|___|https://aws.amazon.com/amazon-linux-ami/2017.03-release-notes/8 package(s) needed for security, out of 25 availableRun "sudo yum update" to apply all updates.Amazon Linux

How many cpu cores are needed?

I am working on getting ColdFusion 2016 up and having a problem installing hotfix 5.No matter what value I put in as a response to the request:Select the home directory of your  installation. For example, /Applications/For J2EE installation, it is the WAR directory containing WEB-INF, CFIDE and META-INFWhere is  located? (Default: /opt):I get the response:The specified directory is not valid.I tried the top installation directory '/opt/coldfusion2016' and everything that I thoughtpossibly reasonable below that.Help please? Any ideas on this?

I have a scheduled task that sends out a bunch of newsletters every day. It has been running smoothly for more than a year when it suddenly started to run twice - sending out the emails twice and updating the count twice. There have ben no changes to the source code, hardware, operating system, etc. The only change is that upgraded from MX7 to CF8. Each time it sends a newsletter out it adds a record to a log table that is incremented automatically. From the sequencing of these records I know that it is actually running the stored procedured twice in parrallel in as much as the record ids on the duplicate records are always from 1 to 9 records apart whereas the set is more than 175 records long (the sequence gap should be at 175 records apart if it was run sequentially. Also, the CF scheduler log only records the task as having run once. Other scheduled tasks also run twice. The server is a Dell 1950 Dual Zeon server. CF8 is ver. 8,0,1,195765 Standard running on Windows 2003 Stan

Hi Everyone, i still have not found a solution to this. if anyone has any other suggestions please let me know. Also i would like to report this as a bug, what is the proper procedure for reporting this? thanks to all Tim Original- Hi All, i have had issues since upgrading from 6 to 7 with cfschedule. sometimes it runs fine, other times it will run the same task multiple times in a row, other times it will wait an hour then run the same task again. This may not sound like a big deal, but the tasks send out several thousands of emails. talk about spam!! I have been screamed at on a weekly basis to make this stop. Now since the the DST change, the tasks that were scheduled at 3pm run at 3pm and again at 4pm!! Please someone help!!!!!!!!!!!!!!!!!!!!! Thanks in advance. Tim

Hi,I'm running ColdFusion 10 Enterprise on a RHEL 6 server and have come across an intersting behaviour in relation to the scheduled tasks we have setup.We noticed that after a reboot of our ColdFusion server that the scheduled tasks weren't running correctly.When I looked in the http.log file I could see that it was trying to execute the correct template"Information","DefaultQuartzScheduler_Worker-9","10/25/13","07:18:16",,"Starting HTTP request {URL='...', method='get'}"But the request never appears to be completed. When a task successfully runs you would expect to see a completed line as well in the http.log file"Information","DefaultQuartzScheduler_Worker-9","10/25/13","07:18:21",,"HTTP request completed  {Status Code=200 ,Time taken=4896 ms}"For some reason after the server reboot the task is triggered, but it never runs and never shows as being complete.I was playing changing settings in the scheduled task and checked the Save output to a file check box. As soon as I did tha

This issue just started this morning, has never happened before:I remoted into my Coldfusion server via Remote DesktopI opened IE and tried to log into the CF Admin pageThe browser just kept spinning, page never displayedThen I started getting calls from all of my users saying that all the CF sites were down!To fix:I had to reboot the server.Notes:If I try browsing to the CF Admin page, all of the sites go down again?If I don't try to browse/open the CF Admin page, the CF sites stay up and run fine.Specs:Windows Server 2008 R2 DatacenterColdfusion 9 MySQL 5.5IIS 7.5

<cfsearch name = "mySearch" collection = "mycollection" criteria = ' 2016' type="standard" startrow="1" maxrows = "100"> returning Error executing query : Unexpected EOF; was expecting a close tag for element <str>on another isnastance testing one of the samplesEncountered " "}" "} "" at line 1, column 22.??Was expecting one of:?? "TO" ...?? <RANGEEX_QUOTED> ...?? <RANGEEX_GOOP> ...?? Any ideas?Thanks-Kevin

Windows Server 2008, Coldfusion 9 (32-bit)Not sure why, but the neo-cron.xml keeps getting re-written to become a 0 byte file. (This file takes care of the scheduler tasks.) It was fine before the 9.0.1 upgrade. Whenever I can't log into the Coldfusion administrator, I need to reload the file from my backup copy, save it and reboot Coldfusion Service.For those that need a basic neo-cron.xml file because you do not have a backup, I was able to get one from the Internet. Simply use notebook and copy this into the neo-cron.xml located at /Coldfusion9/lib/<wddxPacket version='1.0'><header/><data><array length='2'><struct type='coldfusion.server.ConfigMap'></struct><boolean value='false'/></array></data></wddxPacket>After you restore your scheduled tasks, be sure to copy it some place where you can restore it from.It would be nice if I did not have to restore this every few weeks. If anyone has some ideas as to why, I am open to te