ColdFusion

Hi, I'm trying to get this pagination code functioning but I keep getting an error on my query. The error says: Microsoft Access Driver] Syntax error (missing operator) in query expression 'titles LIMIT 0' and I'm completely stumped, I pasted my coded on this page if anyone could help or point me in the right direction I would appreciate it. Thanks. <cfparam name="url.page" default="1"> <cfset page_links_shown = 5> <cfset records_per_page = 5> <cfset start_record = url.page * records_per_page - records_per_page> <cfquery name="get_count" datasource="dgr"> SELECT COUNT(nid) AS records FROM news </cfquery> <cfquery name="get_names" datasource="dgr" result="get_data"> SELECT titles FROM news ORDER BY titles LIMIT #start_record#, #records_per_page# </cfquery> <cfset total_pages = ceiling(get_count.records / records_per_page)> <cfoutput> <cfloop query="get_names"> #start_record + currentrow#. #names#

After applying a hotfix I could no longer access the Coldfusion Administrator.On linux (CentOS 6.9) running Coldfusion 11, my CFIDE folder is /opt/coldfusion11/cfusion/wwwroot/CFIDEThen I have a symlink setup to the default site on the server: /var/www/vhosts/default/httpdocs/CFIDE/ this points to the /opt/coldfusion11... folderThis was all working fine till I installed a hotfix, now I can't server CFM pages.I can go into the CFIDE/administrator folder and add "test.html" and view it in the browser fine, but if I change the extension to ".cfm" it fails. I get a 404 error page.Oddly, this loads a custom Coldfusion error page and records the error for me in the database, and all the websites running on the server are fine.My neo-security.xml file doesn't have any records in the allowedAdminIPList: ><var name='allowedAdminIPList'><string></string></var>So that shouldn't be blocking access.It's only CFM files that fail to serve. I've tried a .php, .htm, .html fil

I'm trying to generate a multi page pdf. One per record. I'm using div for precise positioning. The result is good for a single record. But if I loop over multiple records (see below) the page break has an odd behaviour.It chops at the beginning of the each page and prints everything on the last one . If I don't use the page break, everything is printed on the first page. What am I missing ?<cfdocument        format="pdf"        pagetype="legal"        orientation="portrait"        fontEmbed="true"        unit="cm"        localUrl="true"        saveAsName="recus_impot"        marginLeft="0"        margintop="0"        marginright="0" 

For anyone having issues with moving an old CF9 site to CF2016 that used the ADDT (Adobe Dreamweaver Development Template) files, I have discovered a possible fix to the error: "KT_getRealValue:Unknown method: KT_Insert1."When browsing a page served up from CF2016, the following error displays: "KT_getRealValue:Unknown method: KT_Insert1." for all pages1) Browse to this post & apply all of the changes listed: https://forums.adobe.com/thread/5153852) Now browse to the "includes\common\KT_functions.inc.cfm" file and make the following change (around line 914): <!---Fix for CF9 (& above) when getting error: "KT_getRealValue:Unknown method: KT_Insert1." Just comment out the "cfdefaultcase"--->        <!---<cfdefaultcase><cfset Request.KT_die('KT_getRealValue:<br />Unknown method: ' & method & '.')></cfdefaultcase>--->3) Try your pages again and they should now be working.ps: looks like the code won't pos

Hello!I could see a string on the screen by <cfoutput> #cfhttp.FileContent# </cfoutput>.But #cfhttp.FileContent# could not be handled as a string.How can I extract a string from #cfhttp.FileContent#.Thank you in advance!Masaru**********<cfhttp method = "Get"  url="http://xxx.xxx.xxx" ><cfoutput> #cfhttp.FileContent#</cfoutput>**********

Are there any plans to upgrade the CF Report Builder?  and if not - anyone have any suggestions for an alternative product for producing reports?

Does anyone know if the size of the icons on the toolbar, the text on the toolbar of ColdFusion Builder can be enlarged?Also, the type/font of text in cfm files, only when opened in this editor is terribly faded...as if some antiquated app from the 1990's opened them.I Can barely read it. Need to change this too.If these can't be fixed, I find ColdFusion Builder to be Unusable.  I'd need a magnifying glass to see these anything.I certainly won't be buying it after the free trial unless there's a way to change these settings. Actually, I likely won't use it even one time, it looks so awful.I don't have this issue anywhere else, with any other app. Awful, with no ability to customize, or at the very least make it useable.Of course I searched all the settings I could find looking for a way to make readable.Thanks in Advance.(Windows 10, 64bit, NVidaGForce 2GB vidRam...machine is more than capable of rendering properly)

