ColdFusion

I'd like to be able to use a hex value for color like: <cfset SpreadsheetFormatCell(xl,{color="#FE0000",fgcolor="#Clr#"},#xl.rowcount#,1)> or <cfset SpreadsheetFormatCell(xl,{color="#355f91",fgcolor="#Clr#"},#xl.rowcount#,1)> Currently you can only use this list of predefined colors:Colors="black,brown,olive_green,dark_green,dark_teal,dark_blue,indigo,grey_80_percent,orange,dark_yellow,green,teal,blue,blue_grey,grey_50_percent,red,light_orange,lime,sea_green,aqua,light_blue,violet,grey_40_percent,pink,gold,yellow,bright_green,turquoise,dark_red,sky_blue,plum,grey_25_percent,rose,light_yellow,light_green,light_turquoise,light_turquoise,pale_blue,lavender,white,cornflower_blue,lemon_chiffon,maroon,orchid,coral,royal_blue,light_cornflower_blue"

Hi.How can I do a cfhttp POST call, to API, in CF21, with this required parmeters:APIKEY (string) header; DOC (file pdf) formdata; TEXT (string) formdata Something like this:"<cffile action="readBinary" file="filePathName" variable="attachedFile"><cfset attachedFile=binaryEncode(attachedFile,"BASE64")><cfhttp url="#externalUrlToCall_notColdfusion#" method="POST" charset="utf-8" result="apiresult" timeout="10" multipart="yes" multipartType="form-data"><cfhttpparam type="header" name="Content-Type" value="multipart/form-data"> <cfhttpparam type="header" name="APIKEY" value="#CONSTapiKey#"><cfhttpparam type="header" name="Content-Disposition" value="form-data; name='DOC'; filename='fileName'"><cfhttpparam type="formfield" name="DOC" value="#attachedFile#"><cfhttpparam type="formfield" name="TEXT" value="Hello"></cfhttp>"  I'm new in API call and this don't work in CF 21 (in postman or python it works).What am I doin

Hello all, We recently upgraded to Coldfusion 2021 from a working Coldfusion 9. One of the applicatons uses the jquery .ajax function and serializeJSOn in Coldfusion.  Under version 9, it all works well, and returns to the javascript an array with ROWCOUNT, COLUMNS, and DATA.   Under 2021, it does not work properly.  After some research, I have changed the #SerializeJSON(goat, true)# to #SerializeJSON(goat, "Struct" )#, and tried other various things.   Interestingly, the 2021 javascript is not even fired under the "success" option in .ajax.   Could anyone point me in the right direction? Thanks, Jim

My team develops and maintains a Coldfusion application (using CF 2018 Update 15) including multiple occasionally connected clients using the flex gateway for data exchange.Currently our application is being migrated to new server infrastructure and on the new servers we need help with a problem. On the old servers we had the following JVM timezone configuration: -Duser.timezone=NewYorkThis had to be added because without this timezone parameter some objects could not be synchronized between the flex clients and the server. All of our servers are in timezone CET, but on the old servers everything worked well. The time used in the Coldfusion application was server time (CET). On the new servers with the same JVM configuration the server time again is CET, but Coldfusion now internally uses timezone NewYork. When we configure CET in the JVM everything is ok in the Web application, but again the Flex clients fail to synchronize. The only difference I can see betwe

We would like to update our Coldfusion servers from CF 2018 to CF 2021, but we still have mobile apps using flash remoting in connection with the coldfusion servers. We are working on replacing those apps, but this needs time.On the page about deprecated features I can see that the flash remoting was retired in CF 2018 but I do not see that it was removed in CF 2021.But when I install CF 2021 there is no administration for flash remoting any more and I did not find out how to get it alive again.Is it possible to use flash remoting in CF 2021 or was it removed without documentation on the deprecated features page?

Sans CFdocument !Avec CFdocument !  La présentation n'est plus la même ! Problème de police de caractères et de mise en place, ...Le fautif : <CFDOCUMENT format="pdf" filename="../../#session.site#/_Facturier/Facture_#Session.Fac#.pdf" pagetype="A4" unit="cm" overwrite="true">De plus, joint à email, il ne s'ouvre pas !Merci par avance pour votre aide.MEILLEURS VOEUX pour 2023.

I would like to be able to format part of a cell so that the output looks like:Updated for SSEWG: Yes Date: 8/31/2022instead of having to put each section into a different cell like:Updated for SSEWG:YesDate:31-Aug-2022                

