Questions

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

hello,Is it possible to download Adobe coldFusion as a zip file? Our corporate firewall will not allow for direct download of an executable MIME type.Thanks

I am trying to install Cold Fusion 5 on a Windows 7 platform in a XP Professional Virtual Machine.  The software installed with no issues.  However, I have run into a problem with configuring the software.It has been 8 years since I last installed the software (on a Winows 2000 Professional platform) as the part of a certificate program, which I completed successfully and with many kudos at the time.When I try to "browse a .cfm from my old class project ", in ColdFusion Studio, it says I need to do Server Development Mapping.I log into the CF Admiistrator and enter the logical name.  But when I try to browse to retreive the physical location, I dont see the directory list, but instead the icon for "Not Found".Can this software be loaded in a Virtual Machine environment, and if so, what do I need to do to remedy my problem?

My server was recently hacked and I'm looking for malicious code the hacker may have left behind.  I see a number of exe files in the CFIDE folder that were created during the period the server was exposed.  Can you help me know which ones I should quarantine by giving me a list of the one that are supposed to be in that folder?  I'm using ColdFusion 9.  Thanks.

Functionality :     * Create around 40 PDF's using CFPDFFORM tag (each document is 2 pages only)     * Merge all the files using CFPDFProblem:     * CFPDF  merges the document but the first (or last)  document repeated 40 times !     * Tried flattening and merge later, flattening removes all the data populated using CFPDFFORM( i dont want flatten the file first of all)Any help is appreciated

Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1 I keep getting this error everytime I try to log into my inventory database I set up.  I cn not find it anywhere in order to view or change the syntax.  Please help!

I am having a hard time getting my autosuggest to work. I have a cfinput where a person can type in a last name. I then want to return the full name and employee ID of the person and bind them to two different cfinputs. Here is my cfc:<cfcomponent output="false">            <cffunction name="getPerson" access="remote" returntype="array">                    <cfargument name="search" type="any" required="false" default="">                        <!--- Define variables --->                       <cfset var data = "">  <cfset var result = ArrayNew(2)>  <cfset var i=0>      &n