Questions

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

Hi,Below are the details :High Level Architecture Its 3-Tier architecture consists of Web Layer, Application Layer, Database Layer. However, the Web & Application layer are hosted on the same physical server. The Web Layer consists of Apache 2.2.24 which will acts as a reverse-proxy. All requests are directed to Application layer. The Application layer consists of CF 10  Enterprise version (10,0,13,287689 )  which integrated with Content Management Server (MURA 6.1) through MURA plugin. The Database layer – Oracle 11g. Hosted on the dedicated physical server. Recently, we upgraded the existing Apache-CF9 environment to Apache-CF10 (& MURA) to support our business needs. The website hosted on the CF10 environment experienced severe performance issues when launched to customers. The users experienced slowness ranging from 25 seconds & the CPU usage on the web-application server reached 95% consistent. After initial investigation & tuning options, the CPU usage w

I am trying to use cfexecute to run a video conversion application. The application is installed at:C:\Program Files\SourceTec\vee\vee.exeThe video I want to convert is stored in the temp directory as returned by GetTempDirectory() which in this case is:C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\I've tried a wide range of different ways to call this program and whenever it seems like I'm getting close, I get the following error:Error: Failed to open the source file "C:\ColdFusion9\runtime\bin\vee".I don't have any files in that directory and am not attempting to access it explicitly but ColdFusion keeps trying to find something in that directory and I don't understand why.The following code works:<cfexecute name="C:\Program Files\SourceTec\vee\vee.exe" arguments="vee -v" timeout="300" variable="results"></cfexecute>...but all it does is display the version number of the video encoder engine: Version: 3.2 (Build 322)When running this code:<cfexe

I have thsi code.<cfquery datasource ="Intranet" name="GetDeptSubmissions">SELECT * FROM CSEReduxResponses</cfquery><cfquery dbtype="query" name="GetPending">SELECT * FROM GetDeptSubmissions WHERE status = 1 AND execoffice_status = 0</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><cfoutput>          <h2>Comments / Ratings Administration</h2>          <div>                    <div class="display_count pending_outer">                 &nbsp

Hi,I'm trying to get a zip file from a NET web service but I get this error:Cannot perform web service invocation GetPolicy.The fault returned when invoking the web service operation is:org.apache.axis2.AxisFault: Must Understand check failed for header http://tempuri.org/ : FileName at org.apache.axis2.engine.AxisEngine.checkMustUnderstand(AxisEngine.java:105) at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:171) at org.apache.axis2.description.OutInAxisOperationClient.handleResponse(OutInAxisOperation.java:364) at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:421) at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:229) at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165) at org.tempuri.EmissionServiceStub.getPolicy(EmissionServiceStub.java:222) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces

