ColdFusion

I am trying to use the <CFHTMLTOPDF> tag to generate PDF output but radio groups that have no option selected is appearing in the PDF output with the first option selected.  If I wrap the same HTML around the <CFDOCUMENT format="PDF"> tag, the radio group in the PDF output is rendered correctly (no radio buttons are selected in the group).Is this a bug with the <CFHTMLTOPDF> tag?  Is there any workaround for this issue?Thanks for your help.

When preforming a query of query I am losing the sort order of the cached query.The column that the cached query is sorting by is not one I could use in the new query. Is there any way to keep the sorting the same through both queries?Thanks

I am using window 10, 64bit on a PC. I am also using Coldfusion 2016. I did a  Coldfusion query output that displays a history of reading input of water usage for an apartment from an electronic submeter. I am able to output the date of the meter reading and the gallons of water that was used. What I'm having difficulty with is creating two additional columns that dynamically calculate within the same query output the days lapse between each meter reading and the difference in the water used since the last read. Any insights. I've listed my code.  <!---  query of submeter reading. ---> <cfquery name="list_water_usage" datasource="submeter">select * from readsubmeter where reasubid = '#choose_submeterID.subid#' Order by reasubreaddate DESC</cfquery>

Hi,Saw an old issue from 2012 (https://forums.adobe.com/message/4560283#4560283) answered in the forums for this same error happening in Coldfusion 10 (it was a bug that was fixed in an update).However, I am running Coldfusion 2016 Standard and I cannot find any answers about this issue for this version.If it matters, I am calling cfschedule via script as follows:cfschedule( action="update", task="Task1", interval="60", mode="application", starttime=timeFormat(dateAdd("s", 30, now()), "HH:mm:ss"), URL="<MY URL>", eventHandler="com.SearchTaskHandler" );Any help is appreciated.

Sorry for the vague title, but ColdFusion is not something I understand well. I'm trying to replicate a Coldfusion report in ASP.net, but I'm at a lose of where the data is coming from. I've conferred with a few developers here and we believe its the below line (in bold). Thing is....I have no idea what 'cf_act_get_remaincourses' is or comes from. I've done a search through the entire site and find no other references to it. I don't see anything in the database with a similar name.So, what is this object? (Its not a cf try, or cf it....)Where can it possibly be pulling data from.<cftry>            <cf_act_get_remaincourses userid=#GetGroupStudents.userid# datacheck=#ODBC_DataSource#>            <cfset Count = result>            <td align="center">#val(Count)#</td>      

So I have an image loader that before it uploads the file to Amazon S3 it optimises the image by using this code:<cfset ImageScaleToFit(myImage,1260,"")><cfset imageWrite(myimage,"newImagelocation", 0.9)>The odd thing is that if I upload an image that is already 1260 wide and 24k in size, then optimise it using the above code, the image becomes 34k in size.Why would optimizing an image make it bigger?

I followed the migration guide to upgrade an existing CF 10 server to CF 2016 - on Windows 2012 R2.  The upgrade seemed to go fine and I am able to get to the new CF admin to confirm migrated settings through the built in webserver.  When I try to call .cfm files directly I get 500 errors.  It is similar behavior to when the mapping is missing, but I have confirmed they are there.  I have done this on a few servers and 2 of them upgraded fine and I can call .cfm files, 2 others do not work properly.Even when browsing to the CF admin page, if there is no cfm file in the URL it comes up, then after logging in, it tried to go to 'enter.cfm' and I get a 500 error.Has anyone else had this issue after upgrading?

Hey - I recently upgraded our ColdFusion10 to ColdFusion 2016 Upgrade 3. After the initial upgrade, I opened CF Admin as local host in my browser and completed the migration settings as their instructions stated in the coldfusion-2016-lockdown-guide. After that was complete, I logged in and Server Upgrade stated I needed to upgrade to version 4. Followed the instructions, and rebooted the server to be certain the services would start, but 1 of the three services do not start. - ColdFusion 2016 Application Server service. The error is below:I typically have the service running as a service account (which has full permissions to my ColdFusion 2016 server on my E:\) I thought that my be my original issue, but when I switched it back to running as the Local System, it still will not start. Event Viewer isn't much help stating "The ColdFusion 2016 Application Server service could not be started.  Check the server "cfusion" log files for more information." Not really sure what log files

Installed CF 2016  on Unbuntu running Apache and I cannot get CF and Apache to see one another. I've searched everywhere to find how to install these "Tomcat Connectors" but all the locations the "config files are supposed to "exist" there not in my files.I found this at apache.orgYou should first have mod_jk.so (unix) or mod_jk.dll (Windows) installed in your Apache module directory (see your Apache documentation to locate it).Usual locations for modules directory on Unix:/usr/lib/apache//usr/lib/apache2//usr/local/apache/libexec//usr/local/apache/modules/but nothing ...All the documentation doesnt seem to speak to CF 2016. I found where my connectors are I just dont know the correct location is to install them...If anyone else has had this issue with this your advice and guidance would be much appreciated ...In addition.... where is my httpd file? Do I still need one ? I cant find it anywhere...

Do you have any ideas about fixing the coldfusion.runtime.SessionTracker exception? Have you encountered it before? We have, unfortunately.Our system consists of ColdFusion 11 Update 13 and IIS."Error","ajp-bio-8012-exec-4","12/15/17","06:45:30","educationLive","Could not initialize class coldfusion.runtime.SessionTracker The specific sequence of files included or processed is: E:\wwwroot\www_education_nl\htdocs\education\Facade.cfc, line: 493 "coldfusion.runtime.CustomException: Could not initialize class coldfusion.runtime.SessionTrackerat coldfusion.tagext.lang.ThrowTag.doStartTag(ThrowTag.java:142)at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3000)at cfApplication2ecfc1126640006$funcONERROR.runFunction(E:\wwwroot\www_education_nl\htdocs\Application.cfc:493)at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420)at coldfusion.runtim

