ColdFusion

I just migrated my last MS Access database over to SQL Server 8 database.I have  tables with 100-20,000 rows in them.My question is what can I do to improve performance (page load time)?I have pages that are taking 10 seconds to load that took 2 seconds with Access...I expected improvement with MSSQL.I have indexed tables etc...Is there something in the CF code I need to modify also.I am using CF9

Hi! I am working on a first CF app, and encountered three things that I don't know how to do it regarding forms1) I need to test that the password and confirm password fields are the same before submitting the form to processing cfm. How do I do that with cf? (I don't know other  languages)2) I have a first field in a form with a dropdown where a choose employee gender. I want in the same form below within a second field to have a dropdown list populated with all employees having the gender selected above which I get through a query. Is it possible to do that without submission? 3) I want to arrange payments to employees based on their job. For management, there are beside salary, bonuses. I want to make a general form for this action, but if I choose in a field above a MANAGER position, another field to be inserted below to be filled with bonus amount, however, if i choose NORMAL EMPLOYEE above, this BONUS Field should not appear. Is it possible to change the content of cfform ba

Is there a way to access public folders on Microsoft Exchange.  This can be any version of ColdFusion and any version of Exchange.  Right now I have CF9 and Exchange 2007, but we are looking to upgrade to CF10 and Exchange 2013.

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

Spent past 12 weeks building web site using a ton of CFLAYOUT's; which are new to me.  Developed in Google Chrome. Today someone told me it was spinning.  In IE10. Removed code chunks bit by bit.  Til I found the culprit. Then I built an incredibly simple test template ...                       <cflayout type="tab"                        align="left"                        name="eventdet"                              tabHeight="100px"             &

I have a new site that I'm trying to launch on my local IIS7 server on Windows Server 2008.  In the past, to handle mappings etc. I've always been able to run the wsconfig tool after creating the site within IIS without issue.  However, after the latest run I'm getting an Access is Denied error when I run the command from command line:wsconfig.exe -ws IIS -site my_site...\ExecutedAppCmd.exe (Access is denied)When I tried to run the utility via the GUI, there are no sites within the initial dropdown for Configured Web Servers(See below).I'm am logged in as an administrator, and I'm running the command line as an admin so that shouldn't be an issue.This utility worked a month ago.  What could possibly going on?  Google is turning up nothing for me.I'm currently running Coldfusion 10 Enterprise.

Hi!I have the code below and I want to know how to create a css rule to add style to the tooltip within cfinput. It is displayed by default, however, i want to format how it looks. Any ideas? <div class="container"><h1> Create user </h1> <cfform  id="form" action="processusercreation.cfm" method="post" ><table> <tr> <td id="formleft">  Username </td><td id="formright">     <cfinput type="text"        tooltip="Desired username, with 20 letters and numbers, no spaces"        required="yes"        validate="regular_expression"        pattern="^[a-zA-Z0-9]+$"        message="~Hey, there is something wrong with your username~"         validateat="onsubmit,onserver"     &nbsp

Here's my situation ... when someone goes to an incorrect URL under our domain that ends with a CFM extension, they are correctly re-directed to our 404 page; however, if the user types a URL, or clicks on a link, that ends in any extension other than CFM (i.e. HTML, PHP, ASPX, etc.) they are presented with a message that states "The system cannot find the file specified" instead of our 404 page.We are using Coldfusion MX7 on IIS6, Windows 2K3. Personally, I am more of a front-end designer/developer than anything else, so my actual  knowledge of IIS and Coldfusion administration is minimal at best. My supervisor, who is equally baffled by this, does have a better understanding of IIS but is equally novice at CF admin. (We inherited this system so are forced to learn as we go.)Any assistance would be very much appreciated. Thank you!Cheers!James

