Questions

Hi,I have been searching a lot for a Windows Control Panel that supports ColdFusion DSN etc.Earlier HELM Control panel was there but since it was sold to Parelles, there is not development and it is a dead product now Does anybody knows any other Windows Control Panel which support CF?Or anybody developing module for WebsitePanel CF Integration?Thanks.

GreetingsI am trying to get query results that would show elapsed time in business days. I have been so far unsuccessful in getting the elapsed days at all.An appraiser's clock starts ticking when an order is entered in the system (order_create_date). The clock stops for the appraiser when an order is completed (order_complete_date) and the turn-around time to the client is (order_report_sent_date).I attempted:<cfquery name="get_client_tat" datasource="#Request.BaseDSN#"> SELECT order_ID, order_create_date,      DateDiff("d", order_create_date, order_report_sent_date) AS client_tat   FROM main_orders    WHERE order_ID = #list_orders_all.order_ID#</cfquery><cfquery name="get_appraiser_tat" datasource="#Request.BaseDSN#"> SELECT order_ID, order_create_date,      DateDiff("d", order_create_date, order_complete_date) AS appraiser_tat   FROM main_orders   WHERE order_ID = #list_orders

Hello, I am looking for ColdFusion programers in the Boston area. Also any suggestions on development companies that have Coldfusion developers available. Any suggestions.

I'm trying to understand when I would use cfinvoke vs cfhttp to consume a web service.  Is it just two ways to skin a cat?Does the extension ?wsdl have to be added to the url, or can it be left off?  I consume some remote CF services that work without it.  Would the wsdl only be used with a remote component if it is to be registered as a component in cfadmin?Do I only need to register web services in cf admin when I don't want to use the full url in the call to the web service?I appreciate any clarification provided.

Hi,I am trying to get the Cold Fusion 9 Administration database connection to communicate to the database server.I have created an account on the SQL Server 2008 and used the account in the Cold Fusion 9 Administration database connection.When I verify the connection, the following message appears:Connection verification failed for data source: BUS_ULTC_Devjava.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "BUS_ULTC_Dev" requested by the login. The login failed.The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "BUS_ULTC_Dev" requested by the login. The login failed.Thanks,Mike

Open Message to Adobe,Your marketing department does realize that you do offer a product called ColdFusion, correct? If so, one could not tell from visiting www.adobe.com -- at least not without specifically searching for "ColdFusion". I challenge anyone from Adobe to map me the shortest path from the Adobe home page to a ColdFusion link without using the search. I just spent about 5 minutes could not find a single reference or link to ColdFusion. It used to be under products-->all products, but now it's even missing from that page.Adobe, your own marketing (or lack thereof) department is contributing to the "coldfusion is dead" myth. Is the product being prepped to be sold off?

Hello, everyone.When Solr collections were first introduced in ColdFusion Server, the one thing that really irritated me was the fact that you cannot edit a Solr collection (ie, when you click on a collection in CFAdmin, you are given a default template with ".htm, .html, .cfm, .cfml" as the documents to index - you can't see what's currently there and add/remove anything.)I thought I had heard (guess they were rumours) that CF10 was supposed to give you the ability to alter the index.  I'm running CF10, and it's the same as CF9 - clicking a collection gives default options, not the ability to add/remove document extensions.Is there a fix for this??  We have collections that were originally created a long time ago that were not documented what they are supposed to be indexing, and we have no idea of what to do if we need to change something.V/r,^_^

Hi In my CF10 server ( Oracle 11g ), I am getting frequently getting below error :[Macromedia][Oracle JDBC Driver] No more data available to read.

Hi,I am installing Cold Fusion 9 on a 32 Bit, Windows 2008 with IIS 7.After the installation, when the Administrator page is to appear, receiving a 404 message.I have added ISAPI Extensions and ISAPI Filters to the the IIS.Also, have added cfm, cfc and cfml to the Handler Mapping for the website.Per the research, the web.config file needs to include the cfm, cfc and cfml?The web.config on the server wit the 404 error has no entry for the cfm, cfc and cfml.I looked on the production server for the web.config file and the file contains the cfm, cfc and cfml.Below is an example entry:<add name="cfmHandler" path="*.cfm" verb='"*" modules="IsapiModule" scriptProcessor="C:\JRun4\lib\wsconfig\jrun_iis6.dll" resourceType="Either" responseBufferLimit="0" />Also, i saw a mention that the 32 bit needs to be enabled for the DefaultAppPool advanced setting in IIS Manager.I did not see an entry for 32 Bit.If the above is added to the other web.config file, would the Administration page appear?

We are upgrading a server from CF7 to CF10 and have run into an issue with the server throwing a 500 error when executing a CF file in a sub directory. For example, we have a login page which uses Application.cfm. We successfully get through the login process but when we transfer the user to a .cfm file in the sub directory of the main directory, the 500 error occurs. If we transfer the user to an index.html page in the same sub directory, it executes just fine. So this appears to be some type of issue with executing a CFM page only, but the issue is occurring only in a sub directory. Server is Windows 2008 server running CF 10 with the latest Hotfix. Any ideas would be appreciated.Thanks, Jeff Hilliard

HiI have inherited a Coldfusion environment that is probably in need of a good update.I've been surfing about but can't seem to find anything.Where should i be looking?Thx

So we have had problems stopping the CF App Server service in Windows.  Admittedly, this fails from GUI, Command Line, etc even logged in as Local Administrator.  The service hangs on stopping and eventually after about 10 minutes you can "refresh" (in the GUI) and see that it has finally stopped.  It is taking so long, however, that the patching fails for the update so we don't know how to get the Server update applied.Like I stated, this happens from GUI or command line whether patching or not - any simple attempt to stop/restart the CF App Server service will just hang and will eventually stop - just not very quickly.  (and not quick enough for the server update to successfully complete).Any ideas?  Any help/workaround to get the server update applied would be appreciated....