Hello, first off I stink at CSS. Issue is I can't get all the buttons to be dead center in their div when they're in a form field. So far I can only get one to do it (which is odd). You can see I don't really know how to use grid-column or grid-rows that well. Please help fix this: <html> <head> <style> div.container { display: grid; grid-template-columns: 100px 20px auto; grid-template-rows: auto; margin-left: auto; margin-right: auto; } div.header { grid-column-start: 1; grid-column-end: 5; grid-row-start: 1; grid-row-end: 5; background-color: white; width: 100px; border: 1px solid #000000; } div.fouth { grid-column-end: 4; grid-row-start: 3; grid-row-end; 3; background-color: Silver; width: 100px; height: 30px; border: 1px solid #000000; display: flex; justify-content: center; align-items: center; } div.middle { grid-column-start: 3; grid-column-end: 5; grid-row-start: 1; grid-row-end; 1; background-color: Silver; width: 100px; height: 30px; border: 1p

Our ColdFusion application is based on a page with all the menu options that calls the selected pages within a frame.How can we display details of the page called in the browser tab : the standard <title> tag is not shown (as it is within a frame).Ideally display the title, but the URL or any other unique identifying value will do. Code extracts : In the Frame called “main” we initially show the welcome page, and when the relevant menu button is clicked, the Java script  function replaces the contents of the “main” frame with the new page. <FRAMESET …>                <FRAME SRC="../menuContents.cfm" NAME="Contents" … >                <FRAME SRC="../welcome.cfm" NAME="main" …></FRAMESET><noframes></noframes> <td><input name="image" type="image" onClick="power('xxx.

Hi,Recently deployed ColdFusion 2021 on Centos 7.9.  Also downloaded and installe the hotfix.  I soon discovered wsconfig would not run and I found the articles about downloading a new wsconfig.jar  With the new jar installed wsconfig will run but now complains that "Coldfusion could not locate the connector for this configuration.  Refer to documentation for suppported web server for you OS."The detected Apache version is 2.4.6 and I do see mod_jk24.so in the jar file.  Am I missing something?  

We installed the ColdFusion 2021 version on a new server and configured the existing Coldfusion applications to run on it. One of the ColdFusion applications, which does not have any file with .hbmxml extension works fine, but the other application has a few file with .hbmxml extension gives the following error. We verified the IIS web server's request filtering list to be sure .hbmxml extension is not in the block extensions list. Is there any other configuration files should be updated to run the hibernation files without any problem? Thank you for your help!The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.Null Pointers are another name for undefined values.java.lang.NullPointerExceptionat com.sun.xml.bind.v2.runtime.unmarshaller.StAXConnector$1.getPublicId(StAXConnector.java:101)at org.apache.xerces.util.SAXLocatorWrapper.getPublicId(Unknown Source)at org.apache.xerces.xni.parser.XMLParseExceptio

I tried to automate my installation and configuration for CF2021 on a docker container but i´m stuck with importing the exported configuration of datasources type "other" ( Custom Microsoft JDBC Driver provided through .jar in cfusion/lib folder).My steps where:1. Start Docker Container & import .jar file in lib2. Create the datasource on CFAdmin - connection established - everything green and connection works with cfquery.3. cfsetup export datasource datasource.json cfusion4. Throw away docker container & Start new5. cfsetup import datasource datasource.json cfusionError Message:ERR: Validation failed for following setting(s) in DATASOURCE:DRIVER.ERR: Import of datasource_test in DATASOURCE is unsuccessful.ERR: Import of DATASOURCE is unsuccessful.As the error messages mentiones "DRIVER" i looked at the json to find this line:"DRIVER": "Microsoft JDBC 7.4.1 Driver",I already tried to remove the . and whitespaces - same results. I also tried the exact s

HelloI am having a strange issue. I am trying to implement a websocket with proxy in CF2021, and when I go to the Server Settings->Websocket page in the CF Admin, and select the radio button Use Proxy option, the Submit Changes button disappears?!? What would cause this? I am on:CF2021, Version: 2021.0.03.329779Ubuntu 20.04LTS Anyone have any suggestions?thanks in advance

I can not access SBA Profile DSBS FOR spreadsheets 

What is the chr code for a ballot box with and without x?  I found where is says it should be:#chr(2612)# #chr(2610)# #chr(2611)# but they do not work.

I'd like to be able to use a hex value for color like: <cfset SpreadsheetFormatCell(xl,{color="#FE0000",fgcolor="#Clr#"},#xl.rowcount#,1)> or <cfset SpreadsheetFormatCell(xl,{color="#355f91",fgcolor="#Clr#"},#xl.rowcount#,1)> Currently you can only use this list of predefined colors:Colors="black,brown,olive_green,dark_green,dark_teal,dark_blue,indigo,grey_80_percent,orange,dark_yellow,green,teal,blue,blue_grey,grey_50_percent,red,light_orange,lime,sea_green,aqua,light_blue,violet,grey_40_percent,pink,gold,yellow,bright_green,turquoise,dark_red,sky_blue,plum,grey_25_percent,rose,light_yellow,light_green,light_turquoise,light_turquoise,pale_blue,lavender,white,cornflower_blue,lemon_chiffon,maroon,orchid,coral,royal_blue,light_cornflower_blue"

