ColdFusion

I have a union query like this that gets info from 2 different tablesLike this  <cfquery name="getpeople"   datasource="#request.dsn#"    > SELECT  ID,CityName,  SUM(people) AS sump FROM table 1 GROUP by ID,CityNameUNION   SELECT  ID,CityName,  SUM(people) AS sump FROM table 2GROUP by ID,CityNameORDER BY SUM(people) </cfquery>So what I want is the sums from both tables but what I get is the sums of each table.For example I get ID-CityName-sump1- New York -31-New York- 42-Chicago -52-Chicago -6What I want isID-CityName-sump1-New York- 72-Chicago -11Do I need to do another query after the union query?

Hello,i am parsing an xml file by using a CFLoop. Some rows in the file do not contain every element. What is the best way to check if an element exists?My current code looks something like the following:<cfloop from="1" to="#arrayLen(cfData)#" index="i">     #cfData["SpecialId"]#     #cfData["ImageUrl"]#</cfloop>For some rows, ImageUrl exists, but it doesnt in others. When running the code, i received the following error:Element ImageUrl is undefined in a CFML structure referenced as part of an expression.I tried the following:<cfloop from="1" to="#arrayLen(cfData)#" index="i">     #cfData["SpecialId"]#     <cfif structKeyExists(cfData,"ImageUrl")>          null image     <cfelse>          #cfData["ImageUrl"]#     </cfif></cfloop>However

Hi, do all versions of Elements have a lens correction tool like the one in lightroom 3?

I want to make an advent calender. Is it possible to make it so you can put it on facebook? Like other companies does with there advent calendars. I will not have a product in each window but an image. And I want the user to be able to open the window on the day it should be open. Like an ordinary calendar but digital. How do you do it? Are there some good tutorials on how to do it?

Just purchased CF 10 and cannot get it working on the site.  We currently use CF9 on Windows Server 2003 (32bit).  We are installing CF10 (32) on Windows Server 2008 (32).  Have tried multiple times and have researched and asked the community and have tried all suggested options.  Here’s where I'm at: IIS configured with all required rolesCF10 Application service running under domain mgrAll CF10 updates installed in correct sequence (8-12)Just released CF10 mandatory update installed (released 11/21/13)CF Connector works fineAll Handler mappings for CF types show properly as enabled and inherited in all sub folders from 'Default Web Site'The results are that CFIDE administrator works fine.  CFM pages in root web parse fine too.  CFM pages do not parse from subdirectories (Folders within wwwroot other than CFIDE).  We receive the ‘Internet Explorer cannot display the webpage’ error within IE on these CFM pages.For testing, I used the iisstart.hm and sa

Hi I am using a simple nsert statement .The insert statement picks a variable from the form and inserts it into the database I have no loops in the page the code is : <cfif isdefined("Form.Category")> <cfquery name="InsertCat" datasource="ShoppingCart"> Insert Into ShoppingMstCategory(Category)Values '#Form.Category#') </cfquery> </cfif> The insert runs twice on its own. Though if I use Query analyser to insert the statement only inserts once. am I missing something. I am using CF 10

I'm trying to use the following code in application.cfc to allow a meaningful error message for the user (dsp_error.cfm).It isn't practicle to wrap every query in in the app try/catch code; too little time or money for the project.Is there a way to get the SQLSTATE variable that appears in the debugging info the user sees without this code, the part that shows the actual SQL that is being sent to the Oracle server?The SQLSTATE usually helps me pinpoint how I failed to test/require proper values from the poor user.  Here's the code from application.cfc as I have it now:<cferror type="EXCEPTION" template="dsp_error.cfm">  <cffunction name="onError" returnType="void" output="true">  <cfargument name="Exception" required=true type="any"/>  <cfargument type="String" name = "EventName" required=true/>  <cfset admin_email="Randy.farthing@austintexas.gov; Jacque.driskell@austintexas.gov; lawrence.willis@austintexas.gov;">  <!---&nb

can i install elements 12 on more than 1 pc

Hello,We are currently looking for ColdFusion training on the Administration side of ColdFusion. Does anyone know of a reputable training class that is face to face that we could look into. I researched a few Authorized Training Centers and did not find any classes that were scheduled. Things we would like to see in the course is Installing CF, Upgrading CF, Securing the Server and overall troubleshooting of the ColdFusion application. The type of training we are looking for is not geared for the developer, but more toward the individuals that will be managing the server etc. Thanks,Barry

