Questions

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

Just learned about CF2021, downloaded the 2021  developer version and having weird issues with cfselect tag.I have 2 forms, registration and request forms. both use cfselect tags to create two or three dependent dropdowns.On my registration form:I have 3 dependent dropdowns. A states dropdown,  zip codes and US cities dropdown all use cfselect.  When user select a state, related zipcodes populate the second dropdown and then when a zipcode is selected the related city gets selected in the 3rd dropdown. All work great. The selected, value and message attributes all are working just great! (codes below):States dropdown:<cfselect name="StateCode" bind="cfc:cfcomponents.RegLocation.GetStates()" selected="#GetUser.State#" bindonload="true" required="yes" message="Please select your State" class="smallstylebox" value="#Trim(GetUser.State)#"/>ZipCode dropdown:<cfselect name="ZipCode" bind="cfc:cfcomponents.RegLocation.GetZipCode({StateCode})" selected="#GetUser.Zip#" c

I have a query which I try to fetch records using IN operator. But the record retrieves only first data not all data . What I have tried is<cfargument name="names" type="struct" >SELECTID,Name,TitleFROMtblabcdWHEREActive = 1AND Name IN(<cfqueryparam value="#arguments.names.data#" cfsqltype="cf_sql_varchar" list="yes" separator="|">)</cfquery>Here arguments.names.data = abc data | efg nameQuery return only data of "abc data"How to return both data's from this query using IN operator.

hello, on http://localhost:8500/CFIDE/administrator/ I am getting an error with the message "coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Runtime service is not available."I am running CF21 on macOS Monterey. The java version on my system is  "19.0.1". Please help with any ideas on how to overcome this. Thank you.   

Good afternoon,In an attempt to finally upgrade my environment from CF2016 to CF2021, one of my servers is experiencing an issue with losing connectivity to the data sources. Upon reviewing the coldfusion-error.log I find the following error on each of the data sources: "java.lang.NoClassDefFoundError: Could not initialize class com.microsoft.sqlserver.jdbc.DriverJDBCVersion.".The required files are installed to cfusion>lib: mssql-jdbc_auth-11.2.0.x64.dll and mssql-jdbc-11.2.0.jre11.jar.I was able to correct the issue by shutting down ColdFusion services and clearing out the contents of the cfusion>wwwroot>WEB-INF>cfclasses and restarting ColdFusion but this is not a viable solution for a Production system.Any idea what might be going on? I am on the latest update of CF2021.

I have an index page that calls several includes using variables. Part of my site has an inventory section. I would like to insert the name of the inventory item into the title tag. From the index, I can tailor the title tag in the header to show the section and categories, but since the query for the individual item is in the included file, that variable doesn't exist yet when the index comes up. I tried to use the cfhtmlhead from the inventory page, but it neither adds to nor replaces the title that is called in the index.cfm page. Here is my code, but it doesn't work.<cfhtmlhead text="<title>xxxx</title>"></cfhtmlhead> I guess, I could pass the inventory item name in the URL, but most items have spaces in them and then I have to deal with that too.Thanks, Kirk

Is this a bug? The cfsqltype cf_sql_smallint type doesn't work for any integer under 99, but the cfsqltype cf_sql_smallint does. For example - <cfset cookie.factId = 1> <cfquery name="factMatchSelect" dbtype="query"> SELECT id FROM factSelect WHERE id = <cfqueryparam value="#cookie.factId#" cfsqltype="cf_sql_tinyint"> </cfquery> 

Is this a bug? Running the following produces an error no matter what 'type' attribute value is entered, even 'any'. However, it runs fine when the type attribute is omitted. <cfparam name="cookie.factId" type="any" default="1">    

never had this issue before but when querying a db from my component I received the following error: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'collection_lines'. The query works just fine from console and the table exists all db privilages match. To troubleshoot i pulled the same query from my cfm page rather than the component and it functioned normally.

We recently installed CF2021 and our IT department flagged us as having an old JRE installed in Coldfusion2021\cfusion\jetty\jre.  We already configured CF itself to use a different JRE instead of the one in Coldfusion2021\jre, and we also set jetty to use the same JRE by changing the path in the jetty.lax file.  Interestingly, it originally referenced the main JRE, not the copy in the jetty folder.  As far as I can see, there's no reference to the jre in the jetty folder - is it safe to delete this?  Or do we need to maintain this jre as well?