Has anyone had this issue? How would I go about fixing it?

Hi All,org.apache.poi java library helps to create an excel files as:<cfset setFile = createObject("java","java.io.FileOutputStream") />        <cfset xlsFile = setFile.init(filepath) />        <cfset writeableWorkbook = createObject("java","org.apache.poi.xssf.usermodel.XSSFWorkbook") />        <cfset cellStyleStatic = createObject("java","org.apache.poi.xssf.usermodel.XSSFCellStyle") />        <cfset region = createObject("java","org.apache.poi.ss.util.CellRangeAddress") /><!--- Insert cells and rows --->        <cfset temp = writeableWorkbook.write(setFile)>        <cfset temp = setFile.close()>The process fail with out of memory error for 17,000 plus rows: GC overhead limit exceeded.Anybody knows how to fix this issue?Thanks!

In the block/CFIDE requests section of the Server Lockdown guide for Coldfusion 9, when we edit the applicationHost.config file to block Coldfusion URL sequences, Coldfusion brings up an error HTTP Error 500.19 internal server error.  A web.config file was also created and placed in the web root of the Coldfusion install.  How can we fix this?Thanks in advance

I have a cfgrid bound to a query in a cfc. The query indents one of the columns with blank spaces dependent on a hierarchy, like:... SELECT regularColumn, indentedColumn = replicate(CHAR(32),((Hlevel-1)*2))+' '+indentedColumn...Query works fine, i can see the indents in SQL server manager, but they never make it back to cfgrid. If i pick any other "visible" character works fine.Any ideas?Thanks

What are the required IIS 8.5 features need to run ColdFusion 11? Would the following install the correct features?  Should something be added or removed from this list?add-windowsfeature Web-Server,Web-WebServer,Web-Common-Http,Web-Static-Content,Web-Default-Doc,Web-Dir-Browsing,Web-Http-Errors,Web-App-Dev,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Health,Web-Http-Logging,Web-Request-Monitor,Web-Security,Web-Filtering,Web-Performance,Web-Stat-Compression,Web-Mgmt-Tools,Web-Mgmt-Console

I noticed that when I'm debugging that I get errors on missing images. I did a Google search on "coldfusion cfide missing enddoc.gif parentdoc.gif" and found a web site that had them. (I don't think they know that they have directory browsing turned on" and compared their directory to mine and found I was missing 8 images. These images are all new with CF11 and I would like to know how to get them without taking them from someone else website who I don't know. They do make the debug output look better. Can anyone tell me where to get them?

Dear allWhy Have developer is using ColdFusion?It is extremely outdated, not much company is using it in the worldThanks

<!doctype html><html><head><link rel="stylesheet" type="text/css" href="style.css"></link><script type="text/javascript" src="jquery.js"></script></script></head><body style="background-color:#00BFFF"><div class="tabs">   <ul class="tablink">  <cfif session.x eq 1 or session.x eq 6><li <cfif session.current_page eq "ci">class="active" </cfif>> <a href="check_initiation.cfm?page=ci">Check Initiation</a> <li></cfif>  <cfif session.x eq 2 or session.x eq 6><li <cfif session.current_page eq "ofac">class="active" </cfif>> <a href="ofac_approval.cfm?page=ofac">OFAC Approval</a> <li></cfif>  <cfif session.x eq 3 or session.x eq 6><li <cfif session.current_page eq "fla">class="active" </cfif>> <a href="first_level_approval.cfm?page=fla">First Level Approval</a> <li>&l

Hi,I am trying to use JQuery in my cfm code for an input form.JQuery Code:CFQuery:Input Object code:The object is to generate a pseudo SSN based on the last digit used stored in a database table row if the checkbox is checked.The output looks like this:It doesn't seem to do anything to check and uncheck the box but throws no errors.  Running the debuggers doesn't seem to even step into the jquery code.????  This isn't the first time I have tried to use JQuery selectors without success in my cf code...HELP!Thanks,Nathan Manning

I have table with a column that holds elapsed times in an hh:mm format.  I'd like to add these times together to get a total, but I can't add something with a :, and dateadd() isn't a fan either.Any suggestions?I thought about breaking apart the hh:mm and converting the hours into straight minutes, then adding them together, but that seems clunky.

I have multiple dropdown lists on a form that are interdependent on each other. So, I'm using cfselects with binding based on selection of the previous drop down.Here's the scenario:Each 'sales representative' is assigned a number of clients. In turn, the clients are assigned a designated customer service rep.I have a form that is using a cfselect to bind the clients displayed in the client list based on which sales representative is selected.Once the 'client' is selected, I would like the next drop down list to populate with all customer service reps but have the rep that is actually assigned to the client be the default selected item in the drop down (e.g., selected="selected"). I need all service reps listed because there are instances that a case will be assigned to a different service rep than the default.I have scoured the web and reviewed many examples but am still at a loss.In my research found something similar to the code I'm using in the cfc (below) to pull the a list of all

I imagine this is easy, but have tried to search here as well as Google it and have come up empty. I have a CFINPUT dateField control that is OK when my form loads, but then I want the control to capture a new date selection from the user and update the form. I believe the onChange event is used to process this, but I don't know how to code it so that it will refresh the form using the new date and keep the user's date selection.

Has anyone been able to successfully index PDF documents with Solr in CF10?