Sorry.. I didn't see a forum for Adobe Tracker, so I'm posting it here.I logged on to Adobe Tracker, and the home screen shows that I have not submitted any issues, nor voted on any issues.  I have several of each.  Where did they go?V/r,^ _ ^

Hi All,Recently, we have upgraded ColdFusion 2016 version from ColdFusion 8 version. We have been facing issue with the application which was implemented in ModelGlue 2.0 and ColdSpring framework. As per my observation, ModelGlue framework  is not loading due to this application is throwing method not found error.Is ColdFusion 2016 version supports ModelGlue 2.0 and ColdSpring framework ?Thanks in advance

I have an application implemented in Coldfusion and  AngularJS.I have an external authentication system used for the security of our applications. It's called in the file application.cfc of the application. When the user tries to access to the application, the authentication system is called and if the authentication is correct, the user can access to the application. I put in session some data about the users'roles.This security system is defined with another url.In views I have some forms with drop-down list populating thanks to *AJAX queries*.As there is no refresh of the page (Single page application).If the server session is out, the queries are not correctly executed: I obtain the server status 302, because the authentication tries to be launched and I can see in the colnsole:    Failed to load https://myAuthenticationSystem: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested res

Trying to download the latest CF11 update jar, but all the links on this page (and indeed the pages for CF10 and 2016) appear to be dead, returning a response of Not FoundThe requested URL /pub/adobe/coldfusion/11/hotfix_013.jar was not found on this server.Is this a known issue? I haven't been able to locate a mirror for the updates.

Hello, all,Is it possible for ColdFusion to iterate JSON data (stringify()) without parsing it to a JSON object using DeserializeJSON()?V/r,^ _ ^PS:  Specifically if I have a JSON string like..[{"name":"whichForm","value":"NDOD"},{"name":"caseNumber","value":"123"},{"name":"airLiner-0[]","value":"AIR"},{"name":"airLiner-0[]","value":"LINER"}]I need to iterate this and get name/value pairs, without using DeserializeJSON(). 

I am running CF10. New installation on Windows Server 2012R2. Intranet site.In ColdFusion Administrator, the mail server connection verifies as successful.Mail server is smtp.office365.com (have also tried smtp.outlook.office365.com)Port is 587Username and password are blank, however I have tried it with a valid username and password as well. In both cases the connection is successful.Enable SSL is unchecked.Enable TLS is checked.No other combination of SSL and TLS will verify.When I send an email using CFMAIL, the mail goes into the undeliverable folder every time without fail.My internet searches have been futile in this case. With the prevalence of Office365 this can't be a unique scenario can it?

Hi,I created a file called cfoauth_facebook.cfm with the following code.The Facebook developer app with clientid, secret key etc has been setup correctly. But when the following code is executed, i only get a error in the response variable called res.<cflogin><cfoauthtype = "Facebook"clientid = "MyClientId"secretkey = "MySecretKey"result = "res"scope="email"redirecturi = "https://testsite.localtest.me/cf16/cfoauth/cfoauth_facebook.cfm"><cfdump var="#res#"><cftry><cfloginuser name="#res.other.username#" password="#res.access_token#" roles="user"><cfcatch type="any"></cfcatch></cftry></cflogin><cfabort>------------------------------- The response is-----------------structaccess_token n":"EAALbDZBHSZBNUBAIVhtNLCydBu1A3pYIoTpkofVKQHXTrZCM2E2gYLOpOknRM74ZAw5YZCmZBtyNHkZCXnfqV4XWga2zzWvwMKjET9ZAUKt7hXO0PmX0AM8Hz012oKV4aIXf2ZAfqVA2gYWMg3HeDRkImXJLEilF8v48Gr8cq6wGHJZB7I7WuK9RIO","token_type":"bearer",gender undefinedid undefinedlocale

I have seen some posts (Muse forum) stating that embedding coldfusion code in Muse pages is impractical.  However, I want to do the opposite.I tried calling the muse from CF using a variety of methods, including cfhttp (presumably preferred), cfmodule, and cfinclude.  The following error code seems to be the core issue among these methods:COM.Allaire.ColdFusion.HTTPFailureI have also tried removing some of the standalone page type code from the muse code (e.g. !DOCTYPE, and HTML and BODY tags), but to no effect.  I asked this on the Muse forum as well.<div class="container home">        <cfhttp url="#application.proot#/includes/__sstandards/index.html"  method="GET" resolveurl="Yes" throwOnError="Yes">        <!---cfmodule template="#request.includes#/__sstandards1/index.cfm"---><!---||#application.proot#||---></div>