I would like to be able to format part of a cell so that the output looks like:Updated for SSEWG: Yes Date: 8/31/2022instead of having to put each section into a different cell like:Updated for SSEWG:YesDate:31-Aug-2022 

Saw note to use getColumn width from a static function but don't know how to call it within coldfusion. static int getWidth(Sheet sheet, int col) { int width = sheet.getColumnWidth(col); if (width == sheet.getDefaultColumnWidth()) { width = (int) (width * 256); } return width;} 

When creating an RDS connection to the internal CF9 server (127.0.0.1:8500) I get a popup box with a red 'X' saying 'Unable to contact RDS Server "Home."  Error Executing RDS command. Status Code: 404, Reason : Not Found'Why am I getting this message? It would be nice if we could connect to a database directly in CFB without having to use RDS. (hint hint)

Hi, I installed ColdFusion Builder Extension for Visual Studio Code. I also have the Prettier extension installed to handle formatting.  I got a notification in VSCode saying something like "Prettier is unable to format ColdFusion files (CFML), please pick a different default formatter".  The option presented was to use "Adobe ColdFusion Builder", so I selected it.  Now when I view and save .cfm files it formats the files automatically. The issue is that I don't like how it formats the files.  Can this be adjusted?   Besides the fact that I don't like the way it does or does not indent JavaScript on the page, the biggest issue is it forces a hard line break at around a 100 characters that is notably moving some of my single line javascript comments to the next line resuling in uncommented text.Example:   //Imagine comment longer than 100 characters...end of comment.   When I save it changed it to:   //

Comment protéger sa base de données quand on est obligé de l'ouvrir pour oploader des images ?Tout est dans le titre !!Merci pour votre avisCordialement How to protect your database when you have to open it to opload images?Everything is in the title !!thank you for your opinionCordially  

I know that folks are using the JDBC connectors (with some gymnastics) to attach ColdFusion X to Azure SQL.  I had previously done this in coldFusion 9 but found that under a load, it was less than desirable (allowing timeouts and conection refusals in the connection pool).So in coldFusion 10 I came across being able to use the Microsoft SQL driver by simply adding this line to make it use SSL:EncryptionMethod=SSL;(in the connection string box)I can't find the chatter on this, but it makes more sense to me to use the built in sql driver instead of JDBC with some JAR updating and restarting..  (feels 3rd party to me!)All was well, for over a year. These work very nicely and perfectly. Impressive, even.So I now do the EXACT SAME  on ColdFusion 11 and I get: Connection verification failed for data source: cadxAppjava.sql.SQLException: Timed out trying to establish connectionThe root cause was that: java.sql.SQLException: Timed out trying to establish connectionLike nothing

I just applied update 5 and now I am getting XML errors:"Error","ajp-nio-127.0.0.1-8020-exec-10","10/13/22","11:28:42","Medlists3","coldfusion.runtime.CFPage.XmlSearch(Lcoldfusion/xml/XmlNodeList;Ljava/lang/String;)Ljava/lang/Object;https://helpx.adobe.com/coldfusion/kb/coldfusion-2021-update-5.html saysCHANGE IN XMLIf the XML path contains a forward slash or backslash, it will be blocked. The flag, coldfusion.xml.allowPathCharacters, must be set to true to allow the same.But I don't know where to make this change.

Is there a way to programmatically turn off grid lines like you can do from within an excel file by selecting “View” and uncheck gridlines?

Hi Everyone, IIS connector log (isapi_redirect.log) is around 1.5 GB and keeps increasing, it stores the same warning message each time:[9544:15528] [warn] ajp_process_callback::jk_ajp_common.c (2245): (cfusion) AJP13 protocol: Reuse is set to false Most important after 2 - 3 days it throws Error 503 Service Unavailable. Server Info:Coldfusion 2018.0.15.330106Java HotSpot(TM) 64-Bit Server VM - 11.0.12+8-LTS-237Tomcat 9.0.60.0IIS 10.0Windows Server 2019 Connector Settings:worker.cfusion.type=ajp13worker.cfusion.host=localhostworker.cfusion.port=8018worker.cfusion.connection_pool_size=1000worker.cfusion.connection_pool_timeout=60worker.cfusion.max_reuse_connections=1000 Please advice.Thanks in advance