ColdFusion

I am creating an admin section now.  Should I go about this differently?  I have gone through the learncfinaweek tutorials and copied the back end admin from that site and pasted it in for the new site.  Is there more to connect than I am thinking to just paste in an admin section?  I am thinking if I changed the adminPath to point to CoreBelief(the new site), it should have enough code to at least display the styling.  It doesn't give an error, only no css displayed yet.I can put the css and javascript up there if it will be helpful in finding the solution.  I was thinking it might be in the Application.cfc.Here is how far it gets with the Application.cfc file narrowed:Debugging Information ColdFusion Server Developer11,0,07,296330 Template /CoreBelief/admin/login.cfm Time Stamp 25-Jan-16 03:32 PM Locale English (US) User Agent Mozilla/5.0 (Windows NT 10.0; WOW64; rv:43.0) Gecko/20100101 Firefox/43.0 Remote IP 0:0:0:0:0:0:0:1 Host Name 0:0:0:0:0:0:0:1Exec

We need to purchase a Coldfusion 11 license shortly and looking to know if Coldfusion 11 Standard edition will be OK for what we are running:We have 3 websites running on a single server with spec:Windows 2008 Server R2 Enterprise 64-bitProcessor: Intel(R) Xeon(R) CPU E3-1230 V2 @3.20Ghz32 GB Ram2TB HDDWe are currently running Coldfusion 11 Trial (Enterprise) which expires soon.Our 3 sites mostly use:MySQL 5 Datasourcescflogin, cfloginuser, GetAuthUser, GetUserRoles, IsUserInAnyRole, IsUserLoggedIn etc. security functionscffileupload functionCustom Tagscfmail - need to be able to Log all E-mail messages sent by ColdFusionDaily running of scheduled tasksExcel Spreadsheet creation with cfcontentwe also need to be able to change settings in coldfusion administrator mainly:(1) Default ScriptSrc Directory, Maximum size of post data (for large file uploads of 1gb)  & Request Throttle Memory.will 'Request Size Limits' ('Settings' section) be greyed out in Standard edition as well as

On my production server (Windows Server 2008 R2 Web edition 64 bit, 4 GB RAM, Coldfusion 9.0.1 32 bit) every 4-5 days all websites aren't available, the error message is:ERROR 500:ROOT CAUSE:coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Metrics service is not available.        at coldfusion.server.ServiceFactory.getMetricsService(ServiceFactory.java:159)        at coldfusion.CfmServlet.processTimeout(CfmServlet.java:296)        at coldfusion.CfmServlet.service(CfmServlet.java:216)        at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)        at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)        at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)      

Hello, all,I have a query that includes two UNIONS and many columns.At the end, if I use ORDER BY lname ASC, fname ASC it works great.If, however, I use ORDER BY lower(lname) ASC, lower(fname) ASC it breaks.I tried ORDER BY nlssort(lname) ASC, nlssort(fname) ASC and that breaks, too.These are Last Name and First Name columns.  English.  The only non-letter character that should be in either column is an apostrophe (for names like O'Brien, etc.)  Even then, the nlssort should work.But in all cases where it breaks, I get an "ORA-01785: ORDER BY item must be the number of a SELECT-list expression" error message.The reason I'm trying to use lower() or nlssort() is because some of the names were not entered proper-case, and I want to sort alphabetically, not alphabetically upper then alphabetically lower (as seems to be Oracle default.) Default:     Andy                 &n

Hi Folks,When a Standard license is applied to CF installation the values displayed in CFadmin for Request Tuning do not match what is defined in ColdFusion11\cfusion\lib\neo-runtime.xmlWhy is there a discrepancy in CF11 Standard graphic display of CF runtime settings? EG Server Settings > Request Tuning >Maximum number of simultaneous Template requests displays 400 when ColdFusion11\cfusion\lib\neo-runtime.xml value parameter says <var name='requestLimit'><number>25.0</number>Work flow:Before CF Standard key is applied display values match neo-runtime.xmlCF currently without a licenseInstall CF Standard license keyNo changes applied to CF settings Request Tuning now displaysThanks in advance, Carl.

Does anyone have experience using ColdFusion with file geodatabases?Is is possible? Any issues?

Colfusion11Windows 7 UltimateWhen I type in "http://www.powersuasion.com", the browser goes to "http://www.powersuasion.com/cfwebstore/index.cfm?CFID=9230823&CFTOKEN=bea0150d24112df9-628636B4-DD5A-01B1-BA1401CD116DCB9C&redirect=yes" and loads index.cfm in the root (wwwroot).  This is confirmed all four browsers.When the page opens, only part of my site opens and there is recursive process where the quote at the top loops through ad infinitum, as if the page is loading over and over again.When I remove the string, "CFID=9149279&CFTOKEN=568539d825ed7343-EE4F3A77-DC7A-0E16-CE2B58AD730DB6BB" from the address, the  address is "http://www.powersuasion.com/cfwebstore/index.cfm?&redirect=yes" and the site loads properly.I cannot figure where this "CFID..." string comes from and how to get rid of it when I call for "www.powersuasion.com".I tried to find that incorrect address in the index.cfm's, but could not find it there.I downloaded the whole wwwroot and then ran a

Hi,If I create a redirect using something like "<cflocation url="index.cfm" addtoken="false" statuscode="301">", it will redirect me to /jakarta/index.cfm.I've been able to replicate this with two different servers, both in a folder with a blank application.cfm file, so I know it doesn't have anything to do with that. My quick fix was to just not reference url's this way and use the fully qualified /folder/index.cfm. This works well, however this doesn't fix an even bigger problem. Apparently the cfide/administrator login uses this same type of redirect, and when I log into the ColdFusion Administrator I get redirected to /Jakarta/index.cfm.If it helps, I'm on ColdFusion 11. Any ideas on what could cause this?Thanks,Paul

It looks like one of the date and time from an API and I retrieving from uses eastern standard time. I wanted to convert that into time. I was looking at this article, Converting Dates Across Time Zones Using ColdFusion And Java, and it was looking way to complicated for me. Wasn't there something simple in ColdFusion like the following?<cfset localDatetime= DateConvert("utc2Local", easternDateTime)>

Hello everyone,I recently inherited an application running ColdFusion MX7 Version: 7,0,0,91690This application was moved to a Windows 2008 R2 Server last year.  Ever since then we've been getting an intermittent error in the Windows Application Event Log.   The error is generated when a user is navigating through the application, clicks on something and gets a "This page can't be displayed" in IE.The error details are below.  It's IIS 7.5 on Windows 2008 R2.  The Application Pool is the DefaultAppPool.  The Identity is set to "ApplicationPoolIdentity".  This problem is intermittent.   But when it happens it's a huge inconvenience for users.  Now that I've inherited this I'm expected to figure it out (the previous owner never bothered to look into it).  Any help/guidance is appreciated.   Many thanks!    Faulting application name: w3wp.exe, version: 7.5.7601.17514, time stamp: 0x4ce7a5f8Faulting module name:

Can't get CF11 to download free trial for students.  Anyone having the same problem with Adobe's site?

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.