I have installed CF 10 and the console in CF Builder 2 no longer seems to work? Both products are fully up to date and I have the same issue on 3 separate dev machines.  All else, works fine.  Did somethin change with CF 10? A complete frsh re-install of CF Builder does not help either... I am on Win7 Pro, 64b and 32b... same issue.Upon starting CF Builder, the localhost Server console will say this:[localhost]:(12/10 at 01:53:40) Server is available. Getting server settings.but that's it. Nothing after that. Stopping and restarting CF from within Builder does not fix this?Also, I read on a blog re: CF 10 "beta" that you no longer need to set the CF service to manual in order to get the full effect of the console, etc. in CF Builder. Is this the case and the proper way to handle this now?Andy

I'm currently unable to find any Hot Fixes for CHF 4 for 9.0.1 that cover the issues in APSB13-10 and APSB13-13?  What am I missing?

I have CF10 developer version installed on a cloud server.  I now wish to buy CF10 and go live.  How can I do this without changing my existing setup?

Where can I download coldfusion 8 update 1? I cannot find it on adobe.com. Thanks.

Hi All,Here is my query:<cfquery name="qryData"  datasource="#application.DBconn#" >        select columnA, columnB        <cfloop from="1" to="5" index="y">            ,SUM (Case when wType='FULL' then YEAR_#y# else 0 end) as FULL_#y#            ,SUM (Case when wType='PART' then YEAR_#y# else 0 end) as PART_#y#         </cfloop>        from (          select columnA, columnB, wType          <cfloop from="1" to="5" index="y">               ,SUM(case when fy = #y# then totalDI else 0 end) as YEAR_#y#        &nbs

I have a bar chart based on a query that is working correctly. In my result the bar has 3 columns. I then want a scatter chart to display over the bar. The query for the scatter chart gets only one value but when I run it it displays values on all 3 bars. I have no idea what I'm doing wrong. <cfchart format="flash" chartheight="300" title="Team Scores - Most Recent Routine Review" showborder="yes" scaleFrom = "0" gridlines="#gridlines#" scaleTo = "#scaleTo#" chartwidth="650" seriesplacement="default" labelformat="number" tipstyle="mouseOver" xaxistype="scale">      <cfchartseries type="bar"      seriescolor="0053A6"      serieslabel="Team"        query="qryKPIResults"      itemcolumn="TotalVariance"        valuecolumn="cnt">      </cfchartseries>      <cfchartseries type="scatter"  &

My CFSELECT is not showing up on the page: http://www.benoitsystems.com/benoitorgs/events/cal_itm_nwcfform.cfmalso, I'm getting an error, referring to my Submit button.While I'm at it, I'm using a dropdown listing of TWO fields (category ID, as well as the category text (displayed).  How do I accomplish this in a CFSELECT?======Attribute validation error for tag CFINPUT.The value of the attribute TYPE, which is currently "hidden", must be one of the values: RADIO,CHECKBOX,PASSWORD,TEXT.The error occurred inE:\benoitsystems.com\wwwroot\benoitorgs\events\cal_itm_nwcfform.cfm: line 7270 : 71 :     <CFINPUT 72 :      TYPE = "hidden" 73 :      NAME = "posted" VALUE = "<CFOUTPUT>#Now()#</CFOUTPUT>">This (above) is the error message I get, with the template below.=====<!--- This example shows how to use cfinsert instead of cfquery to put data in a     datasource. ---><!--- If

Hi Everyone,I am having some issues accessing the methods in the datasource.cfc in the adminAPI.I can successfully load the administrator CFC and am told that I have successsfuly logged in;But when I try to subsequently load the datasource.cfc I get an error that the current user is unable to access the method./* Create an Admin API object and call the login method */                                                  var local = {};                                                  local.adminObj = createOb

I have CF 9.0.0.0 and tried to update from java 1.6.0_14 to java 1.7.0_21 at the request of my security department.  CF 9 Application Server used to run with "C:\ColdFusion9\runtime\bin\jrunsvc.exe" but now there's no jrunsvc.exe on the system.  What replaced jrunsvc.exe or was the error mine in trying to update java?thanks,Bob

How can I use a coldfusion application locally without an coldfusion server?I wrote an cf-application and a friend wants to use it on his pc. but he does not want to buy a cf server.What could I do that my app runs on his pc?

I'm using CF9 and running the server as a local user, default setup.I am creating an Excel xlsx file using cfspreadsheet, then renaming the file using cffile. I then place it in the user's personal directory using CFFTP. The file does get there but...Problem: File permissions are for admin and domain admin. The poor user can't open their own file!SO:How can I change the windows file permission to allow the current logged in user to access their own Excel 2010 file?OR:How can I modify the CF9 server to make created  file permissions for "domain users"?Thanks so much in advance!

I hope someone can help me with this. I'm kind of stuck on the conditional.I have a newsletter signup form that includes a check box that is check by default.<label for="mailList"><input checked="checked" id="mailList" name="mailList" tabindex="14" type="checkbox" value="0" width="5px" /><span class="checkbox">I would like to receive your e-newsletter.</span></label>I'm trying to email the answer, yes or no, based on whether or not the box is checked. Here is the conditional code between my <cfmail></cfmail> tags.Subscribe to e-newsletter? <cfif isDefined("form.mailList") AND Len(form.mailList)><cfif NOT Compare(#form.mailList#,"0")>yes<cfelse>no</cfif></cfif>If someone checks the box I get the sentence "Subscribe to e-newsletter? Yes" in an email. If someone does not check the box I get "Subscribe to e-newsletter?" I can't figure out how to get the "No" to show up in the email when the box is not checked.I feal li

We've installed ColdFusion10 on a development and QA server using the ColdFusion_10_WWEJ_linux64.bin package.  Today we installed CF10 on a production server using the same package but removed the option to install Solr Services during the install (goof).  My dilemmas are that I'd like all these servers configurations to be identical and we spent quite a bit of time locking down the Production installations (so I don't want to reinstall, unless I must).  What I've tried so far --   rerun the bin package and try to just install the Solr war file it wants to create a new directory /opt/cfsolrservice, where if it is included with the regular install it does not create a separate Solr directoryI read http://help.adobe.com/en_US/ColdFusion/10.0/Installing/WSe9cbe5cf462523a0-250dbb5c121b00d9395-8000.html that suggests using just the Solr package ColdFusion_10_Jetty_Solr_linux64.bin might do the trick.  I am having trouble locating our physical copy of Cold Fusio

Hello,We have some web servers with different operating systems (ws 2003 standard edition r2 with iis 6 and coldfusion 9.0.1 hotfix 4 and ws 2008 r2 with iis 7.5 and coldfusion 10 update 😎 and for machines with coldfusion 10 we used Server Lockdown Guide.Last nightt in a period of time 15 minutes our antivirus reported some dangerous tmp files in folders:- CF9: {coldfusion_path} \ runtime \ servers \ coldfusion \ SERVER-INF \ temp \ wwwroot-tmp \- CF10: {coldfusion_path} \ cfusion \ runtime \ work \ Catalina \ localhost \ tmp \The only thing that I could understand from the logs is that 2 hours before attempting to write these files on the server, a client with ip 188.190.126.105 carried out on all my servers the request of the "famous" page http://server_ip/CFIDE/h.cfm going into error because there is not that page.Does anyone have any idea / suggestion of how it is possible that someone is still able to write these files in spite of:- Coldfusion 9.0.1 with Hotfix 4 and coldf

Hi Guys, I have some spare time at the moment and I'm looking to improve my skillset. Do youknow of any valuable technologies I could teach myself, something that I could use on my site somehow would be good. I have decent programming skills, a good understanding of CF, ASP, PHP, Javascript etc. I recently used AJAX alot which was great, I'd like to use a web service on my site but I'm not sure how I could put it to use. Has anyone got any other ideas? Thankyou

Long story short... I have a customer who want to trial CF10 alongside their fully licenced copy of CF9.If they then purchase a upgrade from CF9 to 10, can I install that code into the CF10 and get a licenced copy?Or would I have to upgarde the exising CF installation to 10 and then transfer that licence to the trial?ThanksPaul.

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec173d0-7ff8.html