ColdFusion

I'm trying to find out what Coldfusion actually does when you instantiate or invoke a web service as a coldfusion object, either with the cfobject or cfinvoke tags.  Let's say I have the following code:<cfinvoke webservice="https://#application.webServiceURL#/getArticle.cfc?wsdl" method="getArticle" returnvariable="myArticle" timeout="10"> <cfinvokeargument name="Article" value="3"> </cfinvoke> What's actually happening behind the scenes here?   Is Coldfusion making an HTTPS request?  Is it a GET or a POST request?  Or is something else I don't know about?  What is the functional difference between that syntax versus something like this:<cfhttp url="https://#application.webServiceURL#/getArticle.cfc?method=getArticle&Article=3" method="get" result="resultJSON" timeout="10"> <cfhttpparam type="header" name="Accept" value="application/json" /> </cfhttp> <cfset myArticle= DeSerializeJSON(resultJSON.FileContent

I'm following the example usage as described here https://helpx.adobe.com/coldfusion/using/docker-images-coldfusion.html to create datasources using my setupColdFusion.cfm. I can create datasources just fine but apparently the default datasoruces cfartgallery, cfbookclub, cfcodeexplorer and cfdocexamples are not yet created when the setupColdFusion.cfm is run. Thus, statements like:  datasource.deleteDatasource("cfartgallery");in my setupColdFusion.cfm will result in errors like:  coldfusion.runtime.UndefinedElementException: Element cfartgallery is undefined in a Java object of type class coldfusion.server.ConfigMap.What is the suggested way to delete unwanted datasources at setup?

I have a fixed numeric list, let's say that's a list of numbers from 1 to 50 myfixedlist=1,2,3,4,5 etc.etc I then have another list which contains some of the values in the list above variablelist = 10,12,20,50 I need to create another list that gives me all of the values in myfixedlist that is not in variablelist Does anybody know of an efficient way to create this list in one swoop, using a CF command that doesn't involve a loop and lots of CFIF's

Hello, all, Just poking my head in to see if anyone else has registered for CFD2020?  I'm looking forward to some of the webinars.  Charlie Arehart, Dave Watts, and Pete Frietag, to name a few.  I don't think I'll have time for every webinar, but I'm going to make the best of it, as permitted. V/r, ^ _ ^

We are planning to upgrade to Coldfusion 2018. Is this CF2018 compatible with MS Windows OS 2016?

Hello,We have a server that was running fine...the CF service running as Local System. We renamed the server. Now, with the service running as Local System, we get 500 errors. There is nothing in the CF Error Log. The IIS log looks like this (ip addresses obfuscated):xxx.xxx.xxx.xxx, -, 5/15/2020, 9:52:37, W3SVC1, IPTest, xxx.xxx.xxx.xxx, 400, 122, 86238, 500, 0, GET, /, -, When I run the service under my network account (which is an admin on the machine), everything works great. I added another network account to the machine as an admin, started the service logged on as that user, and get the 500 errors again. Any thoughts? Thank you!Judi

Hi Team,We have our coldfusion application server running standalone in windows server. Now, we are planning to perform containerization. In this approach, we are trying to create windows image with coldfusion.So, can you please confirm whether windows based docker image for coldfusion is available.If available, do we need to get a seperate license for the same. Thanks. 

Hi,Our site was tested by one of the security scanner companies and found known vulnerability. It sounds as "Information Leakage is an application weakness where an application reveals sensitive data".  I need help to update server settings to hide error details, not do display server technlogy details. They run curl command as:    C:\curl\bin\curl.exe -i -s -k -X "GET" -H "Accept: application/json,text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5" -H "Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7" -H "Accept-Language: en-us,en;q=0.5" -H "Host: whs'check" -H "User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:67.0) Gecko/20100101 Firefox/67.0 Software Security Group" "https://www.[mysite.com]/"    The output is resulting in java stack error as:    <!doctype html><html lang="en"><head><title>HTTP Status 400 – Bad Request</title><

So I am trying to convert my JSON into a cfquery object to use it in my application.Here is what my JSON looks like. Its a structure containing an array of structures.  But when I look at other CF posts on this topic I see the JSON data looks like this.A Structure of Arrays. Which there is a lot of documentation on how to work within cf.  QUESTION: How do I get my deserialized JSON file to be a Structure of Arrays instead of a structure containing an array of structures

Hello, Just wondering how people would handle the following problem. So we have export functionality which is called via a JavaScript post. Now this export could take a couple of minutes to generate so I'd like to explain that to the user and let them carry on to other pages and eventually notify them when their download is ready. My immediate thoughts were to have a scheduled task running which would be checking a table every couple of minutes to see if there was any exports generated in the previous 2 minutes for the logged in user and if so could Let them know. Problem is I don't want a scheduled task running away when there may be no exports to be downloaded. It just seems like unnecessary processing. Anyone any ideas on how to accomplish this in the easiest and most elegant manner. Thanks

Hi there,I have a simple xlsx with 5 columns and 6 rows created in excel 2010.      1234514345123451234512345 When I use <cfspreadsheet action="read" src="#path##cffile.serverFile#"columns="1-2" rows="2-6"query = "getProductionDAta" sheetname = #worksheet#> and do a cfdump, I get this: query  col_1col_2col_3col_4col_5112[empty string][empty string][empty string]214[empty string][empty string][empty string]312[empty string][empty string][empty string]412[empty string][empty string][empty string]512[empty string][empty string][empty string] Looks like it is reading the columns that I don't want and just clearing them.  Normally, that is fine as I know how many columns I am requesting and can ignore the extra columns.  But in production, I am trying to extract a few hundred columns from a large spreadsheet and there are around 1000 blank columns in the query result. Just wondering whether this is normal behav

I'm looking for a tutorial for converting my older Access databases (running on CF9) to MySQL so I can upgrade to the latest CF.  Is there one around?

Hi, Is there a reliable function to convert a specific date (with hours set as 00:00:00) to UTC time in UNIX epoch format? I have some success, but many of the epoch times are wrong. I need a date in UTC that is always set to midnight. The time is the issue. I've used a number of functions mentioned on the forums and none work all of the time. So if a person enters a date of 22/9/1970 (dd/mm/yyyy) I need a epoch date in milliseconds that is exactly for 22/9/1970 00:00:00. This is what I have so far: <cfset tzinfo = GetTimeZoneInfo()><cfset offset_seconds = tzinfo.utcTotalOffset><cfset startDateEpoch = CreateDateTime(1970, 1, 1, 0, 0, 0)><cfset dobDate = CreateDateTime(Year(MY_DATE), Month(MY_DATE), DAY(MY_DATE), 0, 0, 0)><cfset DATE_EPOCH = (DateDiff("s", startDateEpoch, dobDate) + offset_seconds) & "000">   Problem is, the hour is sometimes 23:00:00, not 00:00:00, or 01:00:00 - always an hour around midnight. I am trying

Hello community, hope you are all doing well and safe.I am running a script to insert all email information within a particular folder to a Database table.It is working fine but it is starting form the oldest ones instead of the most recent ones.This is my cfimap block: I am doing 4 emails at the time otherwise the process is slow.Is there a way to revert the "get all" order, getting the most recenct first? Thank you in advance!

Hi,Can anyone please tell me if ColdFusion2018 and REDIS (on Azure, or even another REDIS service) are currently viable?Thanks,Mark

So now I have been able to get DeserializeJSON JSON data from a google API like thisLet me know if a larger picture of this will help. From this code<cfhttp url="https://storage.googleapis.com/storage/v1/b/myabc/o?prefix=products/3D/">  <cfset cfData=DeserializeJSON(cfhttp.FileContent)> The products parameter changes and will yield different resultsI have never worked with JSON data before like this.Questions:What CF code can I write to determine if I have any records from the API?What CF code can I write to get a record count of the JSON results?What CF code can I write to extract certain fields from the JSON structure?For example, I need to get the all the results from the id fields in a list.

how to create carousel slider in cold fusion? actually this carousel slider is in bootstrap. i wants  to create it coldfusion.

necesita declarar cfobject en Application.cfc, pero me da el siguiente error:en Application.cfc defino de la siguiente forma:<cfobject component="geti_des.proc.dominioAD" name="dominioAD">

Hello , We have been facing certain issues in our application post upgrade from ColdFusion 2016 Update 11 to Update 12 onwards till Update 15. We are now at ColdFusion 2016 Update 15 and still facing the same issue. The application is not able to identify the varibables inside the nested structure in the  <CFIF> <CFELSE> tag. The problem only comes if we have a <CFELSE> tag. If we remove the <CFELSE> tag, the issue goes away. This is hampering all of our application.If you see the code below- <CFOUTPUT> <cfset strAdminName = 'testName'/> <cfif strAdminName NEQ ''> #objML.writePrompt('msgContactAdminWithContact', '?AdminName?', stcMLRej, {AdminName=strAdminName})# <cfelse> #objML.writePrompt('msgContactAdminNoContact', 'If you have a question regarding your username and password, contact your system administrator.', stcMLRej)# </cfif> </CFOUTPUT>*writePrompt is a function. Error:- Variable STRADMIN

I am taking over for someone that coded a page a long time ago and is no longer at our office.  I am having a heck of a time figuring out why i keep getting this error.  This seemed to work yesterday and not sure what changes were made but when i go to submit this page i get this error and can't figure it out.  any help would be greatly appreciated it.<!--- Get the info needed ---><cfquery name="Requestor" datasource="" username="" password="">SELECT *FROM v_employeeinformationORDER BY v_employeeinformation.Last_Name</cfquery><!---<cfquery name="Recordset1" datasource="" username="" password="">SELECT * FROM v_helpdesk</cfquery>---><cfquery name="OITAssigned" datasource="" username="" password="">SELECT *FROM v_employeeinformationWHERE v_employeeinformation.Department LIKE 'Information Technology'ORDER BY v_employeeinformation.Last_Name</cfquery><cfquery name="OITStaff" datasource="" username="" password="">SELECT *FR

I have insalled server version on CF 2018 on Windows Server 2016. On Administrator login page I recieve 2 errors.1) Please enable Javascript to use ColdFusion Administrator.2.) Invalid Password. Please try againThe password I entered is correct. I have reinstalled thrice, but I keep getting the same issue.I added the administrator page to Trusted sites and Enabled "Activ Scripting". Still no success.

