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

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
Free Tool: ZipGrep
LVL 10
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

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
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
    I am looking for idea. I need to grab locations , some of the lcoations have the same name but different locationID.

    I need to create a location drop down with a unique locations. And then do the search by these locations. The question  is if I do make a drop down of unique locations thne in my search I will be searching by name instead of locationID
    0
    Hello,

    I am having trouble reading an XML response.  I am not sure if I can explain it well.  I am using XMLParse on the filecontent.

    When I do this directly from the response from the web service I am using, it seems that I am getting just one chunk of XMLText instead of each piece of information with its node label.

    <cfdump var="#xmlparse(httpResponse.filecontent)#">

    If I show the filecontent on the screen, then copy and paste it into notepad and name it something.xml, then run XML Parse, I am able to access the different nodes.

    <cfdump var="#xmlparse("test.xml")#">

    Below is the filecontent that I am able to create an xml document with and read successfully.

    Attached are images of the two cfdump calls.  I think the pictures should explain it.

    I am not sure if this has to do with XMLParse or with the response data that is being returned to me.

    Any help would be much appreciated.  I have been trying to figure this out for two days now and am exhausted...



    <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><ExecuteXMLResponse xmlns="http://rossinc.com/webservices/"><ExecuteXMLResult><method name="RS_BIN_TRANSFER"><database>_CONNECTSERVICE</database> <parameters><parameter> <name>ERROR_OCCURRED</name> <value>1</value> </parameter> <parameter> <name>XML_TAGS</name> <value>1</value> …
    0
    Important Lessons on Recovering from Petya
    LVL 10
    Important Lessons on Recovering from Petya

    In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

    Hello Experts-

    I have a list of names that I am calling a db query to pull the IDs, but am having trouble getting the IDs into an actual list.  It is returning 16 487 488 rather than 16,487,488

    <cfset affiliateList = #form.id#><!--- Looks like.... C - DME Media,KC - Floor Coverings International - Google HL,KC - Floor Coverings International - Yahoo --->
        
         <cfloop list="#affiliateList#" index="i" delimiters=",">
            <cfquery name="getAffiliateID" dbtype="query">
                select affiliateID
                from getCampaigns
                where name IN ('#i#')
             </cfquery>
             
         	<cfoutput query="getAffiliateID">
            	<cfset finalList = valuelist(getAffiliateID.affiliateID,",")>
               <cfdump var="#finalList#"> 
             </cfoutput>
         </cfloop> 
    

    Open in new window

    0
    Java Heap Space error being caused by a couple of different report queries in Cold Fusion using SQL script. I'm looking into issues that are causing this. This is early stage research as I'm not familiar w/ Java or this error. Any help is appreciated. From what I've seen its saying the code needs to be written in a more precise manner vs. merely increasing the memory allotment. A sample of the Cold Fusion/SQL query is below. Any suggestions as to where to start? There a total of 6 separate queries w/in the one file. The one provided is the first and "longest".

    Thanks in advance.

    <CFQUERY name="FPDWins" datasource="#dsn#">
    select DocumentID,
        DocumentNum,
        RHRecordID,
    	0 WorkitemInstanceID,
        LUFSBatchNum,
        ImageType,
        TransCode,
        LFPSStatus,
        to_char(DateToWINS,'MM/DD/YYYY') DateToWINS,
        to_char(WINSBatchID) winsbatchid,
        WINSRetrievalDate,
        WINSStatus,
        WINSContractNumber,
    	to_number(p1.property_value) MarkviewDocID
      from qbd_lufs_wins_documents_v l,
           sf_workitem_property_values_v p1, 
           sf_workitem_property_values_v p2
     WHERE p1.property_name = 'MarkViewDocumentID'
       AND p1.workitem_instance_id = p2.workitem_instance_id
       AND p2.property_name = 'RHRecordID'
       AND p2.property_value = to_char(l.rhrecordid)
       and DocumentType = substr(upper('#DocID#'),1,2)
       and DocumentFiscalYear = substr(upper('#DocID#'),3,2)
       and DocumentNum = substr(upper('#DocID#'),5)
    UNION
    select cond.dafis_document_id DocumentID,
        
    

    Open in new window

    0
    Trying to show member attendance at meetings. The concept here is that we would enter a meeting date, select the various members who attended, then be able to show a listing of which meetings a particular person attended, with the names in the first table column and meeting dates in successive columns. This is the code I am currently using but it gives a lot of false showings for each person

     <cfquery name="getDates" datasource="#conn#">
       select * from meeting_attendance
    </cfquery>
    <cfquery name="getMembers" datasource="#conn#">
       select * from members where member_userid <> 1
       and member_userid IN
             (select member_userid from meeting_attendance where attended = 1)
       order by lastname, firstname
    </cfquery>
    <cfoutput>
    <table>
      <tr>
        <td>&nbsp;</td>
          <cfloop query="getDates" group='meeting_date'>
          <td>#dateformat(getDates.meeting_date, 'mm/dd/yyyy')#</td>
          </cfloop>
      </tr>
      <cfloop query="getMembers">
      <tr>
        <td>#getMembers.firstname# #getMembers.lastname#</td>
          <cfloop query="getDates">
          <td align='center'><cfif attended eq 1>Yes</cfif></td>
          </cfloop>
      </tr>
      </cfloop>
    </table>
    </cfoutput>

    Example of current output

                                09/05/2017
    member name      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Yes      Y
    0
    The following script is producing invoices.  It was working fine in 4.5, but my server has upgraded to CF 7.0.  The first invoice is produced, and then I encounter the error,  I have removed all addresses from the database except for the 20 or so valid ones from people who bid in the auction.  I am not a CF expert, and I am freaking out a little bit.

    Here is the code:

    <html>

    <head>
    <title>SEND INVOICES</title>
    </head>

    <body BGCOLOR="#FFFFFF">

    <CFIF ParameterExists(ID) IS "NO"><CFSET ID=0></CFIF>
    <CFIF ParameterExists(PASS) IS "NO"><CFSET PASS=0></CFIF>
    <CFQUERY name="validate" DATASOURCE="DJS">SELECT * FROM ADMIN WHERE ID='#ID#' AND PASS='#PASS#'</CFQUERY>
    <CFIF VALIDATE.RECORDCOUNT is 0><CFLOCATION URL="ERROR.CFM?ERROR=2"></CFIF>

    <CFQUERY name="checkclose" datasource="DJS">select * from times where type='auction'</cfquery>
    <CFIF #checkclose.enddate# LT #CreateODBCDateTIME(now())#>
    <CFQUERY NAME="AUCTIONINFO" DATASOURCE="DJS" MAXROWS="1">SELECT * FROM TIMES</CFQUERY>

    <CFQUERY NAME="lots" DATASOURCE="DJS">SELECT * FROM lots ORDER BY lot ASC</CFQUERY>

    <CFLOOP QUERY="lots">

    <CFQUERY name="highbidder" datasource="DJS" maxrows="1">SELECT * FROM bids WHERE lot = #lot# ORDER BY bid DESC</CFQUERY>

    <CFIF HIGHBIDDER.RECORDCOUNT IS NOT 0>

    <CFQUERY NAME="HBI" DATASOURCE="DJS" MAXROWS="1">SELECT * FROM MEMBERS WHERE MEMBERID='#HIGHBIDDER.MEMBERID#'</CFQUERY>

    <CFQUERY NAME="CHECKTABLE" DATASOURCE="DJS" MAXROWS="1">SELECT * FROM WINTABLE WHERE …
    0
    Hi,
    I currently use a cfdiv to bind to a data file (data.cfm).
    This data.cfm file simply creates a CFquery and a html Table..

    When I use ColdFusion.Navigate I can refresh the above div (called div1) easily.

    However I have changed m CfDiv into a std html div and I am trying to use the $ajax.load function to reload the div.

    I believe my calling code is correct.

     $('#div1').load('data.cfm?id=100');

    However it seems jquery just ignores the server side code in my data.cfm file.
    If I makes a blank data.cfm with a few lines of html the do refresh ok.

    But not my data.cfm with what I need.
    cfquery and cfoutput & table.

    Any help would be appreciated..
    0
    I'm looking for help with an excel file export from a Cold Fusion form...The html version is working fine but the excel is blank. Has anyone had any issues w/ this. The form is working for the html and pulling from the db. The excel version is just blank with the same parameters.

    The only modification was to increase the max size of a field to 17 from 16 in the index.htm file to account for an increased reference number. Simple change but and the test db has been updated w/ the criteria to pull from but for some reason the excel file isn't populating. I know this is vague but I'm hoping someone can shed some light or at least point me somewhere I can find some assistance. Thanks.
    0
    I'm looking for help getting a jump start on implementing SAML 2.0.   I have read a lot of documentation but it all seems geared towards the user-end, not the developer end.   Here is our situation.

    We provide a website to corporate clients, each corporation has many users.   These companies have their own websites and their users have their own logins.   Our clients want their users to login to their website and be able to pass through to our website without needing a login on our website.

    -Our clients' websites would login the user  and then pass the user onto our site without needing to login
    -Our site would accept the user as long as the client says they are valid, we are ok accepting them.  
    -We would create a corresponding user record on our end for each user

    What do we need to do on our end to implement SAML?  
    Can we code something and/or do we need a third party?
    We code in Coldfusion (CF 11)

    While I do understand Single Sign-On and the parts of SAML needed.  I have yet to find steps to actually implement.  Any help with this would be greatly appreciated.
    0
    MySql 5.7 / Coldfusion 11

    I have a real estate property search form with multiple fields for instance  City, Price, Acres, etc... and a Keyword input that needs to be able to further filter these results.   Example: I need to be able to find only properties listed in a certain city by a certain agent the agents name goes in the "keyword" input.

    I have 3 tables in my database that I need to query and do a fulltext search on; "listings",  "fagents", "fcoagents"  
    so I added fulltext index for each.

    ALTER TABLE listings ADD FULLTEXT(Class,Type,SubType,City,PropertyName,Highlights,Remarks,Agent,CoAgent,AddressNumber,AddressStreet,Zipcode);

    ALTER TABLE fagents ADD FULLTEXT(AgentFName,AgentLName,AgentEmail);

    ALTER TABLE fcoagents ADD FULLTEXT(AgentFName,AgentLName,AgentEmail);


    SELECT * FROM listings
    LEFT JOIN fagents ON listings.Agent = fagents.Agent
    LEFT JOIN fcoagents ON listings.CoAgent = fcoagents.CoAgent

    WHERE (Status = "Active" OR Status = "Pending")

    AND

    <!---Search by City--->
    <cfif StructKeyExists(form,"City") and listLen(trim(form.City), ",")>
     AND City IN
            (
                 <cfqueryparam value="#form.City#"
                       cfsqltype="cf_sql_varchar"
                       list="true"
                       separator=",">
         )
    </cfif>

    <!---Search by keywords--->
    <cfif StructKeyExists(form,"Keyword") and len(trim(form.Keyword))>
    AND
    0
    I have been uploading pdf and jpg file from our local server to a hosted server using FTP. However, for security reasons the hosted server stopped the FTP service two weeks ago. The hosted server told us to start using CFHTTP to replace FTP.

    We were using CFFTP for:
    <cfftp action = "open"
    <cfftp action = "remove"
    <cfftp action = "close"
    <cfftp action = "LISTDIR"
          Etc…

    Does anyone have a Coldfusion example on how to transfer file from a local server to hosted server ? I have never used CFHTTP before
    0
    New feature and membership benefit!
    LVL 10
    New feature and membership benefit!

    New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

    I have a ColdFusion 11 component which is supposed to populate a cfselect using bind. However, the select is not populated with the values at all. It shows blank. These are 2 select form controls that I want to relate to each other. A select from one should populate the other with values based on the selection made.cfselectbind.txtcfselectbind.txt
    0
    I need a form field mask for a date field to read: MM/DD/YY in a cold fusion form.

    I have other fields working but the date field won't take. Would the letters vs. numbers be issue. My current code is setup for the mask:

    <cfset session.invoiceDataContr.Invoice_Date = "MM/DD/YY" >
    

    Open in new window

     <font face="Arial" size="2" color="#990000"><label for="Invoice_Date">Invoice Date:&nbsp;</label>
                            <input  id="Invoice_Date"  name="Invoice_Date" size="15" maxlength="8" type="date"  tabindex="8"  value="<cfif structkeyexists(session.invoiceDataContr, "PASS")><cfoutput>#session.invoiceDataContr.Invoice_Date#</cfoutput><cfelse><cfoutput>#form.Contract_Number#</cfoutput></cfif>" required/>
    

    Open in new window

    0
    I need to validate a date field with MM/DD/YY requirements using a regex within a cold fusion form.
    0
    I'm trying to integrate a coldfusion app with MS sharepoint. Both sites are within the intranet so it shouldn't be anything network related. I'm able to browse to the wsdl file from a browser but the cfsharepoint tag part gives following error:

    Unable to read WSDL from URL: https://nri.pcd.com/books/authors/_vti_bin/Lists.asmx?wsdl.

    ***********************************************************************************
    Here's my cf code snippet:
    ***********************************************************************************
    <cfscript>
          login = {domain="https://nri.pcd.com",
          username="uname", password="pwd"};
    </cfscript>

    <cfoutput>
          
                <cfsharepoint action="getlistcollection"
                      wsdl="https://nri.pcd.com/books/authors/_vti_bin/Lists.asmx?wsdl"
                      login="#login#"      name="result">
    </cfoutput>

    <cfdump var="#result#">
    0
    Current code that's breaking is:

    1:^(([\w\!#$%&'*+-/=?^_`{|}~;]+(?:\.[\w\-_]+)*@(?:[\w\-_]+\.)+[a-zA-Z]{2,7})[;]?)+$
    

    Open in new window


    error message:

    "Error","ajp-bio-8012-exec-5","07/31/17","10:55:57",,"Invalid CFML construct found on line 214 at column 73.ColdFusion was looking at the following text:<p>\'</p><p>The CFML compiler was processing:<ul><li>An expression that began on line 214, column 69.<br>The expression might be missing an ending #, for example, #expr instead of #expr#.<li>The tag attribute pattern, on line 214, column 53.<li>A cfparam tag beginning on line 214, column 6.<li>A cfparam tag beginning on line 214, column 6.<li>A cfparam tag beginning on line 214, column 6.</ul> The specific sequence of files included or processed is: D:\inetpub\wwwroot\centralinv\central_inv_contr_verify.cfm, line: 214"

    I'm guessing the # is throwing an issue and maybe the $ and ^ ... anyone have any ideas to get around the coding errors for those characters:
    0
    Hello Experts,

    I have trouble getting a Connection Failure. Status code unavailable. response  after waiting for longtime.

    Response when using coldfusion to submit
    response
    Response when copy pasting the URL in the borwser

     
    {
      "success": true,
      "challenge_ts": "2017-07-28T17:28:02Z",
      "hostname": "wsq02230"
    }
    

    Open in new window


    <meta http-equiv="X-UA-Compatible" content="IE=Edge" />
    <cfsetting requestTimeOut = "9000" />
    <cfparam name="FORM.username" default="" type="string" >
    <cfparam name="FORM.password" default="" type="string" >
    
    <cfif structKeyExists(FORM,"submit")>
    	
    	<cfset recaptcha = FORM["g-recaptcha-response"] >
    	<cfif len(recaptcha)>
    		
    		<cfset googleUrl = "https://www.google.com/recaptcha/api/siteverify">
    		<cfset secret = "XXXXXXX">
    		<cfset ipaddr = CGI.REMOTE_ADDR>
    		<cfset request_url = googleUrl & "?secret=" & secret & "&response=" & recaptcha & "&remoteip=" & ipaddr >
    		
    		<cfoutput>
    		#request_url# 
    				<cfoutput>
    				<!--- <cfhttp url="#request_url#" method="post" timeout="10" result="captcharesult">
    					<cfhttpparam name=remoteip value="#ipaddr#" type="url">
    				</cfhttp> --->
    				<cfhttp url="https://www.google.com/recaptcha/api/siteverify" method="post" result="captchaResult">
    				  <cfhttpparam type="formfield" name="secret" value="#secret#"> 
    				  <cfhttpparam type="formfield" name="response" value="#recaptcha#"> 
    				  <cfhttpparam type="formfield" name="remoteip" value="#CGI.REMOTE_ADDR#"> 
    				</cfhttp>
    				
    		
    

    Open in new window

    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.