ColdFusion

GreetingsThere seems to be no easy way to accomplish this without javascript/CF  with dozens of lines of code.The scenario: table 1 has banks, table 2 has loan processors. Client chooses bank from DDSB, only the processors from that choice show up in the second.Processor table has FK relationship to bank PK.ColdFusion 9.0.1, Microsoft SQL Server 2008 R2 Is there a simpler solution?Thanks and have a great New Year.

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WSe61e35da8d318518-106e125d1353e804331-7fff.html

Is it possible to setup CFBuilder so files opened in Windows explorer open in the currently open instance.  The final release tries to spawn a new instance and displays "Workspace in use or Cannot be Created".  I got around this in Beta's but i can't find a workaround in the final release.

Hello all,My 1st post so please be kind. I am trying to set up a datasource in my CF Admin console to an Oracle Database. Oracle does not appear as a Drive type in my dropdown list. Now I did read on the forum (see I did have a look before posting) that the oracle Driver does not come with the Std edition. So I have installed the Oracle Client, and under Java and JVM put a CF Calss Path pointing to the ojdbc6c.jar file.I have read other bits and bobs on the net that you can use the "Other" datasource to connect to oracle but I get "No Suitable Driver" error messages when I try that.So just looking for help to make Oracle appear as a Driver I can select, or how to correctly configure "Other" to make it work.Many thanks.Regards,Stevie

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-7880.html

Hello, I have tried a few times to install the mandatory update on CF10 following the instructions via cmnd prompt cd to C:\ColdFusion10\hf-updates where the downloaded cf10_mdt_updt.jar is locatedexecute c:\ColdFusion10\jre\bin\java -jar cf10_mdt_updt.jarThe intsaller runs fine and steps through the requisit steps - shuts down CF server fine - then commences to install only to freeze completely very early in progress bar. Im required to shut it down via the task-manager.I have tried many times... even reinstalling CFDoes anyone have any suggestionsIIS7.5Windows 7sp1CF10 Standard (and developer)

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-7880.html