CF 10 installed fine and CFIDE/Admin ran ok, however, other sites did not invoke CF10 even though 'all' was specified in the install and all IIS options were enabled.  Used the connector to remove the 'all' entry, but now cannot add it back.  What's the fix?

Windows 2008 R2ColdFusion 10Mandatory UpdateUpdate 1Update 2Webroot = inetpub\wwwroot\We installed and configured ColdFusion 10 a few weeks ago on a new server.  I put a few CFM pages in my webroot and they served up fine.  Still do! Administrator is serving up fine as well.  However, subdirectories of my webroot are not being processed by ColdFusion.  It won't serve up CFM pages.We've compared settings, subdirectories are set to inherit from the parent webroot.  Subdirectories are serving HTM pages and the CFM pages are showing up as HTM pages, unprocessed.I do not know if this was occuring prior to the updates.Any help would be greatly appreciated.  I need to transition as soon as possible.Thanks!

Hi there,I want an upload button for files in my form. Is this possible and if so how do I get it there?THank you so far.

I am a non-techic trying to fix something for work. Your help is really appreciated.I have a form with checkboxes (4 check boxes). Everything sumbits fine. SQL db is updated perfectly and data is displayed on webpage w/o any problem. However when I go to edit an entry, on the edit form, (if more then one checkbox were selected oringally), non of the checkboxes are checked. If only one checkbox was selected orinally, that checkbox is selected. What am I missing? I know I am suppose to use loop to get all checked checkbox values, but I have no idea how. Here is my code so far.<input type="checkbox" name="colors" value="red" <cfif #getResultSet.colors# EQ "red">checked</cfif>>red     <input type="checkbox" name="colors" value="blue" OR<cfif #getResultSet.colors# EQ "blue">checked</cfif>>blue    <input type="checkbox" name="colors" value="green" OR<cfif #getResultSet.colors# EQ "green"></cfif>>green  

Hi,I'm building a website for selling boats, I would like to open for people to be able to put in their boats for sale and that this information they are putting in automatically comes out on the website.I'm building the site in dreamweaver and was thinking about using the form function. Also, I'm unsure if coldfusion is the cheapest and best way to do this. I also would like to be able to verify that input information is ok to go on website.Any ideas, help?Thanks!

I'm trying to use RTMP with Coldfusion 10 and the embedded livecycle ES.  The other channels and endpointshave been working fine, but when the server starts up I get an error complaining that the endpoint cannot befound for the cf-rtmp channel.   I'm using the standard setup with no special configuration. The AMF channel, polling channel, etc. work just fine, and there are no complaintsabout those channels or endpoints when the server starts up.This is the error in the logs when the server starts up: INFO: ColdFusionStartUpServlet: ColdFusion: VM version = 23.7-b01java.lang.NullPointerException          at coldfusion.server.jrun4.metrics.SimpleLoadMetric.run(SimpleLoadMetric.java:157)          at coldfusion.scheduling.ThreadPool.run(ThreadPool.java:211)          at coldfusion.scheduling.WorkerThread.run(WorkerThread.java:71)Nov 21, 2013 9

Hi All,Here is my problem,I have a user defined function, which will give me the output as " table.column = <cfqueryparam cfsqltype = 'cf_sql_varchar' value = 'test'>; but when i pass this as my where clause in the query.I always get missing experssion (00936) error.When I ON the debug information in CF, I copied the query its running;any help would be highly appreciated.I have tried replacing this double quotes with single quotes using Rereplace and replace function;  tried preservesinglequotes(); all are returning the same error.. May be I'm missing something.THe below is the query formed; and its the one I get when I on the debug information (sql)SELECT *  FROM  SHOP_FINDINGS  WHERE   ROWNUM<=20 AND (OPER_NAME = <cfqueryparam cfsqltype='CF_SQL_VARCHAR' value='IN STOCK'> )I m using CF 9 and Apache server.

So, I'm having trouble figuring this out, and I haven't found an answer online.  Hoping someone here has tried something similar.I'd like to figure out how to use the Coldfusion Encrypt function so that it generates the same binary value as MySql AES_ENCRYPT.  Similarly, how can I use Coldfusion Decrypt to decrypt values generated by AES_ENCRYPT?I've tried:Decrypt( QUERYCOLUMN, "AES", "hex")Decrypt( toBase64(QUERYCOLUMN), thisKey.getKey(), "AES", "hex")Decrypt( toString(toBase64(QUERYCOLUMN)), thisKey.getKey(), "AES", "hex")Always returns empty string.Thoughts?