Hi everyone,We currently have Coldfusion 11 running on Ubuntu 16.04 on all of our application servers.  When I came to install Coldfusion 2016 I noticed the installer failed on the Apache connector part and checked the Coldfusion 2016 support matrix here:https://helpx.adobe.com/pdf/coldfusion2016-support-matrix.pdf Which states it does not support Ubuntu 16.04 which I found odd because I've seen several posts and even this image of Coldfusion 2016 running on Ubuntu 16.04:AWS Marketplace: ColdFusion (2016 release) I'm guessing these people installing on 14.04 and then updated to 16.04.Does anyone have an tips of getting the installer to run on Ubuntu 16.04?Kind Regards,Chris

Hello,I can't seem to get CSS to work in CFHTMLtoPDF. All I need is font and font size. Is there a simple way to accomplish this task?Thanks in advance!Gary

I've been working on transforming an old CF9 form into a CF 2016 version and have everything working except . . . I have a form that folks can select various search criteria off a record (i.e. userid, sequenceNumber, PayCode, PaymentDate, ABSdollar, MinDollar, MaxDollar, etc).As the values get selected the arguments get built (some are just the value, and some are phrases - i.e. "AND abs(payment_amount) = #client.gdabsamount#") and then these values get sent serializeJSON before they go to the CFC where executed.This is where the value gets set:<CFIF LTRIM(RTRIM(client.gdabsamount)) is "">   <cfset client.gdabsamount = ""> <cfelse> <cfset client.gdabsamount = "AND abs(payment_amount) = #client.gdabsamount# "> </cfif> <cfset AP = serializeJSON(#client.gdabsamount#)><cfgrid format="html" name="grid" pagesize=18 sort="yes" selectMode="row" selectColor="##e6e6ff" height="500" width="1400"         

I recently spoke to an agent from technical support about CF licensing and he said he will connect me to someone from sales team but I never got a call back so I will try to get an answer here.I don’t know which edition of CF I need to buy, standard or enterprise. I was informed licenses are issued on a Core basis. So if I’m using 2 VMs with 4 cores each, which edition do I need? And how many licenses? Can you send me a full description on how the licensing works? I can’t seem to find anything that helps on the website.

I am setting up a new site and getting this cryptic error message. 500 errorElement NAME is undefined in a Java object of type class coldfusion.runtime.StructBean. The specific sequence of files included or processed is: I cant get any pages to run. It looks like the session vars aren't getting set. Any idea what this is? Maybe some server settings arent correct?

The core server localhost:8500/CFIDE/administrator brings up a page just fine.localhost:8250/CFIDE/ brings up a directory search, but adding administrator to the end produces a blank page with no HTML at all. administrator/index.cfm does the same. However, putting an index.cfm in the root of the IIS site directory and navigating to localhost:8250/ opens that cfm file just fine. I must be missing some property setting/permission, but I've followed the two following guides to the letter.http://wwwimages.adobe.com/content/dam/acom/en/products/coldfusion/pdfs/coldfusion-2016-lockdown-guide.pdfColdFusion Help | Web Server ManagementEnvironment: Windows Server 2012 R2. The only installs on it are IIS and CF 2016, all developer settings, using coldfusion internal server..What are my likely failure points?

I have a 2 member cluster.  If member A is running member B will not start.  If I have member B running member A will not start.  The member that fails to start will eventually time out (Window Service) with this error:ar 01, 2018 9:22:16 AM org.apache.catalina.ha.tcp.SimpleTcpCluster sendSEVERE: Unable to send message through cluster sender.org.apache.catalina.tribes.ChannelException: Operation has timed out(3000 ms.).; Faulty members:tcp://{xxx.xxx.xxx.xxx}:4005;     at org.apache.catalina.tribes.transport.nio.ParallelNioSender.sendMessage(ParallelNioSender.java:102)    at org.apache.catalina.tribes.transport.nio.PooledParallelSender.sendMessage(PooledParallelSender.java:47)    at org.apache.catalina.tribes.transport.ReplicationTransmitter.sendMessage(ReplicationTransmitter.java:57)    at org.apache.catalina.tribes.group.ChannelCoordinator.sendMessage(ChannelCoordinator.java:82)    at org.apache

