ColdFusion

I have 5 CFSELECT for Department, Manager, supervisor, Group Leader and EmployeesI want to every CFSELECT list narrow down for an upper CFSELECT.For example, once user select Department then all Manager, Supervisor, Group Leader and Employee list will be narrow down by departmentand same for manager and supervisor and so on.I can use iframe or jQuery to do every level, but it needs to call iframe or jQuery or 5 levels.I would like to know are there any better way to handle this situation,Your help and information is great appreciated,Regards,Iccsi,

I want to assign a value to my controls from my query result.It works for CFINPUT TEXT, but it does not work for SELECTI would like to know are there any way tp assign my dropdown list value base on the questy result.I have CFSTOREPROC like following: <cfstoredproc procedure="MySP">    <cfprocparam value = "#form.IDNumber#" CFSQLTYPE = "cf_sql_integer">    <cfprocresult name="spResult" resultset="1">  </cfstoredproc><CFINPUT type="text" id="txtIDNumber" value="#spResult.IDNumber#" />  I am able to siign the value to a CF INPUT TEXT like above code,<select id="lstNumber" value="#spResult.lstNumber#"></select>but it does not assign the value from my query result for SELECT input.Are there any way to assign a value to SELECT control from query result?I tried to use JavaScript which works if I pass a number, but it does not work if I pass a query result,Your help is great appreciated,Regards,Iccsi,

Hi EveryoneI am a IT technician/Sysadmin with my company and have been tasked to help sort out this long running problem.I do not know much about programming (nothing really) but know more or less what coldfusion does and how the process flows from the client to the server and back.The problem we face is that at certain times of the day some reports pulled via CF takes very long, it can even hang the clients browser, and computer in some cases.There is an ODBC connection to our iSeries server and one to our Helpdesk's SQL db.This is what I have done so far to troubleshoot:1.Ran wireshark on my PC with a filter to only show activity for the server IP, then ran a query to CF.Didnt see much, except for some  "Zero Window" messages going back and forth between my PC and the server as soon as the report popped up in my browser, after googling it I understand that it has to do with the network card buffer or CPU load on client or server.As soon as I save the document it stops doing the

Hello, Question 1: I have a CF 9.0.1 installation that is missing a number of security hotfixes (based on a vulnerability scan).  The list of missing security hotfixes is below.  Must I start at the beginning and apply each hotfix one by one?  If I apply the newest one (July 2013) will that automatically include the updates for all previous hotfixes?  The information online is rather vague.  It states that newer updates "may" contain some of the older ones.  It does not state definitely whether or not all previous hotfixes are included in the newly released ones.Missing Security Hotfixes:APSB13-19 July 2013 - Not InstalledAPSB13-13 May 2013 - Not InstalledAPSB13-10 Apr 2013 - Not InstalledAPSB13-03 Jan 2013 - Not InstalledAPSB12-26 Dec 2012 - Not InstalledAPSB12-21 Sept 2012 - Not InstalledAPSB12-15 June 2012 - Not InstalledAPSB12-06 March 2012 - Not InstalledAPSB11-29 December 2011 - Not InstalledAPSB11-14 June 2011 - Not InstalledAPSB11-04 February 2011

I set up a trap to log the requests to the website.  It appears that the request initiated by the AJAX call is never getting to the CF engine.  The webtools for Safari indicate that the AJAX request is going to the server, there’s a redirection to Shib (to validate authentication?), and that’s when Safari returns an error.   As soon as this returns the alert set to fire on an error is triggered.

Last couple of months I have been getting a lot of hits from a Synapse bot.  I think whoever coded it must have made an error, as some of the links are truncated to url/.../index.cfm.  (oddly Bing bot seems to have picked up a couple of these).I say 'bot', but this UA comes from a wide range of IP addresses from all over the globe;I am suspicious.  and I don't think it is a site coding error as it is only triggered with a 'synapse' UA.Here is the odd thing.  On the test server - in theory identical to the production server - this generates a 404 error, as you would expect.  However, on the production server - theoretically identical, same version of CF (CF9), same config/admin setup, etc - it generates and exception error.  This is more annoying than anything else as it is filling the error log, and setting off unnecessary alarms.  I guess I could write some code in the error.cfm to redirect to 404 if the URL has '...' in it, but would like to underst

We have a number of CF9.01 installs and we're discussing our plans for applying Hotfix 4 as well as the latest Security hotfix.  We know this includes support for Java 1.7, but we want to confirm that all the latest HF's available will continue to work with java 1.6.0_41 until our users/sites are ready for the Java change.Thanks.

