ColdFusion

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

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