Questions

We have recently rolled out ColdFusion 10 Standard 64-bit  to our production environment. We've installed the mandatory update as well as the two available updates. Our web server is IIS on Microsoft Server 2008 R2 64-bit.The symptoms we are experiencing are:Loading ColdFusion pages that use database queries (CFQUERY) start to take a long time to load.In application.log we see several of the following errors "Error Executing Database Query.Timed out trying to establish connection""The request has exceeded the allowable time limit"If we wait for the request to be served (that is we don't hit stop in the web browser) we eventually get one of the following errors:"[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too many client tasks.""Error Executing Database Query. Timed out trying to establish connection"On the most heavily trafficked pages we will see other errors that correspond to the time we experience this problem that look like:"Eleme

Does anyone know if there is any place I can download CFMX 7 updaters from? I have googled endlessly and I was just not able to find them. Adobe's updater list page only lists updates and hotfixes for CF 8 upwards. Any help/guidance will be greatly appreciated. Thanks.

Hi All,Has Coldufsion 10 changed how the interopablity between Coldfusion and ms office work? I had some code that worked perfectly in CF9.It read an xls or xlsx file and deleted some sheets that where not required and then saved the xls or xlsx But now in CF10 with all xlsx files I get a null pointer error. It would appear that when using SpreadSheetRead this always opens the file in xls mode.I have tried numerous variation to find a solution.I also tried to create a new spreadsheet with SpreadsheetNew this was created in xlsx mode.While I could update cells and save as xlsx I could not read a sheet from an existing file and add it to this one.Is there anyone from Adobe that can shed some light on this??RegardsKen Caldwell

Hello AllI have a question regarding CFCOMPILE and ColdFusion version compatibility. We would like to distribute our software sourceless and have tried to use the CFCOMPILE command line utility.  We used the "deploy" option.  We did this is ColdFusion 8.0.1 Developer.  It seems the compiled code works just fine for most other 8.0.1 systems, but seems to die on a CF 9 system and even some other versions of CF8 depending on the JRE version.  My question is: Is there a way to compile source code that is backward compatible so I do not have to force my users to use a certain version/build of CF? If I compiled the software in version 9, will it work with all previous versions??  I tried to search the net, but there isn't much info I can find on this topic.  Any help would be greatly appreciated.Thanks!

Hi,i've test a simple search with cfgrid but don't know why when i dump the arguments from my cfc and it shows null instead of empty string.   To testing, i added cfdebug at the end and see some error:Element not found: ANo'gridRender' is undefined.   Please look at my code below and let me know what did i have wrong.  -Thanks<!---form.cfm---><cfform action="process.cfm" method="post"><cfinput type="text" name="ANo" id="ANo" value=""><input class="button" type="submit" name="submit" value="Search" /></cfform><!---process.cfm---><cfparam name="variables.row_per_page_default" default="15"> <cfparam name="variables.row_per_page_list" default="15,30,50,75,100"> <cfparam name="form.ANo" default="" /><cfform name="gridform" >    <cfgrid        name="grdAresults"        format="HTML"        title="Searc

How do I create a pdf from an xps doc?

Hi,this code works fine, the link from A Number field opens the new page. Instead of open the new page in a new window,  I want it to open in the pop up window, is there the way to do it? thx<cfform name="myGrid">    <cfgrid        name="grdANo"        format="HTML"        title="Search Result"       collapsible="false"    selectMode=" Single"     pagesize="#variables.row_per_page_default#"     bindOnLoad="true"        stripeRowColor ="silver"    stripeRows="yes"  width="600"          appendkey="no"         bind="cfc:cfc.searchA.searhANo({cfgridpage},{cfgridpagesize},             {cfgridsortcolumn},{cfgridsor

Hi,I need help to write RESTful cfc to accept call from jquery in JSON format. This is approximate format of the structure as an argument to the cfc: returns:code: 200  // Successfulldata: {    "success": true,    "result": {        "questions":[            {"question_id": "1", "question_answert": "some text..."},            {"question_id": "2", "question_answer": "some text..."},            ...            {"question_id": "3", "question_answer": "some text..."}        ]    }}This is cfc to parse JSON:<cffunction output="yes" name="verifyQuestions" access="remote" produces="application/json" returnType="string" httpmethod="post">   