I've tried this on a couple of machines and I continue to get an error stating "ColdFusion 9 Installer" is damaged and can't be opened.  There are a couple error messages in the console, but nothing that's immediately obvious to me.  Any help would be greatly appreciated.11/19/13 2:58:29.114 PM com.apple.launchd.peruser.501[287]: ([0x0-0x106106].ColdFusion 9 Installer[25065]) Job failed to exec(3) for weird reason: 1311/19/13 2:58:29.118 PM loginwindow[65]: ERROR | -[Application setAppContext:] | Unable to get PID for context [0,1073414]11/19/13 2:58:29.118 PM Dock[353]: no information back from LS about running process LSASN:{hi=0x0;lo=0x106106}11/19/13 2:58:29.141 PM CoreServicesUIAgent[25061]: Error SecAssessmentCreate: The operation couldn’t be completed. (OSStatus error -67030.)

Whenever I try to download the ColdFusion 9.02 OS X version (either 32bit or 64bit) both result in the a dialog that state that the download is damaged. This is very frustrating. I would use CF10, but that has been nothing but trouble and Tomcat won't even start if you try to install CF10 on top of a standalone version of Tomcat as the ROOT webapp. I've been trying for days to get something solid with CF on my dev box, but I just want to get CF9 up and running on my fresh MacBook pro so I can get going on a ColdBox app I need to buildAny help would much appreciated or a link to an alternate location for downloading 9.01 or 9.02 would be appreciated.Thanks!Tim

Can I limit it to just 2 CPUs leaving the third to OS or do I have to upgrade license to 3CPU

i need to call atleast 3 javascript functions in a formusing "onSubmit" works fine with one function but when i try to add another nothing happens....<cfform action="postpage.cfm" method="POST" target="_self" onsubmit="if(document.getElementById('Agree').checked) { return true; } else { alert('You must agree to the Terms and Conditions'); return false; }">"return checkEmail(this);" is one of the funtions. it checks to see if 2 cfinputs are the samehow do i add multiple functions to onSubmit tnx in advance

Our current environment is CF8.0.1 Multi instance + IIS 6 + Window Server 2003.We are trying to upgrade the server hardward and also OS to the latest version which is WIndow Server 2003. But because of the script competible issue, we will remain the CF8.I try to install the CF 8 in the new server, it don't allow me to install the CF.Net features where it require the .net framewok 1.x or 2. I check my server, the framwork was installed and running fine in box now.Just wondering is that I miss out anything?Or any one had try with this kind of combination?

New install of CF10 on IIS7 does not open any cfm pages tries to download instead.

Posted for one of our programmers:  Variable E is undefined ...but the error message only occurs on PROD servers, not DEV nor TEST.  Any ideas?Variable E is undefined. coldfusion.runtime.UndefinedVariableException: Variable E is undefined. at coldfusion.runtime.CfJspPage._get(CfJspPage.java:303) at coldfusion.runtime.CfJspPage._get(CfJspPage.java:283) at coldfusion.runtime.CfJspPage._autoscalarize(CfJspPage.java:1494) at coldfusion.runtime.CfJspPage._autoscalarize(CfJspPage.java:1471) at coldfusion.compiler.ExprClassLoader.evaluate(ExprClassLoader.java:139) at coldfusion.runtime.CFPage.Evaluate(CFPage.java:1749) at coldfusion.runtime.CFPage.IIf(CFPage.java:1740) at cfeditEmplHrngStgErr2ecfc230382607$funcDISPLAYEMPLSTGERR.runFunction(D:\JRun4\servers\94_CFMX7\cfusion.ear\cfusion.war\cf\HCP\editEmplHrngStgErr.cfc:165) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMe

You guys are really short-sighted.  You've made a false assumption.  (See below):In my case, my GPU is continually maxed out doing analysis for Folding@home.  As far as I understand it, stream computing provides no tools for setting priority or for interrupting one GPU process to work on another.  On the other hand my GPU can easily be interrupted to process Flash data.The first thing I need to do is confirm that hardware acceleration is DISABLED.  You're making matters worse by falsely assuming the GPU is always idle.What's new?High PerformanceExperience hardware accelerated HD video with perfect playback using Flash Player. Recent improvements allow supported Flash content and games to continue to deliver responsive feedback even when your CPU is maxed.