Questions

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="

after purchasing the coldfusion on my phone , its says I can download it, but when I login on my windows laptop coldfusion doesnt show as one of my products, but on the iphone it shows fine to down loadso where is the coldfusion on my windows deviceyou sure can't run it on my iphone? order number is ADB106929405 regards 

Hi I am just starting to work with APIs.  I am having issues with the CORS error below [edited websites].  Access to XMLHttpRequest at 'https://api.test.xxx.com/access' from origin 'https://yyy.zzz.com' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. The company we are working with does not want to add the Access-Control-Allow-Origin header.  What is the best way to proceed in ColdFusion? Any suggestions are greatly appreciated.ThanksNicole 

Our application just is upgrating to ColdFusion 2018. We have a store procedureCREATE PROC sp_cs_set_emp_qual @pbn_SRI varchar(15),@84805_ID decimal(18,0),@availability_status varchar(15) = null,@84805_lname varchar(50),@84805_fname varchar(50),@84805_init varchar(50),@9301045_qual varchar(250),@8668307_emp_flag int,@added_emp_ID decimal(18,0) OUTPUT AS   BEGIN        INSERT INTO employee                                         (   pbn_SRI,                                            availability_status,   &nbs

How do I upload a file using AJAX?<form name="pic" id="pic" action="" method="post" enctype="multipart/form-data"><input class="redField" type="file" name="file_upload" value="" size="20" maxlength="50" onBlur="sendPhotoNew(this.form)"></form> <script>function sendPhotoNew(form){          var file=form.file_upload.value;          var e= new (images);          e.setForm('pic');          e.setHTTPMethod("POST");         var picNLink=e.photos_upload(file);          photo_new.innerHTML=picNLink[0];          $('#photo_new').show();} </script> I know how do this using conventional forms. I am getting the error Invalid content type: application/x-www-form-urlencoded.The files upload action requires forms to use enctype=""multipart/form-data"". The specific sequence o

We've all seen the screen on Googlemaps.  And the likes of VR/BO and Air/bnb where they:Place a list on the left, a map on the right and as you scroll down the list the pin on the map changes.  So I used CFMAP and CFMAPITEM and all went well.  Searched it and Adobe confirmed that there is no way using mouseover, Javascript and then change the pin color.   So my question is, has anyone done it using CF (a workaround) or done it withOUT CF - using Google Maps API directly, and provide a simple instructions to this JS challenged human? Thanks! 

Anyone had any luck get email attachments using the CFEXCHANGEMAIL tags?We are able to establish a connection to Office365 and can get the mail.  But, when a message indicates it has an attachment and we try to get it, the whole operation crashes with only the word: 'Failure'  displayed on the page. In this particular case there are 3 messages.  Just one has an attachment. We are using CF2018.  <!--- This works fine ---> <cfexchangeconnection action="open" username="ouremail@ourdomain.com" password="XXXXXXX" server="outlook.office365.com" protocol="https" serverversion="2016" connection="tech_cxn" formBasedAuthentication="true" formBasedAuthenticationURL="https://outlook.office365.com/owa/auth/owaauth.dll"> <!--- This works fine, too ---> <cfexchangemail action = "get" name = "FindMail" connection = "tech_cxn"> <cfexchangefilter name="Folder" value="Inbox"> &l

is it possible useing cfinclude tag in the cfc component?if possible. is there any problems?  speed, memory...etc.. Thank you 

Has anyone experienced "The requested scope session has not been enabled" error after installing Update 9 and trying to access CF Administrator? The only fix so far was to revert to Update 8. Also, I have enabled Secure Cookie under Memory Variables. As a result, I no longer could login to CF Administrator through non-secure HTTP default port 8500.I had to enable HTTPS/TLS protocol in Coldfusion's Tomcat server.xml file, add HTTPS port 8443 in order to login securely to CF Adminitsrator. Is this a bug? Coldfusion 2016 works fine via HTTP with the same settings enabled.

hi guys, im working on a project which send a file to client side through api. i use the PUT method to send the file but getting 400 bad request. after checking the log, found that all my file content has been endoded. but when i download the file, its content still look ok.may i know how to send the file and make sure the file content is decoded? Below is part of my code.<cfhttp url="#requestUrl#" method="PUT" result="res" throwonerror="yes"> <cfhttpparam name="Authorization" type="header" value="Basic #token#"> <cfhttpparam name="Content-Type" type="header" value="multipart/form-data"> <cfhttpparam type="file" name="document" file="#filename#" > </cfhttp>

Hello,   We are using Oracle Database 12c and ColdFusion 2018 Enterprise edition,   The Excel to HTML file which is in ColdFusion is missing, Is there any way I can copy over so that the Excel file can get properly formatted and printed ? ThanksIQ   

We are devoloping app for android and iosdispalying images in android is perfect, while in ios is faint. how to rectify this issue 

Hello, Why is CF forum missing announcement and or feature content for CF2018 update 9 and CF2016 update 15? Will future CF updates not get a mention here? https://coldfusion.adobe.com/2020/04/coldfusion-2018-release-update-9-coldfusion-2016-release-update-15-released/ Thanks, Carl.   

Trying to upgrade the server config to teh new structure for the connectors , uncommented works but tring to get to the one commented out, doing this with a cfusion and cfusion1 on the same server, also have the commented configuration working on a stright Tomcat 9.9.22 instance:<Connector SSLEnabled="true" ciphers="TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256, TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA, TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384, TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA, TLS_ECDHE_RSA_WITH_RC4_128_SHA, TLS_RSA_WITH_AES_128_CBC_SHA256, TLS_RSA_WITH_AES_128_CBC_SHA,TLS_RSA_WITH_AES_256_CBC_SHA256, TLS_RSA_WITH_AES_256_CBC_SHA,SSL_RSA_WITH_RC4_128_SHA" clientAuth="false" keystoreFile="D:\web\Certificates\eagnmnss58b.usps.gov.jks" keystorePass="password" maxThreads="150" port="8550" protocol="HTTP/1.1" scheme="https" secure="true" sslEnabledProtocols="TLSv1,TLSv1.1,TLSv1.2" sslProtocol="TLS"/><Connector connectionTimeout="60000" maxThreads="500" packetSize="65535" port="8018" protocol="AJ

We've been having issues with our CF2016 setup (prod environment) and I want to try and replicate it on my local. Is there a way I can export the prod settings and then import it to my local instance? perhaps it's as easy as copy 1 file from server to the other? Thanks!

Once a month Quickbooks generates a SQL table of approximately 1000 transactions to process on Stripe. I'm looking for suggestions on how to best process this many transactions instead of cfloop. My concerns with cfloop are what if it crashes where do I restart and timeouts. Once they're processed the record is deleted.  Here are my thoughts: ProcessPayment CFM page:Select Top1 from ToBeProcessed<cfif if ToBeProcessed.recordcount GT 1><!--- Process Stripe Transaction --->Delete from ToBeProcessed transaction x<cflocation processpayment.cfm></cfif> This would loop over the table one transaction at a time, process it, delete it, then start again.Thoughts? Is there a better way? Gary