Questions tagged [coldfusion]

ColdFusion is a server-side rapid application development platform, implementing the dynamic general purpose CFML programming language. Please include CFML version, OS & web server in questions.

0
votes
0answers
3 views

Passing an input from form into Coldfusion Query

Hello I am trying to pass a variable who's value would come from a form input to a Query to retrieve a value and pass back to the form as a hidden value.Very confusing, and I hope I am overthinking ...
1
vote
0answers
11 views

Coldfusion 2018 clustering and session replication not working

Setting up a couple new Coldfusion 2018 servers and will be using clustering for the first time and have run into some problems. I am having trouble with session replication. Basically, session ...
4
votes
0answers
19 views

ColdFusion 2018 with bundled tomcat vs ColdFusion 2018 on Native Tomcat

Legend: Native tomcat CF = CF installed on native tomcat or tomcat which was already installed on your system. Bundled tomcat CF = Default CF installation. I have experience working with bundled ...
2
votes
0answers
28 views

Db2 JDBC Driver EncyptionMethod or AuthenticationMethod

I am trying to connect Db2 database with ColdFusion. I am using IBM Db2 on Cloud and am getting the below error: Connection verification failed for data source: "DatabaseName" java.sql....
1
vote
1answer
34 views

MSSQL Display Vertical Data in Columns

Okay people, I have half solved my problem and I believe I need help solving the other half. I was able to stuff several rows of data from one column (TEAMS) and concatenate into one column, however, ...
0
votes
1answer
26 views

Create single dynamic query to get tables data based on funcion call in Coldfusion

I want to create a dynamic query to get tables data. Using this dynamic query we need to select all columns or needed columns. Need dynamically Joins, where condition also.
0
votes
0answers
25 views

Pagination part missing in email undeliverable options in CF2016 admin

I've working with CF2016. In my local I've tested about send an email. For example I've tested it localhost:8501/testSendMail.cfm. But I could not able to see the pagination options in coldfusion ...
0
votes
2answers
33 views

Passing form input using Coldfusion to external URL

I am trying to pass a form input to an external URL to be used somewhere else and perform a certain task. The issue I am having is actually getting the value and passing it. I either get a LotNumber ...
0
votes
0answers
60 views

Retrieve data based on Date Range

I have the following query that retrieves user info based on User Name, Hospital Name, Process Date and Discharge Date. However, the Process Date and Discharge Date part of the query is not working as ...
-3
votes
3answers
56 views

Cf-script convert query result in structure with the unique key?

I have few functions in my system that should be converted from CFML to CFSCRIPT. While working on this project I run to the situation where my structure outputs more result (a lot of empty rows) than ...
2
votes
1answer
52 views

<cfhttp> to download a remote .csv file in ColdFusion

I'm trying to download a .csv file on a remote server location using ColdFusion (version 2016). I used the cfhttp tag to perform this operation but I keep getting the following error: 401 ...
2
votes
0answers
33 views

Insert a record using AJAX inside a bootstrap modal window

I have a modal window that allows users to dynamically search a site list. It uses ajax to return a list of sites by keystroke. When the list is returned I'd like the user to be able to click on a ...
1
vote
1answer
39 views

How to create temporary link for the new user account?

I created single page app that requires username and password for users authentication. Each account in the system is created by administrators. There is no option for user to click on the link and ...
2
votes
2answers
40 views

Why is my <script> giving me an undefined error even though it is being called?

I'm working on a .cfm file that searches for people within the database. The search form should populate a string of names once I start typing using 'onKeyUp', however it is giving me that my variable ...
1
vote
0answers
53 views

What criteria does isValid( “telephone”, PN ) use to validate phone numbers in ColdFusion?

In ColdFusion, isValid() with a type of "telephone" validates a US phone number. However, it's not just looking at the number of digits. For example: isValid( "telephone", "8002345678" ) // returns ...
0
votes
0answers
41 views

Best way to notify user about application access?

I have application where administrators have to create accounts for the new users. Basically there is no option for random user to create account and access this app. The admin would have to enter ...
2
votes
1answer
46 views

