ColdFusion

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

Hello! I am pretty new to CF, so please forgive me.I am trying to call a CF fn within a javascript fn, and it doesnt seem to be working.I am using coldfusion.ajax.submitform() within my javascript. within my ajax call, I am calling a cfc page which contains cfmail code.I am wanting an onlick action (2 actions) to submit a form (this part works) and also send an email (this isnt working).Here is my javascript function where I have included the ajax call (under 'my ajax code'): -------------------------------------------------------------------------------------------------------------------<cfoutput><script type="text/javascript">    //**********************************************************************    //  Function name: ValidateForm    //    Description: Returns true if form is valid false otherwise.    //**********************************************************************  &nb

Dear Sir:  I have an issue that concerns development of coldfusion queries.  I have not had unsurmountable issues with getting SQL (in <cfquery>) to work in order to add, update, delete or join (by union and union all) records.  That said, getting what amounts to be a left outer join just has not worked for me.  Let me state at this time, that I am somewhat accomplished at MS Access and in in every case, including this scenario, I have been successful in getting the output that I seek.  But at some point I see myself moving away from Access and my having to gain expertise in SQL in a non-Coldfusion environment.If you have the time to look over the two attachments, I would appreciate your time.  Note that the table I seek to create via SQL within <cfquery> is correctly dispalyed at the top of the attachment named "Correct Output and Problematic Queries.pdf".  But again, note that this table is based on several queries developed in MS Access

I want to enable a teacher to annotate PDF's that a student has uploaded in my Coldfusion App like Adobe Acrobat X  can do as discussed in the book "Adobe Acrobat X Classroom in a Book: The Document Review Process" without having to download it mark it up with Adobe Acrobat X and then upload the marked up version.  Can Coldfusion so something like this within the application?

I installed 64-bit ColdFusion 10 on a  64-bit Windows 2008 R2 server.  I got error " There was an error accessing this page.  Check logs for more details." after I clicked "Submit Changes" when I tried to change JVM Heap Size, request tunning, setting up mail server, etc.  It doesn't let me to change anything.  I saw the following errors in the logs.coldfusion-out.log:Oct 17, 2013 16:59:37 PM Information [ajp-bio-8012-exec-9] - An error occurred while fetching element from authcache.Oct 17, 2013 16:59:42 PM Information [ajp-bio-8012-exec-1] - Session rotated successfully.Oct 17, 2013 16:59:42 PM Information [ajp-bio-8012-exec-1] - User admin logged in.Oct 17, 2013 16:59:57 PM Warning [ajp-bio-8012-exec-6] - There was an error while verifying the token. Either the session timed out or un-authenticated access is suspected.application.log"Information","ajp-bio-8012-exec-1","10/17/13","16:59:42",,"Session rotated successfully.""Warning","ajp-bio-8012-exec-6","10/17

I just installed a new CF10 J2ee installation on Linux cluster. The cluster shares common storage. Admin password used during the installation does not work. 1. I have tried various browsers but the behaviour is the same. I am accessing the admin interface from my desktop2. I have also tried resetting the password using the  passwordreset.sh script. The script seems to work but the admin interface does not accept the new password and still gives me the invalid userid password error message.3. As a temporary not so secure workaround I changed the  admin.security.enabled” setting in the neo-security.xml file to "flase" .When I enter the admin interface in this fashion and I try to create data sources , when I hit the submit button I get an error message which says "There was an error accessing this page" Check logs for more details. Click here to login (The url shown is the admin interface url)Can someone help me with these two issues please ? I need to be able to move forward

Hi,On CF8.0.1 and CF9.0.1 since applying hotfix:http://kb2.adobe.com/cps/907/cpsid_90784.htmlSelecting verify all connections in CFadminUI Data & Services > Data Sources gives an error:There was an error accessing this page. Check logs for more details.CFadmin UI > Debugging & Logging > Log Files > application.log > reports:There was an error while verifying the token. Either the session timed out or un-authenticated access is suspected.C:\ColdFusion9\runtime\logs\coldfusion-out.log reports:Warning [web-16] - There was an error while verifying the token. Either the session timed out or un-authenticated access is suspected.C:\ColdFusion8\runtime\logs\coldfusion-out.log reports:Warning [jrpp-3] - There was an error while verifying the token. Either the session timed out or un-authenticated access is suspected.Why won't all datasources verify since hotfix?Thanks in advance, Carl.

I installed ColdFusion 10 on a Windows Server 2008 R2 a couple months ago with no problems. I have been testing the server since without it plugged into the network and have had no problems. Yesterday I plugged it into our network and everything worked like a charm with the exception of SMTP. I was troubleshooting SMTP and finally realized this morning that I needed to set the SMTP in ColdFusion. I tried to login to the ColdFusion Administrator and it said it was an "Incorrect Password". I was able to successfully login to the Admin yesterday multiple times but not today. I have run the passwordreset.bat and selected "1" then typed in the new password and confirmed the password then the popup went away. I restarted the ColdFusion service then closed the browser and reopened the browser and typed the password and still received the "Incorrect Password". I also went into the "neo-security.xml" file and changed the "admin.security.enabled" boolean value from "true" to "false" to get into