Hi,i have the search page and want to display the results on the the cfgrid.  Both form and cfgrid are on the same page.  When i first open the form.cfm page, i see all the results already display on the page.  This is not right, i only want the results to display when i search something and hit on the submit button.  Can you please help?<!---my form.cfm---> <cfparam name="variables.row_per_page_default" default="50"> <cfparam name="variables.row_per_page_list" default="15,30,50,75,100"> <cfform name="search" action="form.cfm" method="post" onsubmit ="ColdFusion.Grid.refresh('myGrid', false);"><cfinput type="text" name="aNo_var" id="aNo_var"><input class="button" type="submit" name="submit" value="Search" /><!---diplay on the cfgrid--->    <cfgrid      format="html"         name="grid01"         width="700"  &nbsp

Can I still use CF 10 Developers Version after the trial period expires?

I have created a coldfusion 10 cluster with linux, and apache as a front end. However, when adding a data source or making a change on the local instance, the remote instance does not update. Is there a way to "sync" the two admin consoles so that the change does not have to be made twice?Thanks.

Both ColdFusion 9 and 10 showed strange performance curves when it comes to writing a lot of files to the VFS.I tested the possibility to use the VFS to speed up logging.The plan was to bulk-post data to a NoSQL (Couchdb) database, since cfhttp has a lot of overhead posting small entries to the log database.Writing just a few files (10-100) to RAM:// is much faster than writing to the physical disk.Writing 500 files, the physical and the ram disk perform about equal.The example below with 10.000 files, the physical disk is ten times faster!Note that there were not out of disk memory problems involved.Instead I  believe problem is related to the number of files created in a single directory. To write a file to a directory with many files already, is much slower.If I create 10.000 files in 20 different directories RAM maintains its performance curve in comparison to the physical disk.Is this a bug or something I missunderstood? Any thoughts about this?Help solving this performance p

I am not sure if my coldfusion server is hacked.I found the following items within a directory of one of my coldfusion web applications making it unavailable:1) 1.zip    * this zip file was decompressed with 301 malicious folders related to vigra and dkeys.txt2) make2.zip    * this zip file was decompressed with a folder named test-test and two other cfm files: application.cfm and tampl.cfm.Is anyone else experiencing this issue? It just happened today. And I just patched the server with the latest security hotfix last Thursday.My coldfusion server has RDS disabled, and the directory for CFIDE has been renamed, meanning CFIDE is technically not available. And CFIDE has also been moved to a different virtual web server running on a different port on IIS (not accessible from the internet) according to the instructions. I can't guess any possible way that hackers could hack into the server, unless via coldfusion web itself.And i wonder how these two zip files

This action page to query mutiple drop-down selection only works with 2 choices- when a third is introduced, it ignores it:<cfquery name="search_flexible_criteria" datasource="#Request.BaseDSN#">SELECT mo.order_ID, mo.order_number, mo.order_property_type_ID,mo.order_order_type_ID,mo.order_report_type_ID,mo.order_client_ID, mo.order_appraiser_ID,mo.order_status_ID,mo.order_rush_status_ID,mo.order_property_street, mo.order_property_city,mo.order_create_date, ls.order_status_ID, ls.order_status,lc.client_ID, lc.client_company, la.appraiser_ID, la.appraiser_fname, la.appraiser_lname, lo.order_type_ID,lo.order_type,lp.property_type_ID,lp.property_type,lr.report_type_ID,lr.report_type,lrs.rush_status_ID,lrs.rush_statusFROM  main_orders mo                LEFT JOIN lookup_order_status ls        ON mo.order_status_ID = ls.order_status_ID        &

Why do I see all these messages in coldfusion-error.log? There are tons of them.  This is CF10/Win2008/IIS7.5.  Single server, medium site, pretty typical set up.Nov 07, 2013 11:10:14 PM org.apache.tomcat.util.http.Cookies processCookieHeaderINFO: Cookies: Unknown Special CookieNov 07, 2013 11:10:14 PM org.apache.tomcat.util.http.Cookies processCookieHeaderINFO: Cookies: Unknown Special CookieNov 07, 2013 11:10:37 PM org.apache.tomcat.util.http.Cookies processCookieHeaderINFO: Cookies: Unknown Special CookieNov 07, 2013 11:10:37 PM org.apache.tomcat.util.http.Cookies processCookieHeaderINFO: Cookies: Unknown Special CookieNov 07, 2013 11:10:37 PM org.apache.tomcat.util.http.Cookies processCookieHeaderINFO: Cookies: Unknown Special CookieNov 07, 2013 11:11:13 PM org.apache.tomcat.util.http.Cookies processCookieHeaderINFO: Cookies: Unknown Special CookieNov 07, 2013 11:11:13 PM org.apache.tomcat.util.http.Cookies processCookieHeaderINFO: Cookies: Unknown Special CookieNov 07, 2