Hello CF Superheroes,I'm playing around with CFCs and I've run into a situation where I would like to start calling methods from some CFCs from within another CFC (nesting).  My first instinct was to simply instance the CFCs from within the parent level CFC but I'm not sure ColdFusion would like it if I nest CFCs like that. I've read about some people getting the dreaded "null null" error at times.I'm aware of the "extends" property from within the <cfcomponent> tag but the problem is that you wind up having to instance all of the extended CFCs in the calling CFM template anyway.  It seems like it would just be easier to call the CFCs from within the CFCs that need to be "extended".For example,  here's what I'm thinking of doing:In my main template index.cfm:<cfobject component="MasterCFC" name="cfcs.master"><cfset temp = masterCFC.myFunction()>Then within master.cfc:<cfcomponent>          <!--- get my su

The following query works fine as long as there is a value in the subID field, which is at the end of the inner join statement. If the subID is blank then no data is output, even though it is there. Try as I may, I can not get the right solution in the where statement to get the data to show without the subID. What am I missing?<cfquery name="getInfo" datasource="#application.database#">select page_id, pageName, pages.content, pages.cat_id, pages.seo_title,pages.seo_desc,pages.seo_words,pages.h1_title,pages.pic,pages.brochure,pages.video,catagories.catagory,subcat.subID,subcat.sub_categoryfrom (pages INNER JOIN catagories ON pages.cat_id = catagories.cat_id) INNER JOIN subcat ON pages.subID = subcat.subIDwhere pages.page_id = #page_id#</cfquery>

I have a server REDHAT, install coldfusion 10, i need know how many user non-concurrents, can use one license.

Is it any way to check, if a web application is already running on clients computer.  In other words how to prevent users to opens second instance of the same running application??

I've searched and searched and can't seem to find documentation showing the specific differences between the Standard and Entperise ediions of CF 10.  Can anyone point to documentation on the differences in CFMAIL for standard vs. enterprise, and more generally, is there any detailed document available showing specifics for the different versions? I know in the past there was a "Buyers' Guide" that showed technical differences between the two, but all I've found for CF 10 is the general list of features.Thanks in advance for any help.

Hello,I adopted a CF 9 web-application and we're receiving the Internal 500 Error on a submit from a form that has line items for a RMA.The server originally only had Cumulative Hot Fix 1 on it and I thought if I installed Cumulative Hot Fix 4, I would be able to adjust the postParametersLimit variable in the neo-runtime.xml.  So, I tried doing this, and I've tried setting the number to an extremely large number (last try was 40000), and I'm still getting this error.  I've tried putting a <cfabort> on the first line on the cfm file that is being called, but I'm still getting the 500 error.As I mentioned, it's a RMA form and if the RMA has a few lines say up to 20 or 25 it will work.I've tried increasing the following all at the same time:postParameterSize to 1000 MBMax size of post data 1000MBRequest throttle Memory 768MBMaximum JVM Heap Size - 1024 MBEnable HTTP Status Codes - uncheckedHere's some extra backgroun on this situation.  This is all that happened befor

I have two tables:The first table’s primary key is sireIDIt holds the picture of the multiple sires, their name, the owner’s name and a brief descriptionThe second table holds the trial scores of the individual dogs, joined by the sireID from table one.I tried using a join to output the dog’s info and it’s scores :<cfquery name="getDetailsQuery1" datasource="#application.database#">select *from siresorder by sireID</cfquery><cfquery name="getDetailsQuery2" datasource="#application.database#">select *from scoreswhere sireID = #getDetailsQuery1.sireID#</cfquery><CFQUERY NAME="getDetails" datasource="#application.database#">SELECT * FROM getDetailsQuery1UNIONSELECT * FROM getDetailsQuery2ORDER BY sireID</CFQUERY>I get an error message:[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'getDetailsQuery1'. Make sure it exists and that its name is

Working on a form to input numeric data.  I am using <cfform> and the <cfinput> tags.   To help the user with data entry issues I want to show the user the comma format when their data entry goes beyond 3 digits.  This should be simple but I can't get this to work.   What is correct way to make this happen?   On the SQL end it's going into either a DECIMAL(10.2) or an INT.   Thanks! 