Analysis Paralysis in looping over JSON data to populate select box with optgroup sections

I have Analysis Paralysis and need some input. I can modify the SQL query, the JavaScript, AND/or the CFML controller (all code has been posted below). All I'm looking to do is to populate a select ...
0
votes
2answers
96 views

How to remove duplicate values from Array Coldfusion

How can I remove duplicate values from my array list in Coldfusion. Currently I have the following that displays the reason a user goes to the hospital: <cfset ReasonforVisit = "#HospitalVisits2....
0
votes
0answers
84 views

How to write SQL query for the ColdFusion FindNoCase If condition?

I would like to write this below query as a store proc in SQL. When doing so, I am unable to find out, how to write for one of the condition written in ColdFusion that is: <CFIF FINDNOCASE("...
2
votes
0answers
36 views

Coldfusion - Cant find testbox

I have a coldfusion application that i would like to start writing unit tests for. I found testbox, and think it would be a great testing library to use. I followed the installation instructions, but ...
1
vote
1answer
52 views

Filtering data in cfselect based on another cfselect

In a ColdFusion application I'm working on, the user will see two cfselects, one with a list of regions and one with a list of centers. Each region has it's own set of centers. When the user clicks a ...
0
votes
0answers
39 views

Should I notify user if link has been expired?

I'm creating logic for password recovery. User will submit request by providing their email address. Then email will be sent with more information that includes the link with the url parameter. This ...
1
vote
1answer
58 views

Not able to a https web service in ColdFusion 8

We are trying to add a https web service via CFadmin in ColdFusion 8. We have two ColdFusion applications. One on ColdFusion 2016 and other in ColdFusion 8. The CF8 application consumes few of the ...
1
vote
1answer
57 views

How to create button in the message that is sent in the email?

I have developed feature in my application where users can request password recovery. All they need to do is enter the email address. System will provide the message like this: An email has been sent ...
2
votes
2answers
56 views

How to exclude ID column when dynamically generating <table> from array of arrays with jQuery

I am using jQuery to make an ajax call to get data from a ColdFusion server. The server queries a database table and returns multiple records as a 2D array. The jQuery code then displays the array ...
1
vote
0answers
47 views

CF- Tag timeout

I have a web application coded in Coldfusion 2016. The ColdFusion is written for the front end but i have a Java backend . For one my pages I process the removal of a user from the application. The ...
2
votes
0answers
59 views

Url Encode issue in coldfusion

I am working on a project that I need to pass a string as a url variable. The issue I am haveing is when the strings are being pulled from a database, and contain characters that have to be encoded. ...
-1
votes
0answers
52 views

ColdFusion 11 Update 14 OS Migration [closed]

Currently we have servers running on Coldfusion 11 Update 14 and the windows version is 2008 R2. Our company is planning to migrate from windows 2008 to 2016. Does CF 11 update 14 servers support ...
4
votes
1answer
33 views

lucee 5.x ListEach doesn't seem to be able to access local var scope?

I can't seem to access the local scope within my ListEach: writeDump(local.woCoreID); // outputs expected values // LOOP OVER LIST AND SEPARATE TEXT FROM INTEGERS ListEach(local....
0
votes
1answer
70 views

Access the page if user is not loggedin?

I have login in my new application that checks on each request if user is logged in. If user is not logged in automatically will be redirected to the login page. I have situation where user clicks on ...
-1
votes
1answer
67 views

AJAX call error: Status 400 - the request sent by the client was syntactically incorrect

I am seeming to have some issues with an Ajax call to my ColdFusion server using JQuery. I am using the POST method and am expecting text to be sent to and from the server. The error I am getting is ...
1
vote
0answers
61 views

How to generate temporary link for the password recovery?

I have built a new single page app with the login process. At first I have used a security question to recover a user's password. Same process I used when the administrator sets up a new account. The ...
-1
votes
2answers
40 views

convert a number value to dollar-format to display in proper visible format

trying to do something like dollarFormat in javascript after deducting some value but not getting type like $8,657.00 as this is small task, i do not want to use any libraries for this, but i manged ...
-1
votes
1answer
36 views

div element to coldfusion variable

I have <div id="test"></div> displaying the value, which is great. However, if I view the source code of the html it still shows <div id="test"></div>. How can I convert <...
0
votes
1answer
75 views

How to display Distinct values in cfoutput

I have a query that returns results from the database. It returns duplicate information. I would like to prevent showing the duplicate data. What I mean by duplicate data is that the Admit Date, ...
0
votes
0answers
67 views

Why do I get ColdFusion errors that my components are undefined?

Several times a day, I get error for my application that different components are undefined. I'm baffled by this, because the components ARE defined, and generally make up the core of the application, ...
-1
votes
1answer
65 views

looping over the array of structs and putting values in xml

I have a shopping cart with item values stored in an array of structures. Those values are passed into the xml. I want to loop over the xml. I know how to loop over structures and arrays, but how do I ...
0
votes
0answers
90 views

How to organize single page app navigation with JQuery and ColdFusion 2016?

I have started my new single page application. So far I was able to create login/authentication process and build the templates for the Home.cfm page. While looking around the web I see that JQuery ...
1
vote
0answers
59 views

cfdocument processing is very slow for text with RTL (Right To Left) direction

In my application an event gateway is used to generate PDF files (more than 100 000) for Arabic texts and English text. During this process we noticed that it is taking very long time to generate ...
0
votes
0answers
61 views

Lucee S3 NullPointerException with no further error info

We are using Lucee and S3 and in our development and testing we had no problems. We have now moved this code live and are getting a lot of errors.That look like this : In the application.cfc in ...
3
votes
1answer
71 views

How to compare user inputs with 2 different tables

I have a form which takes in the values of First Name, Last Name and DOB. I have two tables: TableA and TableB. Each table may contain information of the person name that is entered in the form. What ...
3
votes
2answers
70 views

Lock user record and prevent editing?

while working on my new application customers came back to me with specific requirement. They would like to prevent multiple users editing same record at the same time. For example if User 1 login the ...
4
votes
1answer
37 views

Check XML for the existence of a specific key

In the following XML I want to see if there is element called "errors" <cfxml variable="sXML"> <?xml version="1.0" encoding="UTF-8"?> <createTransactionResponse> <messages>...
3
votes
1answer
70 views

Variable name starting with @ causes error: Invalid token @ found on line X at column Y

I am trying to format a ColdFusion page with data from the National Weather Service API (NOAA). Using the following ColdFusion code I am able to dump the data. <cfhttp url="https://api.weather....
3
votes
1answer
40 views

Trying to convert PHP hash_hmac with multiple XOR components to coldfusion

I have been given the unenviable task of converting an old set of PHP pages to ColdFusion. My PHP knowledge is not that great, and I'm having a hard time figuring out how to replicate the following ...
1
vote
2answers
127 views

ColdFusion sql issue

Ran a security scan against an URL and received the report below: The vulnerability affects /rolecall.cfm , bbb_id This is the rolecall.cfm code: <cfscript> if (isDefined("url") and ...
0
votes
0answers
48 views

Set 32 digit number to variable and use in ColdFusion [duplicate]

I am new to coldfusion. How can I set 32 digit number to variable and use for further calculation. I tried as <cfscript> randStart = 1; randEnd=99999999999999999999999999999999; ranValue = #...
1
vote
0answers
38 views

Adding onto an existing ColdFusion 2016 ORM application

I am working on adding to a ColdFusion 2016 application with ORM. The application pulls up and doesn't give any type of errors prior to adding the second table code (TableTwo). As soon as the second ...
1
vote
1answer
65 views

ColdFusion: HTML <Button> tag sets FORM scope value differently in IE 11 vs other browsers

In the following code sample... <CFOUTPUT> <cfdump var=#FORM#> <FORM NAME="LAYOUTFORM" ACTION="" id="TEST_FORM" METHOD=POST> <BR> <BR> <BR> ...
0
votes
0answers
44 views

ORMExecuteQuery returns query instead of entities

Is it possible to have ORMExecuteQuery returns a query result instead of entities?