Upgrading from CF 8.0.0 to 8.0.1 on a Windows 2003 32-bit server. I believe I found the upgrade coldfusion-801-win.exe (383,809 KB). Is this the right one? ...and will I have issues upgrading my production with the version downloaded from an Adobe trial server?

I need to migrate an old CF  MX7 install to a new server. Does anyone know if I need to get new license Keys generated or if I can use the same license key on the new server? If I need a new license Key how do I get one generated?Thanks Nick Gorst

Hi list,does anybody have a validColdFusion MX 7 download-link for me ?Thanks !Uwe

I have the following loop, going through an array, and trimming the of element i and then overwriting the element with the trimmed value:for(a=1; a <= ArrayLen(arguments.locationHeaders); a++){     arguments.locationHeaders = Trim(arguments.locationHeaders);}Every so often I get an error stating The element at position X cannot be found.  I'm looping through the very array I'm editing!  How can I be OOB...?If I refresh the browser it works fine.

I'm trying to invoke a NET webservice type REST but I have problems because first, I have to get the values and send like a object.I put the values in structs but someones I have to puthem in a list, I think so. The NET developers send me a sample of how can I invoke in net and this code Im trying to translate in CF.This is NET Codeprotected void Button1_Click(object sender, EventArgs e)    {        //Create Emission object in order to manage entities for emission process        IntegrationService.Emission myEmission = new IntegrationService.Emission();        myEmission.codSuc = 30;        myEmission.codRamo = 200;        myEmission.poliza = new IntegrationService.Poliza() {                     &nbsp

Adobe converted all my MS Publisher files automaticlly without my knowledge.  How do I change them back?

Hello,I have a site set up as default using Coldfusion 10. When I first started the website, I was using the Coldfusion Application Service as local and everything loaded fine.The client requires that I use a specific account in the service so it access certain folders that only this account has access privileges to. I did that and restarted the Coldfusion service.When I now go to the website, it gives me the Apache/Tomcat 500 error: "The server encountered an internal error () that prevented it from fulfilling this request."I do not understand why it is now trying to use Tomcat instead of IIS with just the service account being changed.I verified it has CFIDE and JAKARTA virtual directories there.Thanks,Phil Mervis

Hi AllI have a strange problem here and am hoping for a solution.Previous setup CF9 and IIS7.  At a lower level folder I enabled Windows Authentication.All I needed was the auth_user value.This worked well.I have now upgraded to CF10 and the windows authentication no longer works.I have seen the post from kevlarhttp://forums.adobe.com/thread/1031711But no matter how many time I set these nothing happens.So, at present I have both CF9 and CF10 running so that I can test this.The CF9 site with windows auth set works while the CF10 one does not.Is there something in CF10 that is blocking this?RegardsKen

I have a few PDF documents in which i have repaeting data's. i would like to extract the spoecific data i want and send it to a .csv or spreadsheet.E.g PO no. 17638765213For the above i just need the number which is coming after the word PO. How do i work and get it done?

OK, even though I'm pretty new to OOP, I've been doing great things and coming to levels of comprehension with it at a pretty amazing rate.  My backend is CF10 (dev), MS-SQL 2012.How I used to get data : Before, I would create a CFC with a method like "executeSQL" and then I'd pass it some parameters, one of which was the name of a .SQL file that was subsequently loaded, executed and then the method would return the results to the caller.  I could pass it structures full of dynamic values in the event I wanted to pass "parameters" into the script so that it was dynamic.How I should get data: This is where I'm stuck.  I am familiar with Beans, Gateways and Services, but not to the extend or interacting with Data.  In my research, I hear people refer to Beans as singular records of data and Gateways as handlers of recordsets of data.  So let's use a blog post for example.Post.cfc (Bean) - Represents a single blog post.  Used to perform CRUD-related functions