Greeting I have set up a successful cfldap query which will return all users in Active Directory. If the user has logged into the network, I want them to give them a view of certain data that someone outside the network cannot access. I tried to send the internal user through an authentication page: <cfldap action="QUERY" name="results" attributes="userPrincipalName" (which is their email address) start="dc=xxxx,dc=xxxx" scope="SUBTREE" filter="(&(objectCategory=user)(userPrincipalName=*))" server="DC1.xxxx" username="master\administrator" password="xxxx"> This queries the AD as the admin because a second login by the user is what I am trying to avoid. <CFIF .........?> <cfset Session.user_id = results.userPrincipalName> <cflocation url="switchboard.cfm" addtoken="No"> <cfelse> <cflocation url="cannotauthenticate.cfm" addtoken="No"> </CFIF> Is there any way to accomplish this? Thanks rinorman

I just turned up a new VM  for Windows 2016, installed ColdFusion 2016 Standard Trial, and set IIS as default web server.I created all my DatasourcesI then copied my website called CRM to the inetpub directoryWhen I browse any page on the site, I get "Please Login using Simple authentication" with username & password boxes?What is different with CF2016 that causes this?

I went through the Sync  settings and now I don't how to change or delete the FTP servers

Hello.   I have a CF application that is used to track membership in our club.  There is about 6000 members in our membership database.  One of the useful features about the membership database is that it is easy to code a CF application to send e-mails to various people in the database based on various criteria (i.e. position, address, hobbies, etc.).The application uses the standard cfmail function in a database loop.  For the most part it works pretty well.  The problem occurs when someone wants to send an e-mail to "everyone".  Sometimes the application on the users side appears to "hang" so the user sends the e-mail again (clicks back and send) which makes people get duplicates.Also our website hosting company limits the number of e-mails we can send per hour so this gets them mad and they threaten to shut me down.   So I am trying to think of ways to change the code.If I changed the program so that instead of doing a separate cfmail to

We're a tiny company of 3 whose CF programmer is gradually retiring. What is the best resource for finding a CF programmer who can step in as needed, but also help us upgrade from CF 9 to 2016 and tune up the existing programming? We don't have a huge budget so working with a larger company is out of the question for us. Freelancer wasn't hugely helpful unless we're willing to use someone outside the U.S. which we prefer not to do. Any resources would be greatly appreciated.

Hello all,I am running into a problem where I am parsing XML and running into an error: An error occured while Parsing an XML document.An invalid XML character (Unicode: 0x17) was found in the element content of the document.Therefore my approach is that I obviously have to remove some kind of odd character but I have no idea what it is. I would like to take the XML and perform something like the following:<cfset XML = Replace(XML, "&","","All")>Where "&" is the special character (0x17). Can anyone assist with what this character is or has had this problem? I wish I could post the XML but I cannot get at it because the page is breaking. Any help would be greatly appreciated!!!!Thanks

I tried to download the free trial for Coldfusion, but was unable to complete the form. The required State/Province field has no options and, when submitted, the form indicates that this field is missing a value and validation fails.I'm a developer getting back to Coldfusion and it sure would be nice to have a developer edition to work with!Thanks,Noah

Cannot get Coldfusion 11 Application server service to start. Running Windows Server 2012 R2 Standard Coldfusion 11 update 12.Error: Windows could not start the Coldfusion 11 Application Server service on Local Computer. Error 1053: The service did not respond to the start or control request in timely fashion.Searched for other remedies to no avail. As a "band-aid" I was able to run the cfstart.bat file in a CMD window to have the service start and run. (if the CMD window ever closes, this will stop the service - hence the band-aid)Here are some of the things we tried - they DO NOT Work:Increased the Windows service time-out - https://support.microsoft.com/en-us/help/922918/a-service-does-not-start-and-events-7000-and-7011-are-logged-in-windowRan the service as an Administrator - both local and network (under Properties and select Log On)Tried blocking coldfusion from accessing the IP 192.150.19.110 (coldfusion.adobe.com)We are not running a proxy

Hi Folks,Our Cf servers live behind a load balancer.  We have an app that makes a cfhttp call to an outside web server.  The problem occurs when the data returned comes back through the load balancer and doesn't always return back to the originating server.  Is there a way to ensure that the returned data returns to the correct server?

We have the option of adding java and jvm arguments from the ColdFusion admin page , by mistake I have added an extra line  while adding a proxy and I lost access to the admin page now, where can I edit those java jvm arguments in the server (In which folder can I find them in the server)