Hi,We have been using CF8 for years on an xserve running cf8 enterprise (32 bit) single server mode and have had no problems. We recently added a new xserve running OS X Snow Leopard and installed CF8.01 Enterprise 64 bit in multi server mode (currently using default cfusion instance). All of the sites load correctly until we try and process images. We are seeing 2 different errors when trying to resize (or crop) an image:sealing violation: package com.sun.media.jai.util is sealedjava.lang.SecurityException: sealing violation: package com.sun.media.jai.util is sealed at java.net.URLClassLoader.defineClass(URLClassLoader.java:234) at java.net.URLClassLoader.access$000(URLClassLoader.java:58) at java.net.URLClassLoader$1.run(URLClassLoader.java:197) at java.security.AccessController.doPrivileged(Native Method) atand Could not initialize class javax.media.jai.JAIjava.lang.NoClassDefFoundError: Could not initialize class javax.media.jai.JAI at coldfusion.image.Image.resizeImageWithJAI(Imag

I'm using cfscript to create a (fairly) large xlsx spreadsheet.  As I was developing the script and the spreadsheet grew in size, I started getting the following error when attempting to open the spreadsheet:I narrowed down the problem to my use of the functions used to format cells (specifically, SpreadSheetFormatCell and SpreadSheetFormatCellRange).  I found that by commenting out some of those function calls, the error would disappear.After much trial and error, I've now come to believe that the issue isn't incorrect usage of the formatting functions, but rather some sort of internal limit I'm running into.  I threw together a simple test case to show this.  The following code (named "bigSheetTest.cfm" on my system) can be used to show the problem (at least on my machine):<cfscript>maxrows = 725;formatBoldCenter = StructNew();formatBoldCenter.bold = "true";formatBoldCenter.alignment = "center";formatBoldUnderlineCenter = StructNew();formatBoldUnderlineCente

One of my site which runs on ColdFusion is opening debugging site instead of normal site. Whatever option i click on the site there is a ColdFusion debugging window opening. I the home page of the site also i am getting options Debug this page and Docked debug pane. What might be the cause for this sudden change . How to resolve it ?

CF trows me out every time I try to submit the DSN the page http://127.0.0.1:8500/CFIDE/administrator/index.cfm?target=%2FCFIDE%2Fadministrator%2Fdatasources%2Findex.cfm  gives an error (There was an error accessing this page. Check logs for more details).It's on my new installed local develop machine. I suspect something has been done wrong with the insatllatieonSomebody an idea?psApplication log tells me: There was an error while verifying the token. Either the session timed out or un-authenticated access is suspected.

In ColdFusion 10 Administrator > Data & Services > Flex Integration > Flash Remoting. The description says, "Lets a Flash client connect to this ColdFusion server and invoke ColdFusion Components (CFCs). NOTE: Disabling this feature also disables ColdFusion server monitoring and multiserver monitoring." I don't think we run any monitoring. However, is there a way for me to verify that before I disabled this option?

Hi,I'm trying to collect data from two separate tables in the same database.  One table holds the data for the topics and the other holds the data for the replies to that topic.  I want to combine these two so I can output one list that lists the topics posted by a user and the replies made by that same user together in a single recordset. (I'm testing it with '2' as the user_id).  The problem is that I'm seeing double when I test the recordset. This is how I've created the recordset so far:SELECT boardtopics.user_id as t1_user_id, board_replies.user_id as t2_user_id, boardtopics.title as t1_title, board_replies.title as t2_titleFROM boardtopics, board_repliesWHERE boardtopics.user_id = 2 AND board_replies.user_id = 2​any help would be greatly appreciated.Thank you,Michael

we have problems with PDFs created with cfdocument (CF 11) and the Microsoft Edge Browser.Edge shows only a white page.Here is the Link to a Sample Document, please try it on Edge:https://unimedia.ag/Rechnung.pdf The same PDF, but opened and saved with Acrobat DC.This PDF is shown in Edgehttps://unimedia.ag/Rechnung2.pdf What can we do to create compatible PDFs also for Edge with cfdocument?Thanks in advanceHerbert

I have a routine that properly encrypts and then decrypts data, using CF, into a SQL table. My encrypt function is as simple as: encrypt('secure text', [seed key], 'AES')I can use this to insert data into a MS SQL varchar(50) field, and then later retrieve those results using CF, use the CF decrypt function, and get my 'secure text' back in plain text. This has all worked perfectly well for years.I now have a need to decrypt the 'secure text' using SQL directly, not ColdFusion. I have found the SQL EncryptByKey and DecryptByKey functions, but even though I'm using the same [seed key] string, and using the AES_128 SQL algorithm, it's not properly decrypting things. Is this just general incompatibility, and I should stop trying, or is there a way to align the CF encryption and the SQL decryption to make them compatible?The SQL function I'm using looks like this:CREATE SYMMETRIC KEY AES128SecureSymmetricKey   WITH ALGORITHM = AES_128   ENCRYPTION BY PASSWORD = N'[seed