I may have stumbled onto a bug when caching queries in ColdFusion 10.  I wanted to see if anyone else had seen this before I submitted a bug report.  It will be difficult to put together a complete test case, so hopefully a description will be enough to confirm if this is reproducible.First, I create an array of structures.  Each structure is a set of key/value pairs of arguments that will be passed to a query.  The first two keys hold numeric values, the third a string value.  I am querying a Microsoft SQL Server database.  My query is inside an array loop.  The query has the CachedWithin attribute set to 1 hour. In the query, I pass the values in the structure into the WHERE clause using CFQueryParam.If two of the sets of numeric values are similar enough but not identical, ColdFusion will jumble the values and pull back an incorrect cached query result set.  As an example, here are the values in my array:[{BookNo=97,PageNo=1,MapType="Assessor'

I am on Mac Mountain Lion, but that shouldn't make a difference.This is for a clients website, so I need to get this working ASAP.Any advice on how to get CF 10 working with this setup, only serving .html files that contain CFML?So far I have tried:1. Adding /*.html = cfusion and /*.htm = cfusion to my uriworkermap_cfusion.properties file.2. Adding .htm and .html to the AddHandler jakarta-servlet .cfm .cfml .cfc .cfr .cfswf line in my apache conf file..cfm files and CF Admin render correctly, but when I call a .html file that contains CFML I get a Tomcat error saying the requested resource is not available.Thanks for any advice on this, I am out of ideas.I've had no trouble getting this to work on Windows, IIS and CF10.

Can someone show me the correct way to reference a Session variable called "SESSION.kt_email" and filter it out of my User_email list?- The CFC below is used to grab all of the correct emails, but "exclude" the email of the logged in user- I'm using the GROUP_CONCAT so the outputted emails are separated by commas- My CFC works fine until I add in the Session stuff, then I get this error..Here is the CFC email_actions_updated.cfc: ----------------------------------------------- <!--- Generated by Adobe Dreamweaver CS4 10.0.0.4117 [en] (Win32) - Thu Dec 20 2012 16:57:12 GMT-0600 (Central Standard Time) ---><cfcomponent>          <cffunction name="GetEmails" access="remote" returnType="any" output="false">                    <cfargument name="id" type="numeric" required="true">  <cfargument name="kt_email" type="any" re

I'm trying to improve the performance of my ColdFusion 10 application by making better use of caching.  I have a particular DAO/Gateway CFC that queries a particular database.  I added query caching to the query in this CFC and it made a huge difference.Since this database is outside my control for edits/updates, I need to be able to initiate flushing of the cached queries for this database only.  I don't believe the built-in ColdFusion ehcache query cache allows for granular control of flushing - in CF Administrator you pretty much can only flush the entire cache.So I figured the only solution was to create my own cache region that would be associated with just this database, and manually cache the queries into that region.  Then I can flush just that region without impacting any other cached queries.So here's my difficulty:  I believe that Internally, ColdFusion caches queries using a hash of the generated SQL.  I'm thinking I'll store my queries in cach

trying to install ColdFusion 10 Mandatory Updateon mac 10.8newbie at terminal - need helpI have the  file cf10_mdt_updt.jartried this... for mac stanalonetyped = java -jar cf10_mdt_updt.jarUnable to access jarfile cf10_mdt_updt.jarprobably needs a path top the file - what do I type to get this working?http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSe61e35da8d318518-33adffe0134c60cd31c-7ffe.htmlhttp://helpx.adobe.com/coldfusion/kb/coldfusion-10-mandatory-update.htmlhttp://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSe61e35da8d318518-33adffe0134c60cd31c-7ffe.html

I have a form which has a drop-down select box. What I want to do is send the value from the select list to a CFC which runs some SQL code and returns a recordset. I then want to use this recordset on my original CFM page that has the form on it.Is it possible to do this without refreshing the page through some kind of AJAX? Apologies I am a newbie at AJAX but I did manage to write a bit of code that uses <cfdiv> to bind to a URL that does the database work and returns some HTML. But really I just want the database recordset and not sure how to get it?

Any ideas about whats going on here?The value of the TYPE attribute, which is currently ”CORBA”, must be one of the values: CORBA,COM,COMPONENT,JAVA,DOTNET,WEBSERVICE,.NET.

Hello my friend , im using coldfusion 9;Firstly How can i enabled ORM ?im have application.cfm file and i convert application.cfm file to application.cfc code is below,Application.cfc<cfcomponent output="false">          <cfscript>                    this.name = "test";                    this.sessionManagement = "Yes";                    this.sessionTimeout = CreateTimeSpan(0,0,20,0);                    this.setClientCookies = "Yes";                    this.clien

Hello.I'm using ColdFusion 9 and I have a question.When we have a form with required fields coded like this:<cfinput ... required="yes" message="Enter a value 1" /><cfinput ... required="yes" message="Enter a value 2" /><cfinput ... required="yes" message="Enter a value 3" />When user sumbits this form he will se an alert window:Enter a value 1Enter a value 2Enter a value 3How can I make it other way so then one single message is outputted like:"Enter values for all required fields"Not one message for each required field.Sorry for my imperfect English. Thank you.

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-6de0.html

After installing CF 9.0.2 on Windows Server 2008 with IIS7, I'm getting a 500 error back from all my web sites.  I made sure to change the permissions to the C:\ColdFusion9 folder to Full Control for psaadm and psacln.  I made sure that CGI, ISAPI extensions and ISAPI filters are installed.  I rebooted.  I can access the CF administrator on the server, but all my web sites generate 500 errors on remote browsers.  Uninstalling doesn't fix the problem.  Please help.  What can I do?

I am trying to run an update query and I am getting an error on the last cfqueryparam.  The error is "There is an error in the syntax of the query. Does anyone see the problem with this query.CODE: <!---Insert record into table OAREI_results--->      <cfquery datasource="xxx" name="addResult">                  INSERT INTO OAREI_results {poll_ID, question_ID, answer_text, votes)            VALUES (<cfqueryparam value="#FORM.QuestionID#" cfsqltype="cf_sql_varchar" />,                                <cfqueryparam value="#FORM.QuestionID#" cfsqltype="cf_sql_varchar" />,             &

Hi,i have the simple form for user to enter in PurNo.  Results is displayed fine with next and previous navigation.  without order by from the query, the next/previous worked fine.  However, afer i added  order by PurNo, NesID into my query then navigation didn't work as expected.  for example, when i click next, i see it changed for message and date added column but not for Pur No.  Can any one tell me what's wrong ?Thanks<!---cfc---><cffunction name="sale" returntype="query" access="public"> <cfargument name="PurNo" required="yes" type="numeric" />    <cfquery name="qsale" datasource="#variables.dsn#">     SELECT *    FROM tblsale    WHERE PurNo = <cfqueryparam  value="#arguments.so#" cfsqltype="cf_sql_integer" />    order by PurNo, NesID    </cfquery>    <cfreturn qsale /></cffunction><!--

Hi I'm getting this error reported here http://www.raymondcamden.com/index.cfm/2008/8/25/Bug-with-Ajax-HTML-Grid-and-File-Upload-Forms . I am using versaion 9.02. Can anyone tell me if this bug has been fixed yet?I have read in various places semi-colons can cause problems, but I don;t have any semi-colons on my grid....Thanks,Ian.

I have a form post that is occuring via ajax to a cf script.  One of the variables is a multi-dimensional array.  I can't seem to be able to get access to the values of the array.  When I do a dump on Form, I get keys that look like this:<CFDUMP var="#FORM#" />The result(keys):data[var1], data[var2], data[var3]########################################When I try to acess the vars though, all I get is errors:FORM.data["var1"] .....shows an errorFORM.data.var1 ......shows an errorOn the other elements that are not an array from the form post, I can access those values just fine:FORM.var4 .....displays valueFORM.var5 ..... displays valueWhat am I doing wrong here?

Hi,I have code the works in one environment, but the exact same code does not work in another environment.Both environments reside on the same server with Cold Fusion 9 Enterprise.The code contains: <CFIF   >     <CFelseif   >     <cfelse    ></CFIF >There are 5 nested CFelseif's within the <CFIF  > </CFIF>. Also, there are 3 sets <CFIF  >  </CFIF> of code 5 nested CFelseifs.When I seperated the code into seperate <CFIF  >    </CFIF>, the code works in the environment where the CFelseif does not work.Is there some limit of CFelseif? Or is there a patch that needs to be installed?Mike

Hello!The Jrun service give regular and random error 503 (timeout).I have one web-project run on the server. The Event viewer is clean. CF server monitor also not show any errors.CF+SQL together use 5% resources of server.Whats wrong?CPU: 2x Dual-Core Xeon RAM: 16GB ECC Registered OS:   Windows Server 2003 x84 (with PAE)CF:    CF 9,0,1,274733  Enterprise, IIS configuration x84 DB:    MS SQL 2008 WebEditionWeb:  IIS

Hi,Recent pen testing has discovered that it is possible to bypass logging in to gain access to the cfcexplorer with the following steps:1.) Go to the COLDFUSION cfcexplorerhttp://<domain-name>/CFIDE/componentutils/cfcexplorer.cfc2.) Click login without specifying a password     When this is done an page displaying an error message results: and a ? is then appended to the url 3.) Press the browser back button and manually add the ? to the url and click login again.http://<domain-name>/CFIDE/componentutils/cfcexplorer.cfc? You will now gain access to the cfc explorer.Is this a known problem that has a patch?