I'm using cfdocument to create a pdf. Displaying the pdf in the browser works fine, but I would like to just open a download prompt when the user opens that url.<cfdocument format="PDF" localUrl="yes" margintop="0.25" orientation="landscape">What I tried: I followed this and added a filename: https://community.adobe.com/t5/coldfusion-discussions/how-to-use-cfdocument-create-a-pdf-file-and-save-the-file-in-server/td-p/966276But it just saves that file in a lucee temp folder. I also tried using a header like this:<cfdocument format="PDF" localUrl="yes" margintop="0.25" orientation="landscape"> ... Your PDF content goes here... </cfdocument> <cfheader name="Content-Disposition" value="attachment; filename=your-file-name.pdf"> <cfcontent type="application/pdf" file="#expandPath('your-file-path.pdf')#">But it also doesn't open a download prompt. What I want is that it opens a prompt and asks the user, where he wants to save that file.

Hey folks.     I have 10 file upload files for users to upload up to 10 different images into the same folder, but not sure how i should go about it. I did 10 different inserts, but it seemed very "chicken scratch" type coding. Not sure how to do it any other way, which brings me here. Can someone give me some direction on how to do it better?I should say i have 10 different upload fields because i need the files to be named something like "page1.jpg, page2.jpg....etc". I could be doing this wrong too. I don't know. Any advice will be great.Thanks

Hi,We have a load balanced environment (netscaler).  When a user hits a page the load balancer sends the request to a particular box with sticky sessions by IP which starts the SSO process using InitSAMLAuthRequest.  Our IDP https://login.microsoftonline.com/  then posts back but since https://login.microsoftonline.com/  does not have the same as IP as the user, the load balancer sometimes sends the response to a box that did NOT initiate the request and we get an error: Possible replay attack occurred as there is no login/logout information associated with this request.I can catch the error but there is not much else that I can do because now the load balancer will keep the user on box 1 and https://login.microsoftonline.com/ on box 2 so no way to redirect to another server. Any ideas?Thanks,Gabriel 

I have a fresh Windows Server 2022 Std server setup.  When installing ColdFusion 2021 using the latest installer I'm not shown the option to configure IIS websites.  I realize I can probably set it up manually with WSCONFIG, but I'm concerned this indicates something else is wrong.

Hi,We are running CF2021 on update 5 and when I try to create a new CF instance and check the box to "create Windows Service"  it says [step 1 of 2] Creating new CF Instance... Done[step 2 of 2] Creating the CF runtime, this may take a few minutes...Doneand I DO see a new folder under the root for the new instance, but it did NOT create the windows service and when I try to click to go the CF admin to the instance we just created it says "This site can’t be reached 127.0.0.1 refused to connect."  The new instance is using port 8500 because our 2 existing instances are using non-standard port #'s leaving 8500 available. I checked logs but am not finding anything. Thanks,Gabe

I am trying to use Shibboleth 3 as the sp and azure AD as the ipd and I can see that I have successfully implemented based on the Shibboleth transaction log.   2022-12-16 12:35:54|Shibboleth-TRANSACTION.AuthnRequest|||https://sts.windows.net/c04845f0-4224-4637-aed2-9beea8319b5b/||||||urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect|||||| 2022-12-16 12:35:55|Shibboleth-TRANSACTION.Login||_292e2cf9f81890bcdf7ffe1cd147c92f|https://sts.windows.net/c04845f0-4224-4637-aed2-9beea8319b5b/|_ff1422a3-4c91-4255-adec-fa6fd52d2600|urn:oasis:names:tc:SAML:2.0:ac:classes:Password|2022-12-16T07:00:19|authnmethodsreferences(2),displayname(1),emailaddress(1),givenname(1),groups(1),identityprovider(1),objectidentifier(1),surname(1),tenantid(1)|davisg1@XXXXX.com|urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST||urn:oasis:names:tc:SAML:2.0:status:Success|||Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.46|167.24