i have a cfwindow that works fine in ie10 but when i went to test it in other browsers (not that i wanted to ) but it didnt work at all , i did get this errorcfajax.js, line 90 character 1here is my code.....<cfajaximport tags="cfwindow">....ColdFusion.Window.create(       win,       'spare parts desc',       splink,       {        height:h,        width:700,        modal:true,        closable:true,        draggable:true,        resizable:true,        center:true,        initshow:true,        y:tempY       }  &nbs

At home, I am using ColdFusion Builder 1.0When I have a file open and press ctl+shift+O, it outputs this<cfoutput></cfoutput>  or writeOutput();When I have a file open and press ctl+shift+a, it outputs this:<cfabort> or abort:When I have a file open and press ctl+shift+d, it outputs this:<cfdump var=""> or writeDump():At work, I am using ColdFusion Builder 2.0.1. None of "features" described above work. I want to get them to work. What are the features called? Shortcuts? Do I need to download and install them separately? I have searched everywhere to find out how to make this happen and have had no luck. Please advise.

Does anyone know of any shared coldfusion web hosting services that will tolerate CF components? Thanks!! Carlos

The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request   Attribute validation error for tag CFQUERY. The tag has an invalid attribute combination: name. Possible combinations are:  Required attributes: 'datasource'. Optional attributes: 'blockfactor,cachedafter,connectstring,dbname,dbpool,dbserver,dbtype,debug,maxrows,name,password,provider,providerdsn,result,sql,timeout,username'.  Required attributes: 'datasource'. Optional attributes: 'blockfactor,cachedwithin,connectstring,dbname,dbpool,dbserver,dbtype,debug,maxrows,name,password,provider,providerdsn,result,sql,timeout,username'.  Required attributes: 'dbtype'. Optional attributes: 'blockfactor,cachedwithin,connectstring,datasource,dbname,dbpool,dbserver,debug,maxrows,name,password,provider,providerdsn,result,sql,timeout,username'.  Required attributes: 'dbtype,name'. Optional attributes: 'cachedwithin,debug,maxrows,result,sql,timeout'. &

I am trying to alter the report format at run time using the style option on CFREPORT.  I am actually trying to change the margins, but have tried everything I can think of.  So I copied the code right out of the documentation to change the color.  My code looks like <cfreport template="Detail_rpt.cfr"   query = "line" overwrite="yes" style='mystyle { defaultStyle: true;    font-family:"Comic Sans MS"; color: ##993366; }' format = "pdf"   ></cfreport>However, the report color is not changed.  I figure if I can get color to work, I can then get the margins in place of it.  But the statement appears to make no changes.Anyone got any ideas?  Have you ever gotten the style option to work?  If so, can you let me see your statement?Help!Thanks!Dave

Hi,I'm trying to read the header row from a very large(83k) tab delmited file.  I want to automate an upload to a temp table to append data, but I need to know the column headers to set up the table for Bulk Insert. How can I read in the only the first row?  CFSpreadsheet doesn't work with XSLX files, especially 83k row ones, it would just crap out.  So I'm going the tab delmited route here.Thanks

[ajp-bio-8012-exec-9] - Element SYS is undefined in CLIENT. The specific sequence of files included or processed is:We are getting the above error quite frequently when moved from ColdFusion 4.5 to ColdFusion 10 recently. I tried to use the default client variable storage to registry. Someone help me out on this error related to storing client varaibles? I'm seeing this issue recently after upgrading to CF10.

[ajp-bio-8012-exec-9] - Element SYS is undefined in CLIENT. The specific sequence of files included or processed is:We are getting the above error quite frequently when moved from ColdFusion 4.5 to ColdFusion 10 recently. I tried to use the default client variable storage to registry. Someone help me out on this error related to storing client varaibles? I'm seeing this issue recently after upgrading to CF10.

I am trying to upgrade an existing system from CF 8 to CF 10.  I have a datasource that connects to a Unidata database.  The datasource connects on the CF 8 server using driver class com.ibm.u2.jdbc.UniJDBCDriver and driver uniJDBC.  I set the datasource up on CF 10 the same way it is set up on CF 8.  I copied over the unijdbc.jar and asjava.zip files from /opt/coldfusion8/wwwroot/WEB-INF/classes on the old server and put them in /opt/coldfusion10/cfusion/wwwroot/WEB-INF/classes on the new server.  I updated the Coldfusion Class Path to /opt/coldfusion10/cfusion/wwwroot/WEB-INF/classes/unijdbc.jar,/opt/coldfusion10/cfusion/wwwroot/WEB-INF/classes/asjava.zip,"%CLASSPATH%"on the Java & JVM settings page in the CF 10 Administrator and restarted coldfusion before I tried adding the datasource.  When I try to verify the datasource I get this error:Connection verification failed for data source: colleaguejava.lang.AbstractMethodError: com.ibm.u2.jdbc.UniJDBC

I cannot pass an argument to a ColdFusion 10 web service if it's greater than approximately 5 KB, regardless of the data type. If I do, the browser returns with a "This page cannot be displayed" message (in IE) or "Server not found" (in Firefox).  If I pass data to the same argument and it's < 5 KB, then it works perfectly fine.   Is there a setting somewhere in ColdFusion, IIS or elsewhere that's causing this that I can adjust?  I'm new to ColdFusion 10 and have never run into this with previous CF versions.  I'm running Windows Server 2008 R2 Standard - 64 bit- IIS 7.5.  Thanks.