Questions

I know that in past versions of CF and IIS, I've been able to redirect an entire folder such that 404 request to www.domain.edu/folder/filename.cfm would simply redirect.  However now it seems like if the request is for a CFM, IIS ignores this, and hands it off to ColdFusion's 404 template, completely bypassing the redirect directive in the web.config for a given directory.  This is creating more 404's than previously because we had actually successfully managed them using folder redirects in the IIS admin tool.I wonder if others have suggestions on how to handle.  I know that another way is simply to "sniff" for the 404 path that is passed to the CF 404 template.  That's proved to be challenging as well, since the latest version of CF doesn't seem to carry through that query string/referer to the 404 page.I'd rather handle it all in IIS and I wonder if anyone has successfully done this with CF 10 and IIS 7.5 or 8.0?Thank you!Chuck Wyatt

Hello, everyone, I have an Oracle 10g database, and in it is a table where the first column is a VARCHAR 36 and contains Oracle generated UIDs. I am trying to run a SELECT query that gets a corresponding (date 19)  where the UID = '{ a 36 character long UID}'.  I am getting the  ORA-01722 invalid number error message. SELECT s.ENTERED_DATEFROM dsp.status sWHERE s.UID = '4a29d12025012995c231f18eb7704009'I've tried using TO_CHAR() and CAST() to no avail.  What am I missing? V/r, ^_^

We are upgrading from coldfusion 8 to 10. Internally we were using java function to to get the data. In java function we have a resultset object, if we assign this resultset value to Querytable variable, we are getting below error. This code was working fine in coldfusion 8.  Detail    This exception is usually caused by service startup failure. Check your server configuration. Message    The Runtime service is not available. StackTrace    coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Runtime service is not available. at coldfusion.server.ServiceFactory.getRuntimeService(ServiceFactory.java:117) at coldfusion.runtime.RequestMonitor.<clinit>(RequestMonitor.java:14) at coldfusion.sql.QueryTable.populate(QueryTable.java:358) at coldfusion.sql.QueryTable.populate(QueryTable.java:283) at coldfusion.sql.QueryTable.<init>(QueryTable.java:96) at com.myCompany.myClass.myFunct(myClass.java:627) at   Here is t

According to http://activemq.apache.org/tomcat.html it is possible to "Manually integrating Tomcat and ActiveMQ".Since CF10 uses Tomcat, is it possible to embed ActiveMQ in CF10?  I use standard edition.Thanks you!

I need to be able to use a keyword entered by a user to do a full text search of a collection and then limit the outpout by parameters in a database.

Hi,Does anyone have the code (CFSCRIPT/CFML) to restart a CF10 instance?The code that worked for us in CF 7 and 8 no longer works on v10.Regards,Mark

I'm trying to write a webm dataURL to a file using CFFILE.  Do I use ToBase64 first and pass it to CFFILE output? I tried this but the resulting video file won't play.  It has a file size but won't play. I'm using Ajax to send the dataURL string to my ctc function.  How do I write a video to a file? The dataURL mime type is webm.<cfset vid64=#ToBase64(arguments.dataUrl)#><cffile action="write" output="#vid64#" file="#videopath#\#videoString#"> ThanksDon

I have a CF 10 report with an Excel Output format. One of my columns needs to stretch. When I set the Fromatting "Stretch with Over to True" and the Print Control "Position Type" to Floating and the "Stretch Type to Relative to Band Height" for all the fields on my detail I get an exxtra line in my excel output when there is an overflow condition. I am including an image of the output.What am I missing?Thanks

What is the latest version of SQL Server which ColdFusion 7 supports? For example can Cold Fusion 7 connect to SQL Server 2012 or 2008 without any problem? Thanks

Can anybody help tell me how to delete a ftp connection or at least edit it in Thunder Beta?Thanks

