ColdFusion Language

10K

Solutions

3K

Contributors

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

Share tech news, updates, or what's on your mind.

Sign up to Post

On a local production server (Windows Server 2012), we have installed ColdFusion 2016. All our. CFM run smoothly.

In a .CFM we are using Jquery’s data table plugin (https://datatables.net/)

When we run the .CFM on port 8500 the .CFM runs without a problem. Datatables are being displayed as they should.( http://server1:8500/myCFM.cfm)

However, when we run the same .CFM without the 8500 port (http://server1/myCFM.cfm), the data tables are displayed as text.

How can I get the http://server1/myCFM.cfm to display the plugin data table properly ?
0
Free Tool: Path Explorer
LVL 11
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

I have a searchable database producing a list of records that matches the criteria the user inputted. How can I turn the results of a specific field red if a dupe is detected?

Database Fields:
Serial     MFGNo

Logic: If Serial & MFGNo match with another record display red text.
0
I'm running SQL Server 2012.. .wondering if anyone has seen any procedures of functions for doing Monte Carlo simulations on financial data such as the stock markets.

Seems there may be a function in 2016, but we're not there yet.

Anyone have experience in this area?
Thank you!

(I'm also using Coldfusion if there is something there too)
0
ColdFusion cfpdf Thumbnail numbering is incorrect

I am using the cfpdf function in ColdFusion to create a document packet, i.e. merging a range of documents into one PDF file. The merge works correctly and the thumbnail images correctly link to their respective pages. However, the page numbers shown underneath the thumbnail images are incorrect. At some point in the process, the numbering is restarted as can be seen in the image below:

Thumbnail Images Renumbering Screenshot
This issue only occurs when the cfpdf function is given a directory to work with, not when the files are specified individually. Due to the potentially large number of files which may be processed, specifying the files individually would be impractical.

The version of ColdFusion I am using is 11.

Has anyone else here experienced this issue or has any remedial suggestions?

Thank you in advance.

The code I am using is:

    <cfpdf action="merge" 
    	directory="C:\temp" 
    	destination="Packet.pdf"
    	order="name" 
    	ascending="yes"
    	overwrite="yes"
     	keepbookmark="yes">

Open in new window

0
Hi

We have a computer with Coldfusion on running website on a localhost. I tried to add a new website but by doing this I now cant connect to any local website.

I've clearly done something wrong but I dont know how to fix it.

Can anyone guide me into a repair

Thanks
Mark
0
Hello Experts,

I am trying to install the CF updates and once I did the CF Admin is not accessible and is giving me 500 error and like to see where to start finding the issue.

I do have "detailed error message" is checked or selected on my IIS and my CFIDE folder exists as virtual directory.

Thanks and appreciate your response.
0
I need help coming up with the logic.

I have 2 classess that been purchased on the payment plan. (the payment plan options are: 4,6 ,9 payments plan).

Let say that course 1 was purchased on 4 payment plan option. The course is consists of 1 theoretical part and 7 practical .

When payment 1 is made no practical parts are released,
when payment 2 is posted 2 practical parts get open up
when payment 3 is posted 2 more practical parts open up
when payment 4 is posted 3 more  practical parts open up

Let say that course 2 was purchased on 4 payment plan option. The course is consists of 1 theoretical part and 3 practical .

When payment 1 is made no practical parts are released,
when payment 2 is posted 1 practical parts get open up
when payment 3 is posted 1 more practical parts open up
when payment 4 is posted 1 more  practical parts open up

Let say that course 3 was purchased on 6 payment plan option. The course is consists of 1 theoretical part and 7 practical .

When payment 1 is made no practical parts are released,
when payment 2 is posted 1 practical parts get open up
when payment 3 is posted 1 more practical parts open up
when payment 4 is posted 1 more  practical parts open up
when payment 5 is posted 2 more  practical parts open up
when payment 6  is posted 2 more  practical parts open up


and so on
0
CFGRID runs into JSON Parse error while fetching data. However, sometimes 20K records come back in the grid while at other times, the error would display for 700 records.
0
In a.cfm I have:
<CFSET VerObj = New cfcomponents.VerFold.Ver_Users()>
<CFSET VerObj.Functiion_1(userid)>

In the next few template, c.cfm, I need to call a different function within Ver_Users.cfc I can do the same thing:
<CFSET VerObj = New cfcomponents.VerFold.Ver_Users()>
<CFSET VerObj.Function_2(userid)>

If I need to call the same cfc again from yet another template down the road and I keep doing this I think it is very awkward and repetitive? the purpose of using .cfc is so that I can reuse or call the functions by just doing:

<CFSET VerObj,Function_1()> or
<CFSET VerObj,Function_2()>

from anywhere without keep instantiating the cfc, am I correct? is there any example on how I can accomplish This?
0
I am trying to send text message througth Coldfusion to a people phones and I am suing cfmail tag,. The text is going fine. The question is Is there a way to send a text message as a notification so it stays on the phone as a notofication . Without person needed to go to their messages and check for incoming messages
0
How to Use the Help Bell
LVL 11
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

I am trying to integrate my coldfusion pages into  a 'responsive'  navigational bar (eg bootstrap template from W3schools). Below is the result of my efforts in trying to use one of these templates.   The  page code I created is below and also a link to the server so you can see the result.

The result suggests that the template I am using does not fully support coldfusion OR I am not using the correct approach in building in the coldfusion pointers to the nav template.

I am asking the following questions

-  Am I doing something stupid in the example I have included - if so, can you give me a pointer as to what the solution is
-  What are your recommendations for building a responsive Nav bar which will support coldfusion.


Many thanks,

james





<title>Untitled Document</title>
<meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
</head>

<body>
<div class="container background">
  <div class="row">

    <h1>ABAC INSCRIPTION 2019</h1>
<nav class="navbar navbar-inverse">
    <div class="container-fluid ">
      <ul class="nav navbar-nav">
        
        <li><a href="#tab2" data-toggle="tab">Programme 

Open in new window

0
I have a bootstrap login popup. Upon login into the system throught the bootstrap popup I need to redirtect the client to either myAccount page or myCart page.

		$('#login-form').bootstrapValidator({
			message: 'This value is required',
			submitButton: '$login-form button[type="submit"]',
			live: 'enabled',
			
        	
        	 feedbackIcons: {
	            valid: 'glyphicon glyphicon-ok',
	            invalid: 'glyphicon glyphicon-remove',
	            validating: 'glyphicon glyphicon-refresh'
	        },
	        
	        fields: {

            username: {
            	group: 'col-sm-2',
                message: 'The username is not valid',
                validators: {
                    notEmpty: {
                        message: 'The username is required and can\'t be empty'
                    },
                    stringLength: {
                        min: 2,
                        max: 30,
                        message: 'The username must be more than 2 and less than 30 characters long'
                    }
                   
                }
            },

            loginPassword: {
            	group: 'col-sm-2',
                validators: {
                    notEmpty: {
                        message: 'The password is required and can\'t be empty'
                    }
                   
                }
            }
            }
        }).on('success.form.bv', function(e) {
     // alert(100)
        // Prevent form 

Open in new window

0
Has anyone implemented SAML 2 using Coldfusion?

We would be the service provider and the identity provider for a single sign-on (SSO).

Seeking any sample code, CFC or anything to help jump start the project!

Thanks
0
Hi

Using ColdFusion, what is the easiest way to find links like the one below in a web page, and removing the tag so its no longer a link.

The link text, in this case "top executives" needs to stay.  Just don't want it to be a clickable link.

The key here is that all these links will have both the "XYZ" folder and the ".htm" extension, which makes them unique on the page.

I am slightly familiar with regex, but not good enough to do this on my own.

<a href="/XYZ/management/top-executives.htm"><u>top executives</u></a>

Thx

Michael
0
Looking for the easier way to identify  users of  a specific COLD FUSION  website on IIS server
0
Just taking a survey of other developers for best practices in maintaining your search filters and order-by while paging through multiple pages of search results.

Typical scenario.. user enters a few search filters and presses search.   Say, 500 results and showing 25 records per page.  The user changes the display order and clicks through to page 2, page 3, etc.  

What approach are people using to maintain the where-clause (search filters) and the order by so that each page, the same results are shown, but a different page.

Store SQL where clause in session variable?
Save filter criteria to the database?
Save search results to a temporary table and page through them?
Put search fields and order-by fields inside the search form and resubmit them each time?

Pros and cons for all approaches.
Just curious to change/improve my method.
0
My form has checkboxes with user roles, and a select box with users. I need a select box to repopulate based on the checkbox value(s) when clicked. The checkboxes allow selection of either "all" (in which case the select options need not change) OR any combination of "cm", "adv", "cd" values. Once the checkbox(es) get clicked, the select box should repopulate dynamically (all this before form gets submitted).

<cfquery datasource="datasourceName" name="qry_staff">
    SELECT userID, lastname + ', ' + firstname AS staffName
    FROM   userTable
    WHERE  role IN('cm','adv','cd')
    </cfquery>

<form>
<input type="checkbox" name="assignedRole" id="checkedAll" value="all">All<BR>
<input type="checkbox" name="assignedRole" id="assignedRole" value="cm" class="checkSingle">Case managers<BR>
<input type="checkbox" name="assignedRole" id="assignedRole" value="adv" class="checkSingle">Advisors<BR>
<input type="checkbox" name="assignedRole" id="assignedRole" value="cd" class="checkSingle">Career developers

<select name="staff>
<cfloop query="qry_staff" multiple="multiple">
<cfoutput>
<option value="#qry_staff.userID#">#qry_staff.staffName#</option>
</cfoutput>
</cfloop>
</select>
<input type="submit">
</form>

The entire page must not reload every time a user changes text box selection(s). I haven't yet been able to find a suitable solution. I'm jquery knowledgeable, but not so much Ajax. What I've been able to find makes me think Ajax would really be the way…
0
I have a report that works with a regex and validates well enough w/ the regex. The client is asking to force the date field to be all caps though. I can add the style -  style="text-transform:uppercase" - to force this but when I do it throws an error. Anyone have any idea why this would happen? code below:
<cfinput type="text" 
                                          name="period" 
                                          validate="regex"
                                          pattern="^(JAN|FEB|MAR|APR|JUN|JUL|AUG|SEP|OCT|NOV|DEC)-(19|20)[0-9]{2}$" 
                                          message="Please enter the Accounting Period in the correct format, i.e. MON-YYYY." 
                                          required="true"
                                          id="period"
                                          class="Headline12DrkBlu" 
                                          size="10" 
                                          maxlength="8"
                                          default="#period#">

 But if you add the style to force the all caps it errors out: 

            <cfinput type="text" 
                                          style="text-transform:uppercase"
                                          name="period" 
                                          validate="regex"
                                          pattern="^(JAN|FEB|MAR|APR|JUN|JUL|AUG|SEP|OCT|NOV|DEC)-(19|20)[0-9]{2}$" 
                                          

Open in new window

0
I've wrapped each argument using val() per an earlier suggestion. This is eliminating the value cannot be converted to a number error but now the data isn't being pulled. Just an empty return.

I changed this:
<cfset countttl = #invcounts.15Count# + #invcounts.1530C# + #invcounts.30plusC#>

Open in new window



to this:

<cfset countttl = val(invcounts.15Count) + val(invcounts.1530C) + val(invcounts.30plusC)>
<cfset dollarttl = val(invcounts.less15days) + val(invcounts.15to30Days) + val(invcounts.30plusDays)>

Open in new window


I'm using a cfc file and one of the queries returning no data is:

<cfquery name="invCounts" datasource="#dsn#"  >
select /*+ NO_USE_HASH(T,F) */ sum(CASE WHEN P.ACCOUNTING_DATE between i.terms_date and i.terms_date + 15 THEN i.invoice_amount 
                                        ELSE 0 END) "less15days", 
       sum(CASE WHEN P.ACCOUNTING_DATE between i.terms_date and i.terms_date + 15 THEN 1 
                ELSE 0 END) "15Count", 
       sum(CASE WHEN P.ACCOUNTING_DATE between i.terms_date + 16 and nvl(F.NEW_DUE_DATE, F.ORG_DUE_DATE) THEN i.invoice_amount 
                ELSE 0 END) "15to30days", 
       sum(CASE WHEN P.ACCOUNTING_DATE between i.terms_date + 16 and nvl(F.NEW_DUE_DATE, F.ORG_DUE_DATE) THEN 1 
                ELSE 0 END) "1530C", 
       sum(CASE WHEN P.ACCOUNTING_DATE > nvl(F.NEW_DUE_DATE, F.ORG_DUE_DATE) THEN i.invoice_amount 
                ELSE 0 END) "30plusdays", 
       sum(CASE WHEN P.accounting_date > 

Open in new window

0
Keep up with what's happening at Experts Exchange!
LVL 11
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

I thought I had fixed the situation w/ the "The value " cannot be converted to a number." However its still showing up. I set up the parameter:

<cfparam name="form.period" default="0">

Open in new window


And the form field as below:

                    <tr>
                      <td class="maintxt12_bold"><span class="style9">Accounting Period:</span></td>
                      <td colspan="3" class="maintxt12_bold">
                       <input type="text" 
                      	 		name="period" 
                      	 		validate="regex"
                      	 		style="text-transform:uppercase"	 	                  	 		
                      	 		pattern="^(JAN|FEB|MAR|APR|JUN|JUL|AUG|SEP|OCT|NOV|DEC)-(19|20)[0-9]{2}$" 
                      	 		message="The value cannot be converted to a number." 
                      	 		required="true"
                      	 		id="period"
                       			class="Headline12DrkBlu" 
                       			size="10" 
                       			maxlength="8"
                       			default="#period#">                     
                        &nbsp;<span class="Arial_Red12Bold">* MON-YYYY</span></td>
                    </tr>

Open in new window


when I pull the style="text-transform:uppercase"             everything works but if I leave that and pull the regex it breaks.

Does anyone see where I may be setting this up wrong?
0
can you run cold fusion in a docker contianer , I dont know if you can even do this , have you done this or have and example that you know works ?

thanks
0
I have two mysql databases on the same mysql server - with identical structures - differing only  in data content.  They each have customer information -  one for year 2016 and the other for year 2017. Objective is to
- list the customers who were active in 2016, but are inactive in 2017...... Lost Customers
- list the customers who are active in 2017 but inactive  in 2016........  New Customers

There are no database  technical problems - permissions etc..   I need help with

     How to manipulate two record sets (2016 and 2017) to create tables of lost and new customers. I am trying a 'lists' approach as you will see from the code attached - idea being to create and  manipulate  lists  from each recordset. I able to create the lists, but not to subtract  them. Printout attached shows lists for 2016 and 2017)

    If the LISTS approach is not the best,  I would ask for advice on alternative

    Many thanks for your help

    James Kane
    =======================================================================================

    PRINTOUT OF  TWO LISTS PLUS  TABLE
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    
    <cfparam name="nom" default="0">
    <cfparam name="ListCommon" default="0">
    <head>
    
    
    <!---record sets for year 18 and 17--->
    <cfquery name="activemembers_18" datasource="office_18">
    SELECT civilites, nom, 
    

    Open in new window

    0
    I need to add a try/catch to stop a database connection when nothing is found for a Cold Fusion report query. I'm trying to determine the best place to place the try/catch to ensure this. Researching has led to using COM.Allaire.ColdFusion.Request.Timeout  as the exception to look for but I'm not sure where to place that and exactly how to format it.

    Also the code below has thrown an error at times stating: The value " cannot be converted to a number referencing this line of code:

    <cfset countttl = #invcounts.15Count# + #invcounts.1530C# + #invcounts.30plusC#>

    Thanks for any help. See code below:

    <cfset #date# = #DateFormat("#Now()#","mmmm dd, yyyy")#>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    <HTML LANG="EN-US">
    <head>
    <title>Payments</title>
    
    <link href="../css/home.css" rel="stylesheet" type="text/css" />
    
    </head>
    
    <table width="94%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><img src="../images/11.jpg" width="600" height="100" alt="banner"></td>
      </tr>
     </table>
     </td>
    </tr>
    </td>
          
    <div id="support" style="position: absolute; visibility: visible; width: 135px; height: 15px; background-color: #FFFFFF; layer-background-color: #FFFFFF; border: 1px none #000000; z-index: 28; left: 622px; top: 116px;" class="links">
    <a href="../index.htm">Home</a>    | <a href="../******.htm" target="_blank">Support</a> </div>
    
    <script>
     var ld=(document.all);
      var ns4=document.layers;
     var 
    

    Open in new window

    0
    I'm working on a report issue in which the report is failing with the this error: The value " cannot be converted to a number.

    The diff of the fix for the report from an earlier issue is below

    from this:

    where t.NAME<>'PROMPT SB NET 30' -- take out small business terms
    

    Open in new window


    to this:

    where t.NAME='PROMPT SB NET 30' -- take out small business terms
    

    Open in new window


    Is anyone familiar w/ this error? I'm continuing to search but I'm confused as to why this would cause an issue by merely changing  the <> value to =

    thanks
    0
    hello, the current CF code causes the browser pop up blocker. I would like a workaround such that either a new window opens or the same browser page opens the new url. I have tried cflocation too but to no avail. Thanks for helping, Clifford

    <cfif IsDefined("form.btnSubmit")>
       <cfif IsDefined("form.departure")>

            <cfset depDate = parsedatetime(form.departure, "dd MMM yy")>
            <cfset arrDate = parsedatetime(form.arrival, "dd MMM yy")>
            <cfset arrString = DateFormat(arrDate,"d.m.yyyy")>
            <cfset nights = DateDiff("d",arrDate,depDate)>
    <SCRIPT LANGUAGE="javascript">

    window.open ('https://xxx/inquiry.aspx?date=<cfoutput>#arrString#</cfoutput>&nights=<cfoutput>#nights#</cfoutput>&rooms=<cfoutput>#form.txtRooms#</cfoutput>&adults=<cfoutput>#form.txtAdults#&child=#form.txtChild#</cfoutput>&promotion=', );
     
     </SCRIPT>
    <!---      <cflocation url="https://xxx/inquiry.aspx?date=<cfoutput>#arrString#</cfoutput>&nights=<cfoutput>#nights#</cfoutput>&rooms=<cfoutput>#form.txtRooms#</cfoutput>&adults=<cfoutput>#form.txtAdults#&child=#form.txtChild#</cfoutput>&promotion=" addtoken="no"> --->
        </cfif>
    <cfelse>
          
          <cfparam name="form.txtAdults" default="2">
          <cfparam name="form.txtRooms" default="1">
          <cfparam name="form.txtChild" default="0">
          <cfparam name="form.txtCode" default="">
    </cfif>
    0

    ColdFusion Language

    10K

    Solutions

    3K

    Contributors

    ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

    Top Experts In
    ColdFusion Language
    <
    Monthly
    >