Being new to coldfusin i have some question about this query .why do we need the first select (joinquery) ? is this a left join , just by looking at it it looks weird?Is there other ways to do letf join in coldfusion?<cfquery name="joinQuery" dbtype="query" >SELECT *FROM GetCardlyticsRedemptionStatsWHERE GetCardlyticsRedemptionStats.SourceCustomerIDINT = -1</cfquery><cfset QueryAddRow(joinQuery) /><cfquery name="CombineBothTables0" dbtype="query" >SELECT *FROM  GetCardlyticsID, GetCardlyticsRedemptionStatsWHERE GetCardlyticsRedemptionStats.SourceCustomerIDINT = GetCardlyticsID.cardlyticscustomerid UNIONSELECT GetCardlyticsID.*, joinQuery.*FROM GetCardlyticsID, joinQueryWHERE GetCardlyticsID.cardlyticscustomerid NOT IN (#ValueList(GetCardlyticsRedemptionStats.SourceCustomerIDINT)#)</cfquery>

i want to get the max of this query.<cfquery datasource="intranet" name="getMaxstars">select submitterdept, sum((rating1+rating2+rating3+rating4+rating5)/5)/count(1) average_rating  from CSEReduxResponses  group by submitterdept  order by 2 desc;  </cfquery><cfset myarray=[submitterdept] ><cfoutput  query="getMaxstars"><h1>#ArrayMax(myarray)#</h1></cfoutput>this code doesnt work. the query does, it will output 3 rows , so from this rows i want to getthe max of submitterdept, is there a different way to do this? with the code abobe i get  'Variable SUBMITTERDEPT is undefined.'

My Company using Coldfusion to built an report platform and recently I upgrade our Coldfusion 7MX with Windows Server 2003 to Coldfusion 10 Enterprise with Windosw Server 2008 R2.I copy the Code from the Old server to the new one, but I met the problem I couldn’t solve.We have a repost that can enter, modify and view our SRM that has Chinese Character display request. Chinese character was display without problem when the system in the old server. which look like following.once I move the code into the new server, I got the problem with Chinese Character as following.This report pulling the data from SQL2005 with Windows Server 2003 R2. Coldfusion code code was same and both version is access to the same database.I ran all of the update included to install the windows MUI for Chinese character into the new server,  but I still can't get the character display correctly.I can view the chinese character website without issue but only to display in the report.I contact with Microsoft

get data from differnt table?I have been looking around all over google and I just can find a good example of a join queryfor what i want to do.lets say you have two tables i created for example, from same server.create table table_a (employee_id int, stars int);insert into table_a values (1, 1);insert into table_a values (1, 0);insert into table_a values (1, 1);insert into table_a values (1, 0);insert into table_a values (2, 1);insert into table_a values (3, 1);insert into table_a values (2, 1);insert into table_a values (2, 1);create table table_b (employee_id_number int, dept_name varchar(25));insert into table_b values (1, 'deptone');insert into table_b values (2, 'depttwo');insert into table_b values (3, 'deptthree');insert into table_b values (4, 'deptfour');I want to be able to ouput the max which i have been able to do with this below code:(this doesnt use the tables above)<cfquery datasource="Intranet" name="getMaxstars">         &

We are upgrading to IIS7/CF10 from IIS6/CF7. We run several subdomains and CFID/CFTOKEN cookies issued by the domain are taking precedence over the subdomain cookies we're issuing. The result is that users are getting a new session on every request. I can clear the domain cookies and everything works fine. Ironically, the main domain is no longer using CFID/CFTOKEN and have switched to using JSESSIONID. That's great because we would no longer have a conflict with them, but the users can't seem to clear their domain cookies because of security settings on their internal network workstations. Is there some way to force CF to request only the subdomain cookies and ignore the domain cookies, or is this an IIS7 issue?

hi guys,Do you use any tools to handle your coldfusion application testing?if yes, what do you use?I'm trying to find something that i can for testing that will not involve the developer team

I have a query that i get the MAX number of "stars"    <cfquery datasource="Intranet" name="getMaxstars">    SELECT   TOP (1) WITH TIES employee, SUM(execoffice_status) AS 'total_max'    FROM     CSEReduxResponses    GROUP BY employee    ORDER BY 'total_max' DESC    </cfquery >I also have a different table EMPLOYEE. Table EMPLOYEE also comes from a different datasource="phonelist". Where in this table I have the employees first_name and last_name columns , they share the same column emp_id.How can I output the employee first_name and last_name using the other table. What I eventually I want to do it output:max:john doe - stars = 4

Hi,I am using <cfdocument format="PDF">, within my <cfdocumentsection> I call another .cfm file which contains   <cftextarea label="example" disabled="disabled" name="somename" wrap="virtual" message="Your qualifications are restricted to 500 characters" value="#getdata.stuff#" required="no" rows="3" cols="80" maxlength="500" validate="maxlength" validateAt="onBlur"  />If this textarea contains more then about 50 characters the text dosen't appeare on the pdf.If the textarea contains just a few words it works fine.Would you have any idea what this problem could be?Thanks,Suzanne