How do I configure ColdFusion5 to use J2EE session identifiers of CF_ID and CF_TOKEN?  I have instructions on how to do this on ColdFusion9 from http://helpx.adobe.com/coldfusion/kb/predictable-cookie-session-ids-reported.html. But when following these instuctions in ColdFusion5 the J2EE Session Variable option is not available.  Is this option in another place? or does this not exsist in ColdFusion5?  Please Help.

Hi all – I have a dumb question – I’m not the worlds best scripter…I’ve got a ColdFusion page, with an element in it that is either flash, or HTML5.I need a way to detect what is happening client-side and push the client to either the Flash element, or the HTML element (or a s “you’re WAY behind the times” element if neither).I’ve found, and used, modernizr, but it does things the wrong way round for me.  I need to direct my clients to flash 1st, then HTML5, then the sorry page.  Modernizr only gives me HTML 5 first then Flash, and this isn’t working for me.  the flash element is the preferred element.   I’ve screwed around with trying to “swap out” modernizr, but my glasses aren’t thick enough.  Thus, I (roughly) need something that does this:<cfif “flash”>Direct them to flash page<cfelseif “html5”>Direct them to HTML 5 page<cfelse>So, how is life in the 18th century?</cfif>Help, please..  It does not have to be CFM, it can be

I need to recreate the .htaccess file whenever the page structure changes.I have wrapped the cf code with cfsavecontent, then write the cfsavecontent variable using cffile.The results produce a file that just reproduces my cf code, not the net output of that code.Any suggestions?

Hi,Several 7.0.2 links are broken for downloads on http://www.adobe.com/support/security/bulletins/apsb09-12.htmlTry the "CVE-2009-1872 and CVE-2009-1877 Hotfix for ColdFusion 7.0.2" link.  😞Any suggestions?Adobe, can you fix?Thanks for any help!-Chris

Hi everyone,I'm going thru and updating all our aging MX7 installs at work, with the latest hotfixes and patches.That has all gone fine, but the two hotfixes that I need seems to no longer be available, and I am wondering if any of you have the files?This is the link to hotfix I am after, specifically,CVE-2009-1872 and CVE-2009-1877 Hotfix for ColdFusion 7.0.2CVE-2009-1875 Hotfix for ColdFusion 7.0.2http://www.adobe.com/support/security/bulletins/apsb09-12.htmlThe links for the hotfixes are not working.http://download.macromedia.com/pub/coldfusion/updates/702/7_0_2.ziphttp://download.macromedia.com/pub/coldfusion/updates/702/CF7.0.2.zipDo any of you have zip files floating around, or is someone from Adobe able to fix the links?I realise it's a very old hotfix, and support for it has probably stopped, but I figured I may as well try to find it Thanks heaps.Leith