I am attempting to get a query that looks at an entire month ahead. So for example.  We are sending out card expiry emails in this Month (May) but I want to query all those that have a subscription end date in June. I have used:on or after: AddMonths(ToDate( GetDate()) , 1)AND before: AddMonths(ToDate( GetDate()) , 2) But I think this will return June 4-July4.  All I want it June 1-June 30.  What is the correct SQ statement to use?

I have a site now where we use cfdirectory tag to query to get the directory contents.In the directories are images; like thisimage1.jpgimage2.jpgimage3.jpgThen we use this info to display these images on the page. Anywhere from one to 10 images in each directory.Now we are moving our images to Google Cloud and cannot use the cfdirectory the way we currently do.Has anyone used the Google API to query/list directories on the Google cloud and pushed the results back to a cf site?Once I can get that info from google I can figure how to output images.Anybody?

I have been using iText within CF for several years to insert images into existing PDF files, etc. My background is not in coding but I have managed to get my way through it with help from online communities and posts.I'd like to dynamically create a custom background color (user defined) to existing PDF documents. My thought is to add colored rectangles to an existing PDF file to accomplish this. I have searched for a way to add a rectangle through iText or by using a CF tag, but am having trouble figuring it out.I would prefer to use iText but a CF tag would work fine as well. Any help would be appreciated.

Tried posting earlier, but looks like my post wasn't successful so here goes again.. We have an old legacy application that we migrated from CF11 to CF2018. On migration I had noticed that pdfs were taking significant time to generate compared to the previous site/server version. Looking further I found Charlie's post regarding the localURL attribute setting. So trying this I have encountered some weird behaviour in that images/styles still don't load. I ran the test code below:  <cfdocument name="pdfContent" saveAsName="test.pdf" format="pdf" localurl="yes"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td align="left"> <font face="Arial, Helvetica, sans-serif" size="+2"><strong>Testing CFDOCUMENT </strong></font> </td> </tr> <tr><td colspan="6"> using back slashes e.g. img src="images\googleLogo.png" <img src="