ColdFusion

I'm sure this is a simple thing to do, sadly I'm stuck! Any help would be appreciated.I need to create a query from a json file from Groupon. I can get the file, deserialize it but then I just run into a brick wall!<!--- Make the request to the API ---><!--- Get the JSON Feed ---> <cfhttp url="https://partner-int-api.groupon.com/deals.json?country_code=IE&tsToken=IE_AFF_0_200012_212556_0&division_id=dublin&offset=0&limit=20"> <!--- Strip the function wrapper. ---> <cfset theData=REReplace(cfhttp.FileContent,          "^\s*[[:word:]]*\s*\(\s*","")> <cfset theData=REReplace(theData, "\s*\)\s*$", "")> <!--- Test JSON data. ---> <cfif !IsJSON(theData)>     <h3>The URL you requested does not provide valid JSON</h3> <cfelse> <cfdump var="#theData#"> </cfif>The file is at: http://www.thefuture.tv/grouponJSON.cfm

I have ColdFusion 9 running on a Windows 10 Pro computer.  I am using ColdFusion's built-in server.  Everything runs perfectly.  However, when I run it from another computer on the same network, I get an error I have never seen before.  It balks at one of CFAPPLICATIONS's parameters in the Application.cfm file.  As I mentioned, this Application.cfm file works perfectly locally.  (In fact it is the same Application.cfm file I have been using since Coldfusion 5 running on a Win 2000 Pro machine.)  Here is a bit from that file:<CFAPPLICATION     name             = "FredsWebApps"     clientManagement    = "YES"     setClientCookies    = "YES"    sessionManagement    = "YES"    setDomainCookies    = "NO">but on the local machine I get this error:The system ha

Hi,When I add another session variable in the application.cfc file and access it in the login page, it does not appear in other pages.Current session variables change after I select the refresh button on the IE browser.Using Cold Fusion 11 and IE browser version 9.The Enable Session Variables option in the Cold Fusion admin is enabled.Is there any solution to have the session variables available without having to refresh the page and have the new session variables available?Thanks,Mike

Using CFB 3.0.0 build 292922, connected to remote server running CF8 and IIS 6, I cannot get the debugger to work on ColdFusion files that have a non-standard extension.  Everything is working as expected on files with a .cfm or .cfc extension but not on any other files.At first I could not even add breakpoints to those files and then I found the setting for Window>Preferences>ColdFusion>Debug Settings>Valid Extensions.  After adding my extension there I was able to add breakpoints to the file, but in trying to debug they are not firing.With no other changes I can switch to FusionDebug and everything does work.What am I missing to make this work using the ColdFusion debugger?

Whatwould be the best way to copy a file from one website to another - i.e. coldfusion application to sharepoint?

Hi, I need a State-Wise Clickable USA Map in my CF 9 Application. Any ideas, Can some one help. Please?

I'm using <cfdocument> to generate a PDF that contains tables. I have all of my style declarations within the <cfdocument> and those styles are being read properly.My problem is that if I set a background-color for a row, that color overflows onto about half of the right and bottom table borders. Here's an image of what I'm seeing on the PDF document, colors are for visual identification of each border. The PDF prints with the same anomalies.The table border is 1.5pt red line, which you can see on the left and top just fine, but the right and bottom borders are thinner. The rows numbered 1, 2, and 4 all have a class applied to the <tr> providing a background-color (#fff or #eee). To prove what I thought was happening, I adjusted row 3 so that there is no background-color declared at all. Note that row 3 has the proper width for the right table border. Other testing has shown that the background-color is affecting the bottom table border as well.Can I do something to t

