Questions

I have a ColdFusion front end/Oracle backend application I inherited from the company that lost the contract to my company.  In one screen, there is a field the customer wished to increase from NUMBER (10,3) to NUMBER (10,8).  After researching and conferring with the Gov't DBAS supporting the production and test systems, it was suggested that I just alter the field to plain NUMBER,  I did so on my Development system and changed the CF code to allow for proper display.  It worked quite well.   I had the Gov't DBAs change the field in the production and test databases to match.   I then FTP'd the CF code to the test system.   It allows for entry and initial display of the new field size, but upon saving it (unlike my Development test) truncates/rounds up (i.e.- 123.87654321 becomes 123.87700000).  I have ensured the proper code is there and verified with the Gov't DBAs that the databases matches my Develop database.   What

We are currently developing a Coldfusion application where one of the requirements as set by the client, is that it should be distributed as a deployable EAR file. Our plan is to develop the application locally and then generate the EAR file using the Coldfusion Administration (or a custom ant script) and distribute the Coldfusion EAR application to our client. The licence in the EAR would be the Developer Licence since the client would be using his own Coldfusion licence. Our concern is whether  the Coldfusion Developer Licence legally allows us to distribute the solution as an EAR. Using a CAR file is out of the question.

I am learning CFwheels recently. Am able to print out all my items from a database in a loop with this line in a controller..<cfset queryall = model("equips").findAll(order="name")>But I want to make a query where it only returns items in that database where status = "In".  I tried this...<cfset appequips = model("equips").findAll(WHERE "status=In")>  But I am getting an "invalid construct" error. The documentation says to do - <!--- Including an association (which in this case needs to be setup as a `belongsTo` association to `author` on the `article` model first) ---><cfset articles = model("article").findAll(where="published=1", order="createdAt DESC", include="author")>I am not sure what they mean with the "belongsTo" association... My whole function in the "equiplist" controller (everything outside of the line with WHERE is for something else though and working fine).<cffunction name="equiplist">        &nb

the docs say there's a single thread that watches the directory.  But say for example it finds 3 files and calls the cfc.  At that point do all 3 files run one at a time on a single thread in the order they came in, or do they run at the same time on multi-threads?

how to get <cfsearch> to search one collection in CF 10

I am in the process of creating a search engine in coldfusion.  I can't get the search engine to pull the pdf files when trying to do a search.  I created a collection in cold fusion administrator.

We are having a issue where ColdFusion maxes out the CPU. It will remain that way until we restart ColdFusion. This has happened a few times before but the last time it completely hung and displayed the site wide timeout page as plain text exposing the ColdFusion code. We did update the web server connectors after installing update 12. I've looked in so many log files and seen so many things using windows process monitor that I'm not sure if I missing something important or focusing on the wrong erros.This post on the forums describes what we have been dealing with. http://forums.adobe.com/message/5878493I'm found these errors being thrown while this was going on. isapi_redirect.log errors [10520:14316] [error] start_response::jk_isapi_plugin.c (1158): HSE_REQ_SEND_RESPONSE_HEADER failed with error=87 (0x00000057)[10520:14316] [error] isapi_write_client::jk_isapi_plugin.c (1283): WriteClient failed with 1229 (0x000004cd)[10520:14316] [info] ajp_process_callback::jk_ajp_common.c (1992):

After upgrading to coldfusion 10, we are facing an issue with Java objects passed from Coldfusion to Java and vice versa. We have one functions myfunctionname in Java, which use coldfusion.sql.QueryTable as one parameter. Now if I call this Java function with a cfquery variable as a parameter from coldfusion code Either there are no methods with the specified method name and argument types or the myfunctionname  method is overloaded with argument types that ColdFusion cannot decipher reliably. ColdFusion found 0 methods that match the provided arguments. If this is a Java object and you verified that the method exists, use the javacast function to reduce ambiguity. Also at some other places I am getting this errors- Cannot convert coldfusion.sql.QueryTable to  coldfusion.sql.QueryTable. Ljava.lang.String; cannot be cast to java.lang.String All these functions were working fine in coldfusion 8. Can someone provide help on this.

