ColdFusion

Hello,my coldfusion application runs in Intranet  and  Internet (https://www.xxx.com/inputform.cfm)When I open my CF-Page from Internet,  server side validation does not work.No popup comes to tell that the required form field isn't filled out.When I run the CF-Page as an internal Intanet application (http://servername/inputform.cfm)the validation works fine.Here is an example of an <cfinput name="catalog" type="text"   required="Yes" message="Catalog is required" >Is https protocol the reason?Best regardClaudia

I'm running into some problems with a relatively simple task.Application.cfccomponent {    THIS.datasource = "xmdlocaldevdb";    THIS.name = "TESTING"; // MUST BE SAME AS TOP LEVE APP    THIS.ormsettings.cfclocation = "/xmdroot/model/beans";    THIS.environmentName = "TESTING";    THIS.ormenabled = "true";    THIS.ormsettings.cfclocation = "/xmdtestroot/model/beans";    THIS.ormsettings.logSQL = "true";    THIS.ormSettings.dbCreate = "none";    THIS.ormsettings.eventhandling = true;}Parent.cfccomponent persistent="true" table="Parent" {    property name="id" fieldtype="id" column="ParentID" generator="identity";    property name="Title" type="string";    property        name="Childs"        fieldtype="one-to-many"    &nb

On my Windows Server 2008, when I click the "Check for Updates" button, it says "No updates were found" but I know that the latest update for ColdFusion 10 is update 18 and mine only has Update 9 installed. The following is the path to checking for updates. So, why is it not able to find the updates? Is there a way to download them manually and install them?ColdFusion Server Updates

I am on CF9 and all my scheduled jobs used to work but now all fail. After running them manually I get 7 error msgs. I eliminated those that don't apply and here is the one left that I don't understand. Has anyone seen it? The URL is protected by IIS NT Challenge/Response or Apache .htaccess password. The Username and Password text fields for editing a scheduled task are intended to support Basic Authentication only.

I am having trouble getting the latin character "ä" display correctly in the pdf generated from coldfusion code. I get "ä" instead of "ä" I am setting cf processing directive to UTF-8. I can hardcode "&auml" and get the "ä" character displaying correctly in the pdf, so the pdf can handle displaying the character. Most posts refer to a mismatch of encoding that is causing this mojibake, but I can't see where there is any mismatch. The value being used as input into the pdf document is coming from a form (cold fusion) that takes user input and the form tag in cf code has this property set: accept-charset="utf-8" On the input form and in the cfm file handling the submit, the processing directive is set to UTF-8.If anyone has any suggestions... thx -mike

Hi,We have a database with dates stored as day, month and year fields and need to build a query that returns a recordset for only those dates that fall within the current date. For some reason the query returns records that are always a day too late or a day too early. Has anyone got a better way of writing this query? We are on MSSQL 2008r2. The query we have so far is:    select * from mydatabase where    DATEADD( day, -1, CAST(CAST(DateFromYYYY AS varchar) + '-' + CAST(DateFromMM AS varchar) + '-' + CAST(DateFromDD + 1 AS varchar) AS DATETIME) ) <= GETDATE() AND    DATEADD( day, -1, CAST(CAST(DateToYYYY   AS varchar) + '-' + CAST(DateToMM   AS varchar) + '-' + CAST(DateToDD AS varchar) AS DATETIME) ) >= GETDATE()The fields we have are DateFromYYYY, DateFromMM amd DateFromDD and DateToYYYY, DateToMM amd DateToDD and they are varchars. We can't change the fields in the database as this is a legacy system. Basically

Instead of using cfhttp in my CFM file, I like to use jQuery AJAX in JSON to do the query. Should I just simply putting the JS script on the CFM page? Or, do all of the work in a .js file and calling this .js file in the CFM page to display and formatting? Or should I just use the .js file to make the JSON calls and also targeting the IDs in the CFM file for display purposes?Thank you.

I am using Coldfusion 11 and the new tag CFPDFTOHTML. I want to use CFPDFTOHTMLITEM type="header". But I want a different header on the first page than the others. With CFDocument I could do this by using evalAtPrint and <cfif cfdocument._curretpagenumber eq 1></cfif>.Can we do do this with this new tag or is there another way?

Hello, all,I'm trying to automatically update a sort order column after a record has been deleted, so that there are no gaps (yes, I know it still will work with gaps.. my OCD brain cringes at the thought.)For example: UUID        |Headline            |Article                    |Active | SortOrder =================================================================================== ...           This is a headline   This is article text        1       1 ...           Another headline     Different article text      1       2 ...     &n

Hello, all,The project that I'm currently working on has a requirement that is making me cross-eyed.  Customizable queries.  (Rolling eyes)The customer wants the ability to choose which columns will appear in a report.  But the data is normalized across several tables.If the data were all in one table, it'd be a no-brainer.What is an effective and efficient way to create queries on-the-fly across more than one table?  How do I determine which tables (based upon selected columns) will be part of the query?V/r,^_^

Hi,I have mac book pro with osx 10.10.5 version. I am trying to install the Standard Coldfusion Builder 3 but after next it display the following error:Mac OS X platform should be 10.6To Install Standard Adobe ColdFusion Builder 3, You need Mac OS X version 10.8.I have the java version displat after java -version command:java version "1.8.0_31"Java(TM) SE Runtime Environment (build 1.8.0_31-b15)Java HotSpot(TM) 64-Bit Server VM (build 25.31-b07, mixed mode)Coldfusion version:Coldfusion 11 developer versionPlease help me how cani fix this error?

I am trying to put data into my db that is a date string from a .csv file, this is the format it's in from the file: 3/3/1952 (example)this is my query:<cfquery name="importcsv" datasource="#APPLICATION.dataSource#">         INSERT INTO employees (siteID,empstatus,empfirstname,empmiddlename,emplastname,empnickname, emplocation,empgender,empdob,empdoh,empee)         VALUES                   (<CFQUERYPARAM CFSQLTYPE="cf_sql_varchar" VALUE="#trim(listgetAt(i,1))#">,                    <CFQUERYPARAM CFSQLTYPE="cf_sql_varchar" VALUE="#listgetAt(i,2)#">,                    <CFQUERYPARAM CFSQLTYPE="cf_sql_varchar" VALUE="#l

I have two query fields that are created by a case statement. I created a Calculated Field in my report: Data Type Float, Calculation: Nothing, Perform Calculation On: query.Tuition + query.RoomBoard, Initial Value query.Tuition + query.RoomBoard, Reset Field When: Group Changes, Reset Group: IDI get the following error when I run the report: query.Tuition + query.RoomBoard is not a valid ColdFusion expression.What am I doing wrong?

Hi,I have CF10 deployed in Standalone Tomcat. the autoupdates is not working.. wondering how to apply the patch for that instance.. I don't see any hf-updates folder in the exploded war CF10 folder.

On all of my recent installs the default Java File encoding is getting set to ASCIIOn my test box the default is UTF8 – which is what I want, and which according to all the documentation I have found is what CF should be using by default. There are no –D options being added anywhere to override on the test box.  The LANG and all the LOCALE settings are all identical on all boxes (UTF8 settings)I am not finding anything that should be causing CF/Java to pick up ASCII.  From what I can tell the OS is using UTF8 - I am out of ideas of why Java thinks it should pick up ASCIII am on Red Hat 6 – CF 11 patched up to HF7 – 64 bit.  CF - using the default Java that come with it: 1.7.0_51  Any ideas of where else to look?

When I type the URL as www.example.com, it throws the following error message.404 - File or directory not found. The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.but when I type the URL as www.example.com/index.cfm, it works. When I open the URL www.example.com from the server, it throws different error message.HTTP Error 404.17 - Not Found The requested content appears to be script and will not be served by the static file handler.The DefaultDocument in IIS is already set to index.cfm. Please advise what can be the problem and how can I solve this issue.

Is there a document on how to setup clustering with Coldfusion 11 under IIS, I can find plenty of documents on how to set it up under Tomcat, but none for IIS.

This is what it says on the API Basics | KnowledgeOwl site. But it seemed that for it to work, the full URL look something like this.https://app.knowledgeowl.com/api/head/category/5697c6a632131cd740bd3123.json?_authbykey=56a7d8c512331c4058361687&project…So, this is my attempt in using cfhttpparam.<cfhttp url="https://app.knowledgeowl.com/api/head/category/.json?" method="GET" >  <cfhttpparam name="categoryID" value="c6a632131cd740bd3123">  <cfhttpparam name="_authbykey" value="56a7d8c512331c4058361687">   <cfhttpparam name="project_id" value="55c4ffd131231c527e294fe6"></cfhttp>Okay, so I got Error in custom script module error. Any suggestion is much appreciated.

Hello Everyone,I am the webmaster for a school district, and we have a system where parents enter the name of their street and the city they live in.The system then returns which schools their children will go to based on their address.We are running ColdFusion 11 and I recently installed Update 7.After this update was installed this system stopped working properly.Instead of returning unique entries, it returns the same entry multiple times.I did some testing and found that when using ArrayAppend() to add a Structure to an array, that it overwrites all of the entries in the Array to match the entry it just added.here is a section of my code <cfset StreetArray = ArrayNew(1)> <cfloop query="Streets">     <cfset StreetRow['Street'] = STREET_NAME>     <cfset StreetRow['Range'] = LOW_RANGE & ' - ' & HIGH_RANGE>     <cfif EVEN_ODD is "E">           <cfset Street

Hello, all,I know that this question doesn't really belong here, but the General Development forum is dead (I've already asked a question, there - no response), and the smartest users that I interact with are in this forum, anyway.  So, please forgive the audacity of posing this question, here, and please do not move it to another forum.I've been tasked with setting a form up so that a user can check a checkbox that will save the form for re-use, later.  The user can give it a name, and it will appear in a SELECT drop-down on future visits.What I have in mind (and I've done, so far) is to use jQuery.serializeArray() and JSON.stringify() to save the form fields and data as a string in a single column of a database table.  So far, so good.However, upon retrieving said string, posting it back to the browser and using JSON.parse() to make that data into an object, I'm facing some real difficulty in populating the data back into the form.The code that I have, so far, is not t