Hello, all,I'm trying to get bcrypt to work in CF11 server, and I'm banging my head into a wall.I've got the following in my application.cfc file: this.jsPath = "/path/to/html/classes/"; this.javaSettings = {LoadPath = this.jsPath}; The path is where I have placed "BCrypt.class" file downloaded from GitHub.This, by itself, doesn't cause any problems.  But adding the following causes it to error, and it will NOT see the application scoped variables (like the onError email address that I'm setting): bcrypt = CreateObject("java","BCrypt"); This breaks everything and even the error template won't display.  What am I missing?Thank you,^_^

I created cfloop that goes through query that I created above the loop. Inside of the loop I have another loop that defines values and then cfquery with insert statement. I tested my loops before I tried to insert my records in database and everything looked good. After I tried to apply that to my cfquery insert, only first ID from cfloop qryRecords is inserted and inserting stops after that. Here is example of my code:<cfloop query="qryRecords">      <cfloop condition="TimeStart LTE meetingLength">           <cfset TimeEnd = dateAdd("n", arguments.meeting, TimeStart)>           <cfquery name="addRecords" datasource="test">                Insert Into(Date,Name,Location)                Values(<cfqueryparam cfsqltyp

OS: RHEL 6.7 (64-bit)ColdFusion processes are dying or stop running for no reason that we can find in the ColdFusion log files or in the OS log files. Does anyone any suggestion what I can do to troubleshoot this issue.

We recently migration our application from CF 8 to CF 11 Update 3. There is a ColdFusion web service that is being consumed by a .NET application. The cfcomponent tag is specified with the following attributes<cfcomponentstyle = "rpc"bindingname = "component1.cfcSoapBinding"namespace="http://#cgi.host_name#/<webservicefolder>/component1.cfc"serviceaddress="http://#cgi.host_name#/<webservicefolder>/component1.cfc"porttypename = "component1"serviceportname = "component1.cfc">In Our Test server (same CF version), the webservice is invoked by the .NET application successfully. However, in Production server, the .NET application is getting error when trying to invoke the service. The error information at .NET end is :  There is an error in XML document (31, 31). at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)     at System.Xml.Serialization.XmlSerializer.Deserialize(X

Hello everyone, I have question about inserting records in two different tables at the same time, what I'm looking for is passing unique id that gets created in first insert statement to second insert statement. Example for this problem:<cfquery name="addRecords1" datasource="test">      Insert Into Table1(Name, Date, Age)      Values (<cfqueryparam cfsqltype="cf_sql_char" value="#arguments.Name#">,                  <cfqueryparam cfsqltype="cf_sql_date" value="#arguments.Date#">,                  <cfqueryparam cfsqltype="cf_sql_int" value="#arguments.Age#">);      Select SCOPE_IDENTITY() As RecID;  </cfquery>  <cfquery name="addRecords2" datasource="test">       Insert I

Hello everyone, I have a question about inserting dynamic table with time values. Here is example of the table that I have to insert in db:Schedule for 10/05/201609:30 AM - 10:00 AMRemove10:00 AM - 10:30 AMRemove10:30 AM - 11:00 AMRemove11:00 AM - 11:30 AMRemove11:30 AM - 12:00 PMRemove05:00 PM - 05:30 PMRemove05:30 PM - 06:00 PMRemove06:00 PM - 06:30 PMRemove06:30 PM - 07:00 PMRemoveI do not have a problem to insert values if my time difference in always the same. Like first few time slots are increased for 30 min but then I have a gap from 12:00pm all the way until 5:00pm. My problem is there. I do not know what is the best way to save these values. Since values are created dynamically and all of them are under the same date. If I do not have time breaks that would be really easy but in this case where I have time gap looks really complicated. If anyone can tell me what si the best way to store this in database please let me know. Thanks in advance.

Adding new category names are showing the following error.  Also, it is not allowing me to edit the names at all.  Please help resolve this.  Thank you.Field 'blogCategoryid' doesn't have a default valueRoot cause :java.sql.SQLException: Field 'blogCategoryid' doesn't have a default valueThe error occurred in C:/ColdFusion11/cfusion/wwwroot/learncfinaweek/chapter1solution/admin/content/blog/editcategory.cfm: line 33<cfset ormFlush() />editCategories.cfm:<cfimport taglib="../../customTags" prefix="ct" /><ct:securityCheck redirectPage="#cgi.script_name#"/><cfparam name="url.id" default="0" /><cfparam name="form.submitted" default="0" /><cfparam name="form.id" default="0" /><cfparam name="form.name" default="" />                <cfparam name="form.categories" default="" /><cfset errorBean = createObject('learncfinaweek.chapter1solution.admin.cfc.erro

So I'm using the following code to create a PDF from data from a query.<cfpdfform action="populate" source="test.pdf" destination="GeneratedPDFs/test.pdf" overwrite="yes"><cfpdfformparam name="FirstLine1" value="#Variables.FirstLine#"><cfpdfformparam name="SecondLine1" value="#Variables.SecondLine#"><cfpdfformparam name="AddressBox1" value="#Variables.AddressBox#"><cfpdfformparam name="Body1" value="#Variables.Body1#"><cfpdfformparam name="FirstLine2" value="#Variables.FirstLine#"><cfpdfformparam name="SecondLine2" value="#Variables.SecondLine#"><cfpdfformparam name="AddressBox2" value="#Variables.AddressBox#"><cfpdfformparam name="Body2" value="#Variables.Body2#"></cfpdfform><cfpdf action="write" source="GeneratedPostCards/!PostCard2013-Vipre.pdf" destination="GeneratedPostCards/!PostCard2013-Vipre-flat.pdf" flatten="yes" overwrite="true"></cfpdf>This works fine, and generates the PDF for me, but I've run into thr

I have come across an interesting issue and hopefully I'm not the only one with this scenario.  First the environment: 64-bit Windows Server 2008 (I found the same issue on SP2 and R2), ColdFusion 9.0.1 Enterprise edition, ColdFusion HotFix 1, IIS 7 (native mode), Sun Java 1.6.0_22, Microsoft SQL Server 2005 (on a different server).The issue that I have is I cannot get my datasource to verify.  ColdFusion returns this error:Connection verification failed for data source: clientsjava.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.Now here is what I have found so far.  I think I have finally narrowed this down to an issue with the Sandbox Security and the fact that we are using a database instance on our SQL server.  With the S

Hello,Box.com has an API that allows files/folders to be manipulated programmatically.  The syntax using the curl command to generate a link to a file uploaded to box.com is:curl https://api.box.com/2.0/folders/FOLDER_ID -H "Authorization: Bearer ACCESS_TOKEN" --data '{"shared_link": {"access": "open"}}' -X PUTI'm unable to figure out the correct syntax for sending the --data part of the curl command.  So far, I have this:    <cfhttp method="PUT" url="#web_svc#"  redirect="yes" timeout="30">        <cfhttpparam type="header" name="Authorization" value="Bearer #access_token#"/>        <cfhttpparam type="formField" name="shared_link" encoded="no" value="{"access": "open"}"/>    </cfhttp>But Box throws an error:Invalid value '0={"shared_link": {"access": "open"}}'. Entity body should be a correctly nested resource attribute name/value pairAny suggestio

I migrated my application from CF9 to CF11, and got a serializejson issue. When serialize object data with empty string,  the serializejson function generates invalid string.I have function getConfiguration in A.cfc and function getImageResult in B.cfc. The function getConfiguration would get an object data and serialize them to json, then return the json data. Below are the object data and the generated invalid json. In this case, I would got json parsing error when deserialize json in getImageResult function.Object data: {      RESULT: true       MESSAGE: call function getConfiguration successfully       OBJECT: {          HID: [empty string]          TF_LAB_USE_DOCUMENT_MANAGEMENT: [empty string]          PARENT_HID: [empty string]      }   &

I have several errors that I could use some help on.  Below is just one of them.  I mention that in case I need to bring them all up in order to troubleshoot this correctly.  Maybe it is worth noting that I am going through the learncfinaweek.com hands on (ORM) and have most of the code working except the categories that keep the boxes checked in editBlogPost.cfm and Categories are not saving correctly.  That said, here is the first error:The cfdump showed that title is getting pulled in, so I would like to know why it won't pass the var.  Element TITLE is undefined in BLOGPOST   The error occurred in C:/ColdFusion11/cfusion/wwwroot/learncfinaweek/chapter1solution/admin/content/blog/listblogpost.cfm: line 34listBlogPost.cfm:<cfimport taglib="../../customTags" prefix="ct" /><ct:securityCheck redirectPage="#cgi.script_name#"/><cfset adminPath = createObject('learncfinaweek.chapter1solution.admin.cfc.system').getBasePath(cgi.script_name) />&

Version 3.0.3.292922    Build 292922Running on Windows Server 2008 R2 Standardjava version 1.8.0_66Editing local files (not on a mapped drive or directory)Seems to only happen in components that are using CFSCRIPT, but not all components.I just created this simple component:(note: using ColdBox for dependency injection)<cfscript>component name="facility_service" {     property name="facility_dao" inject="model:facility_dao";     query function getFacilityQuery(string loc_level ="") {          return facility_dao.getFacilityQuery(loc_level:loc_level);     }}</cfscript>This component works fine and does what it should do.But if I attempt to edit the function:     query function getFacilityQuery(string loc_level ="") {          if (loc_level EQ "") {       &nbs

Hi, I installed CF 11 Developer edition on Windows 12R2 and I have Oracle 12c as db. I installed both 32-bit and 64-bit of Oracle 12 clients. I tried to set up a data source using both odbc and jdbc approaches, but none of them is working. I ran the odbcad32.exe file from "C:\Windows\System32\", and odbcad32.exe from "C:\Windows\SysWOW64" to set up my data sources. Both connections are tested successful. For odbc, it said "The specified DSN contains an architecture mismatch between the Driver and Application". For jdbc it said no suitable driver available. Has anyone seen this and solved it? Thanks for any pointer.

ColdFusion‌

What does this mean and how can if fix it?  the message reads "413 Header Length to large."

My CF9 server suddnely stopped proving debug output. Debug output is set to yes and I've got the correct ip addresses. I have even tried  <cfsetting showDebugOutput= "true">, but nothing appears. Any ideas?

I have an old HP ProLiant server with ColdFusion 10 on it.   The server is government provided and is running Windows Server 2003. It is agonizingly slow, especially via my company's VPN.  The SysAdmin at the office spun up a VM Windows 2008 R2 server for me and I'm in the process of transferring everything from the old server to the new one.   It is a development database.   I have downloaded and installed Oracle 11g on the new server, imported the old database and code.  Oracle allows you to download and use the software for free if it's a single user development machine.   I am under the impression that Adobe doesn't do the same with CF.   What is the process to transfer the license?   Since this project is at end of life, my government customer doesn't want to spend money on a new server, or any new software.   Any help would be greatly appreciated.