I've added an AutoSuggest script to my site that offers suggestions as the user types their search keyword(s).   The script works great except that it performs a search with every keystroke.   I have spent the past 3 days trying out different jquery scripts that will for when a user stops typing before sending the search request, but I cannot get any of them to work correctly.  Some prevent the search from being sent until the user clicks OUT of the search box, but I need a script that will work when the user stops typing for (xxx ms).     I have include my code below in hopes someone might be able to help.BTW:  I do not know jquery or javascript much at all.  I can often look at a script and know what to edit, but that's about it. Even this script for the AUTOSUGGEST was from a post I found online.CSS------------------------------------------------------------<style type="text/css">    div.autosuggest{position

Hi all,I have an Access 2003 database in which some function is defined in a module.I also have a query defined which calls this function with no problem.Both the query and the function work well when the query is executed from Access.But when I try to execute the same query from ColdFusion, I get an error claiming that the function is not defined.Any Idea ?

I currently have an application that trades virtual items and is making at least 40 CFHTTP requests per second to the host's server.The issue I'm encountering is that it's taking anywhere from 400ms+ for my CFHTTP call to return a response which means my application is missing out on 99% of the deals it finds, as there are lots of other competiting applications out there that are getting a faster response.I've struggled to find a cause and/or a solution to this situation so I wrote a script in both CF and C# that makes 10 http requests timing each one which resulted in the following response times:In CF using the following browsers:IE9: 384, 444, 302, 570, 535, 317, 510, 349, 357, 467 - Average 423.5msFirefox 27.0.1: 354, 587, 291, 480, 437, 304, 537, 322, 286, 652 - Average 425msChrome: 300, 328, 328, 639, 285, 259, 348, 291, 299, 414 - Average 349.7msIn C# Console Application:597, 43, 96, 52, 44, 305, 67, 91, 54, 270 - Average 161.9msAs you can see there is a big performance differen

Hello all,We've been using the .Net integration with CF 10 on Windows 2008 64-bit server.Our host snuck in a patch on us this morning that updated the .Net Framework 4.5.1 (KB28998869 & KB2901126). These patches seemed to have caused an issue with the .Net Integration services. Now I'm getting the following error: DotNet Side does not seem to be running.After uninstaling the patches and restarting the .Net CF Service, I get a series of errors as I try to access the pages with the .Net integration:Attempted to read or write protected memory. This is often an indication that other memory is corruptTimeout expired.  The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.problem writing data to socketDotNet Side does not seem to be running.I'm eventually left with #4 above. It takes a few page loads to get there, but at a certain point, this is all that will return.I

I can't believe Adobe has the nerve to charge what they charge for ColdFusion, but they can't even make it install correctly on IIS 7.  How do we get past the 500.0 Internal Server error in IIS 7 when trying to hit the CF Admin page after install?

We have been testing cfspreadsheet and are experienceing large processing times when usingSpreadsheetAddRows.Here is a simple example:<cfset newQuery = queryNew("Column_1, Column_2, Column_3, Column_4")><cfloop index="i" from="1" to="4000"><cfset queryAddRow(newQuery)><cfset querySetCell(newQuery, "Column_1", i)><cfset querySetCell(newQuery, "Column_2", "0")><cfset querySetCell(newQuery, "Column_3", "0")><cfset querySetCell(newQuery, "Column_4", "0")> </cfloop> <!--- Create new spreadsheet Object and add a row with the column names (takes about 2 ms to run) ---><cfset ssObj=Spreadsheetnew()><cfset SpreadsheetAddRow(ssObj,"Column_1, Column_2, Column_3, Column_4")><!---  Adds the rows from the query to the spreadsheet (takes about 15 min to run) ---><cfset SpreadsheetAddRows(ssObj,newQuery)><!--- Write spreadsheet ---><cfspreadsheet action="write" filename="#ExpandPath("./spreadsheets/spreadsheet.

I have a legacy CF 8 server and I desperately need to upgrade Java on this thing. Java 6 is no longer being updated for Windows, so I need to go to Java 7. I can't seem to find a hard answer as to whether or not CF 8 supports Java 7.Any answers are greatly appreciated.

Tomcat Native library is present\ColdFusionSplendor\cfusion\bin>cfstart partly says:org.apache.catalina.core.AprLifecycleListener initINFO: Loaded APR based Apache Tomcat Native library 1.1.29 using APR version 1.4.8.Apache Tomcat Native library 1.1.29 is installed already. No need to get a tomcat native library and install it yourself.  Debugging & Logging > Log Files  last optionOne can get to the tail of logs and read current log content. EG:Searching file(s): coldfusion-out.log  1 - 40 of 148 / Next / Last Tomcat gets updatedTomcat Version  7.0.41.0. CF10 has been Tomcat Version  7.0.23.0  since release. Still CF11 beta is behind current tomcat 7.0.52. What tomcat version will CF11 have on release? Will CF10 be able to apply that tomcat version?Regards, Carl.

ColdFusion Splendor admin > Debugging & Logging > Log Files > coldfusion-error.log is empty.Log file coldfusion-error.log does not have any content. In CF10 I found technical details recorded in coldfusion-error.log when CF started or stopped has been helpful to resolve problems. Why is coldfusion-error.log empty or blank? Will CF11 release have coldfusion-error.log with log contents?Thanks in advance, Carl.

ColdFusion Splendor is running Java 7 1.7.0_51. With Java 8 release pending mid this month will CF11 release supporting Java 8?Thanks in advance, Carl.

Hi ,We are using Apache with ColdFusion 10 in Solaris 10 OS. And we are getting frequently below error :http status 503 - request timed out waiting to executePlease check and let me know, if you need any further information for server configuration side.Thanx,Snehendu Paul

There doesn't appear to be a separate beta forum, so I'm reporting this here.Testing the Thunder Beta, it reports the following as a syntax error:if (thing) {     transaction {          doStuff;          EntitySave(item);     }}It reports 'return statement in function' for pretty much all our cfscript transaction statements.This is the standalone install. I haven't been able to get the Eclipse plugin install working yet.

The beta release notes at http://labs.adobe.com/technologies/coldfusion/?tabID=details#release_notes lists IIS 8.5, but not Windows Server 2012 R2, is this an documentation mistake?  Also the Java version (7 or 😎 and type (SDK vs JRE) is not currently listed on this page.  Lastly can the CFB 11 Thunder be run on a server version of Windows, only 7, 8, and 8.1 are listed.

Why is the cgi variable auth_password coming up blank?  This is on CF 10.  I have debugging information turned on and can see all of the cgi variables and it correctly shows the username and authentication type (I have it set to Basic Authentication with Anonymous turned off and it shows AUTH_TYPE=Basic).  If I run an asp page using <% Response.Write(Request.ServerVariables("auth_password")) %> it shows the password so I know it's not IIS.  Any ideas?

HTTP Error 404.3 - Not FoundThe page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.

This is an old issue that still has not been resolvedWhen closing a file on CF Builder 2 it takes a long time for the file to close. This used to happen on Windows XP. I have a new PC with Windows 7 and reinstalled CF Builder 2 but the issue closing the file continues.I have to do the following for that to stop.Closed CF BuilderRenamed the file workspace\.metadata\.plugins\com.adobe.ide.editor.cfml\foldings\foldings.dataStarted CF BuilderHowever, after few hours CF Builder 2 becomes slow again when closing the files.Is there any fix for this issue other than the temporary solution above?

so here is what I need -I have a query that pulls rows from the Database through a stored procedure.(these are properties in an area)Before I start looping through the query, I need to check the distance between my current location and the property. If it less than 5 miles, only then should I display that property. The distance in miles will be chosen while submitting the search form.So is there a way to delete rows from the result set based on the criteria? OrIs there a better way to accomplish this? I am using the the google api to get the latitudes and longitudes. The other issue to keep in mind is the load time.Thanks