Will someone provide me information/links to making API calls, parsing, and/or formatting the JSON result in ColdFusion. If there are video tutorials, that'll be awesome.

Hi All,I have a complex query putting multiple tables and views data using union all, such as:<cfquery name="preQry" dbtype="query">select 'groupA' as Grouping, Item as Desc, sum(fieldCalA) as fielTotalfrom tableAgroup by Grouping, Descunion allselect 'groupB' as Grouping, item as Desc, sum(fieldCalA) as fielTotalfrom viewBgroup by Grouping, Desc.....</cfquery>The data looks like:GROUP, DESCRIPTION, TOTAL----------------------------------------------groupA, ItemA, 10groupA, ItemB, 25groupB, ItemC, 30groupB, ItemD, 20groupB, ItemE, 50groupC, itemF, 5....How can I add a summary row in my qoq? so my data can be like:DESCRIPTION, TOTAL--------------------------------groupA, 35   ItemA,10   ItemB, 25groupB, 100  ItemC, 30  ItemD, 20  ItemE, 50groupC, 5  ItemF, 5....Thanks in advance.

CF 7 and CF 8 produce the same error in IIS7.5 on Windows 2008 R2. It works fine in IIS6 on Windows 2003.Code for the normal http website seems fine, but when the code calls https sections of the site, I get this error. The debug error is "Complex object types cannot be converted to simple values" and the detail shows the problem occurs in fbx_fusebox30_CF50.cfm when it reaches:     FB_.ReverseCircuitPath[fusebox.Circuits[aCircuitName]]=aCircuitName;     if (ListLen(fusebox.Circuits[aCircuitName], "/") EQ 1){          fusebox.HomeCircuit=fusebox.Circuits[aCircuitName];

My employer has an web application using CF and we're converting to MS SQL Server 2014 and I'd like to use the Report Builder, and I am a Neophyte in Cold Fusion.Question...can I call that application from CF?Thanks, Kevin

I am trying to filter search results within a solr search built in Coldfusion 10.Apparently, the Coldfusion version of solr does not have the fq= (filter query) attribute, and I'm having trouble figuring out how to tell the search to only include records with a particular variable value.<cfsearch name="getData" collection="MyCollection" criteria="#myCriteria# and custom1:#URL.myVariable#" maxrows="800" status="info" orderby="customvariable_s" contextBytes="80000" contextPassages="1" suggestions="always" />I have stored a particular variable in "custom1" and want to search the collection using the criteria from a form (#myCriteria#), but only include items with the corresponding "custom1" value. Is there any way to do this?