I have a query (yes is very long,it works, trying to make it better ).DECLARE @today DATETIMESET @today = '2014-04-13'    ;with CTE as(          Select d.csedept_name,d.csedept_id, Average = CASE WHEN d.csedept_question5 IS NULL          THEN (Select AVG(((cast(c.rating1 as Float)+ cast(c.rating2 as Float)+cast (c.rating3 as Float)+cast(c.rating4 as Float))/4))                    From intranet.dbo.CSEReduxResponses c                    Where c.employeedept = d.csedept_id                    AND c.execoffice_status > 0               &nbsp

I have this code:<h1><cfoutput>#self#</cfoutput></h1><cfquery datasource="Intranet" name="month_data">  select * from CSEReduxResponses where status=1 and execoffice_status=0    AND MONTH([approveddate]) = MONTH(GETDATE())   </cfquery><cfquery datasource ="Intranet" name="GetDeptSubmissions">SELECT * FROM CSEReduxResponses</cfquery><cfquery dbtype="query" name="GetApproved">SELECT * FROM GetDeptSubmissions WHERE status = 1 AND execoffice_status = 1</cfquery><cfquery dbtype="query" name="GetDenied">SELECT * FROM GetDeptSubmissions WHERE status = 1 AND execoffice_status = 2</cfquery><cfif month_data.RecordCount gt 0><cfoutput>          <h2>Comments / Ratings Administration</h2>          <div>              

The instructions for CVE-2009-1872, CVE-2009-1877 located here:http://download.macromedia.com/pub/coldfusion/updates/ReadMe_1872_1877.txtIt says clearly on step 4 that:"4) From the downloaded CFIDE copy cf_debugFr.cfm to <cfwebroot>\CFIDE\debug\ and _logintowizard.cfm to <cfwebroot>\CFIDE\wizards\common."I have downloaded the archive in question twice from:http://download.macromedia.com/pub/coldfusion/updates/702/CF7.0.2.zipand the file is missing the \wizards\ folder and of course the _logintowizard.cfm file. Adobe, what do I do here?

I am creating a report in CF 10 report builder. I have a function that returns two separate fields in one variable I need to have the two fields returned separately, my output is an excel worksheet. Any advise will be greatly appreciated.

Hello, everyone.I'm trying to learn the CFEXCHANGECONNECTION and CFEXCHANGECONTACT tags, and I'm having a bit of an issue.When I first started playing around with it, I was getting error messages that the connection couldn't be formed because the Exchange server only accepts https connections, so I set the protocol to https.Then I was getting an error message regarding the "cert not installed in CF server", so I managed to get a copy of the SSL cert (DER format .cer file) and followed instructions on how to import it into the JVM that CF uses.I'm still getting the error saying that the cert isn't installed in CF server.  Any suggestions?V/r,^_^

Hi all,I was detecting browser for ie by using #CGI.HTTP_USER_AGENT# CONTAINS "MSIE" this.Looks like internet explorer 11 does not contain MSIE. How can i detect ie 11 by using the same method?

I'm lost. I am attempting to pass a FORMFIELD-parameter via the DELETE-method to a REST-function using script language. I want to delete a resource. I get "Method not allowed", only "GET,OPTIONS,HEAD", so the DELETE-method is not understood. I would apprechiate any meaningful input.---------(service call)-------------form.CategoryIDDelete = "X,Y,Z"httpSvc = new http(); httpSvc.setMethod("DELETE"); httpSvc.setCharset("utf-8");httpSvc.addParam(type="formfield", name="CategoryIDDelete", value="#FORM.CategoryIDDelete#"); httpSvc.setUrl("http://data.myDomain.net/rest/restService/categories");  res = httpSvc.send().getPrefix();writeDump(res);writeDump(FORM);------------------------------------...calls the rest service function in the registred REST component. Here I call CategoryIDDelete "catIDs".---------(service function)---------remote Array function delCategory(string catIDs restArgSource="FORM") httpMethod="DELETE" restpath="{catIDs}" produces="application/json" {     var

When I log in to Adobe, it says I have no products registered, but I need to find my CF serial # which was registered. What do I do?

How can i create a new link on a page when a submit (button) is click? what i want to do is when that button is click then it will run that script(cfm file) and will create a link on the same page.so when <cfinput type="Submit" name="SubmitForm" value="Submit">(from answers.cfm)is click it will run the file in respnds.cfm and create a link in answers.cfm when you can click it and the respnds.cfm file will come up. any suggestion or maybe a article online (which i havent been able to find ) will help.thanks

Hello EverybodyI'm getting a very strange situation.I'm working to migrate a Cold Fusion site from v8 to v10. Into new v10 environment I'm getting an error that is not present into v8 version. The code is the same.Basically, I have a <cfform> with a dinamic number of <cfinput>. These <cfinput> are generating looping a <CFQUERY>.In total I have 42 rows. If I force the limit of the rows to 32, the form is correctly submitted to an "action" destination file that is inserting data into a database. If I force the limit of the rows to 33, I get an error 500 - "The page you are trying to access can not be displayed. Please try again or notify the administrator". The issue is not related to data, I have already checked for it.Everytimes the application should update into database ALL rows present on the form.===============================THIS IS THE FILE WITH CFFORM===============================<CFSET HttpName = "http:" & #Application.RootDir#><cfinclude