Questions

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

We've just recently implemented a self-signed SSL on the coldfusion webserver and find that the scheduled tasks are not running.They don't even appear to "kick off". I'm not receiving an error or notice.I've attempted pulling-in the cert directly into the Coldfusion JRE folder, and running through the most common answers on the internet regarding use of the cert keytool import - no luck.

I have been using SQL 200 for many years but now have a SQL 2008 server setup and all of my JavaScript is falling apart?When I use ColldFusion9 to save HTML containing JavaScript with back-to-back quotes - SQL is deleting one of the quote marks?IE: input type="text"      onfocus="if (this.value=='Enter Email for Ranchlands News') this.value='';this.style.color='grey';return;"      onblur="if (this.value=='') this.value='Enter Email for Ranchlands News';this.style.color='grey';return;"      value="Enter Email for Ranchlands News"      name="email" class="email-sign-up-field"This is a simple example form a clients form that is getting deconstructed - but I have many cases in complex JavaSctipt calls that are also falling apart.I know that I can change his.value=='' to his.value==''' and it will save properly - but the next time a SAVE is preformed it strips out another quote rendering the code useless.I have

My users need to type whole web URL including cfm extention to get the web site like www.myserver.myhome.cfm.I would like to know are there any way to let user enter the URL without cfm extention.Your help and information is great appreciated,Regards,Iccsi,

Hello community,I am experiencing a problem in context with ColdFusion 10 and webservices.My webservice creates some XML content, parses it with the XMLParse() function and returns it with returntype="xml".Testing it with an additional .cfm script (I invoke the webservice with cfinvoke, as you can see below) I noticed that the root element of the xml is missing - so does every child of the document root except the first one.If I run my test script on a ColdFusion 8 server everything works fine and the xml content is just as expected.Some information about my local server configuration:Windows 7IIS 7ColdFusion 10Here is my webservice.cfc<cfcomponent output="false">    <cffunction name="testFunction"                access="remote"                returntype="xml"         &n

The XML feed looks great, but when I do a simple http call to get the data, it is "encrypting" it or doing something odd.  Anyone know what causes this and what to do to fix it?This here is what I am doing:<cfset feedURL="http://api.walmartlabs.com/v1/feeds/items?apiKey=xxx&categoryId=xxx&format=xml"><cfhttp method="get" url="#feedURL#" result="feedItems"></cfhttp><cfdump var="#feedItems#">

In my CF app, I've used the CF OAuth code at riaforge to get request token and access token from QuickBooks Online and it works fine. After I tried to make a QBO API call by starting to build the http headers of the call (I followed the instructions on the section "HTTP Authorization Header" here: Implement OAuth in Your App). Then built the http header based on the methods of the code at riaforge because it worked. In addition, I've respected the order of the parameters given by Intuit in the previous link).When I launched the API Call, I received the response: "signature_invalid"I really want directions on how to sign the QBO online API Call with CF 9 if I have ready the 6 header parameters:    oauth_token    oauth_nonce    oauth_consumer_key    oauth_signature_method    oauth_timestamp    oauth_version(But if possible a working code would be better)Thank you in advance for your time and help

We want new hires to click a link on our website where a pdf comes up. They fill out the fields in the pdf and then the pdf gets emailed to HR. It would also work if I could somehow save that filled-out pdf to the server. I could have the form submit to another page that triggers cfmail and attaches the pdf. Just can't get the pdf saved to the server after having it filled out. Any ideas?

I was running CF 6.1 on two servers behind a load balancer. They both use a common database for the client variables. I have been getting a lot of error that appear to be lost sessions. As a test I took down one of the servers and almost all the errors have gone away. I though the use of a common database would allow multiple servers. Anyone have any ideas what might be wrong?PS. I didn't write the software and we can not upgrate CF.

I am upgrading to CF10/SOLR and finding that <cfsearch> fails when I specify multiple collections.  I am not doing a category search.  The search works fine for any single collection, but specifying multiple collections delimited by commas generates the failure...Diagnostics: There was a problem while attempting to perform a search. Error executing query : read past EOF java.io.IOException: read past EOF at org.apache.lucene.store.MMapDirectory$MMapIndexInput.readByte(MMapDirectory.java:278) at org.apache.lucene.store.DataInput.readVInt(DataInput.java:105) at org.apache.lucene.index.TermBuffer.read(TermBuffer.java:64) at org.apache.lucene.index.SegmentTermEnum.next(SegmentTermEnum.java:131) at org.apache.lucene.index.SegmentTermEnum.scanTo(SegmentTermEnum.java:166) at org.apache.lucene.index.TermInfosReader.get(TermInfosReader.java:274) at org.apache.lucene.index.TermInfosReader.get(TermInfosReader.java:210) at org.apache.lucene.index.SegmentTermDocs.seek(SegmentTermDoc

So, I'm trying to install the CF10 Mandatory update.  I've run the command line arguments and run through the GUI steps and all appeared fine.  However, in the admin my CF version is still set at: ColdFusion 10,282462.  According to Adobe, my  build number should be ColdFusion 10,283111 or ColdFusion 10,282913.I've tried re-running the update but now it tells me it's already installed?  OK....so I try to install the other available hotfixes but they won't install...I'm assuming because my build number is not what it should be.  They "go through the motions" but nothing happens and I'm still at the same build number and update level.Before this attempt, i was at Update level 2.  Running on Windows.Not sure what to do now.Ideas?

The bug report (https://bugbase.adobe.com/index.cfm?event=bug&id=3593673) says that this is fixed in build 286333.  That seems like it would be in update 11, or update 12.  But I don't see the bug number listed in the changelogs for either of those releases.  Can anyone confirm that it was in a particular update or not?  And if not, when the fix will be released?

I see some web site has an icon to present the web site.ASP.Net has favicon to present the web site.I would like to know does ColdFsuion has similar function to have my web site an icon to present.Your information and help is great appreciated,Regards,Iccsi,

We have a multitude of Scheduled Tasks.  When moving from one server to another, we currently manually re-enter the tasks.  This is fraught with problems the least of which is my typing ability.  Are the tasks saved in an XML or other type file that I could just copy from one server to another instead of re-keying?Thanks!