Questions

Can someone point me to a link or do I have to buy a 64 bit computer

Hi Friends,I have coldfusion9 in my application server. I have integrated .Net dll into CFM page. Its currently working fine.Now installed ColdFusion 16 trial version on a new server. Moved ColdFusion 9 code to new server and everything working fine except .Net integration part.I am getting error "DotNet Side does not seem to be running.Ensure that the DotNet agent is running and you have provided the correct host and port information "My dotnet dll registered in "GAC_MSIL"My server is WIndows 2008 R2 32bit.I don't know what i am missing.Please help me.Thanks,Ashok Mohanty

I have HTML fragments with embedded CF tags stored in a field in my database. When I read the field from the database, I want to have the CF tags, etc. evaluated and store that in a string.  Let's say Text contains "This is my #Content#" and Content contains "substituted content".   I want both to be evaluated (recursively) so that the substitutions take place correctly and I end up with "This is my substituted content".I have tried this, but all I get is Final containing "This is my #Content#".    <cfsavecontent variable="Final">        <cfoutput>        #Text#        </cfoutput>    </cfsavecontent>Is there any way to get this recursive substitution to happen?Thanks!

I have a name field in my database like this -table has 15M rows'Jones, Albert Louis'Where the field is like thislast name, first name, middle nameI have a cf search that the user can enter a first name and last name and a middle name that searches that fieldI have everything indexed properlyWhen I do this query I get results immediatelyselect * FROM table wherename LIKE 'Jones%'  But when I add the first name the query never returns results or takes a very long timeLike thisselect * FROM table wherename LIKE 'Smith%, John%' Is my syntax correct? Is there a better way to do this query?

Hi,I created the schedule runs every 30 minutes.  It shows the last run in Oct-10-2018 08:20:00AM, but I didn't get anything.  I then click on the green icon to manually run the schedule task and it was  was completed successfully, but again, I didn't receive anything.  I then try to manually copy the url and run it in the browser and it worked.Can anyone please help?

Hello,I currently have a table that displays the data from a query.  I would like to make it more flexible so I would like to use CFGRID to output the information instead (for pagination, sorting, outputting to MS Excel etc.).However, I need to change the cell color of certain fields based on the data in those fields.  For instance, if the value in the certain field is 0-30 I need it to be red, if it is 31-60 I need it to be yellow and 61-100 I need it to be green.I remember doing this last summer for one of my clients, but I was under a fairly strict NDA and couldn't keep any of my notes/code and I don't recall much about how I went about doing this.  There is probably a better way than what I did in any event.I think it had something to do with writing the query to a new query and wrapping the values with some CSS code for the color as i processed it.I rather doubt that I am the first person to ask this question, but I haven't been having much luck finding the answer s

Hi,I am working on printing the labels with a particular network printer ( TCP/IP ), when the user click a button on UI.CUPS is installed but didn't configure the printer yet. Whats the next step, after configuring it in CUPS control panel?Have no clue on how to get this done!!! We are using Coldfusion 9.Thanks

Hello,cfimap is unable to read emails when users send emails with xlsm attachments. No issues with xls files. Has anyone experienced this?An exception occurredwhile performing action GetHeaderOnly in cfimap tag.          Error Detail: Thecause of this exception was: com.sun.mail.util.FolderClosedIOException.Thanks!

Hi,I'm on CF 11 and have Fusion Reactor 7.4.2 up and running. Under Requests => Setting => "Request Content Capture" I say Reactor should capture Requests and Responses.I perform an AJAX Requests and get an error as an argument does not contain a JSON string as expected. I disable Request Capture again, and everything works as expected.My AJAX call looks like$.ajax({    url: "my.cfc?method=myMethod&_cf_nodebug=true",    data: {        listType : 1,        userID : 1,        listID : 1,        extraField : JSON.stringify( {"myvar":1} )    },    type: "POST",    success: function(data){        //    }});When Request Capture is enabled, the resulting "request.header.xml" file has a parametermap with all the values incl

Hi,Trying to render the html code to PDF. I am having a hard time to figure out a way to render bar-code font using cfdocument.- Tried installing the bar-code in local machine, didn't work- Tried copying the font files to docker Image, didn't work- Used @11220649-face in style, still didn't work None of those are working . Appreciate it, If anyone can jump in for a help. ThanksVishnu<cfdocument             format="PDF"             pageType = "custom"             pageHeight = "3"             pageWidth = "4"             margintop="0"             marginright="0"             marginleft="0"    &

I have a geo database that I use to look up the users country based on IP number.I've noticed that the IP is the same for all users and therefore everybody apparently lives in the US I believe this is because I've added the site to a load balancer., it's acting like a proxy and replacing the IP.I've tried the cgi values - remote_addr and also http_x_forwarded_for (which is empty - I guess the data center has to set it to forward the IP)Is there anything else that I'm missing that might sniff out that IP number?Failing that I'll just take it off the load balancer and move the static HTML files that I do want on a load balancer onto separate servers, but I'd really like to know if there's a fix using CF before I do thatAlso reached out to the ISP, maybe they can tweak the load balancer to forward the IP

Good Day all.I have wriiten a cfclient app. The app was working perfectly until almost a year ago. then with Adobe phonegap removeing support for cli 3xxxThen the app stoped working.On the server the app works perfectly but when i try build and run the app on android i get gthe following error.Error invoking CFC http://fqadmin.atstech.co.za/cfc/users.cfc: Not found [Enable debugging by adding 'cfdebug' to your url paramaters to see more information]Now the CFC is there going to http://fqadmin.atstech.co.za/cfc/users.cfc?method=getUsersListI get the users list in JSON format -> the above is for test purpose only.So i know the server cfc is not only there, but it is working with no errors.Please find attached zip file of source code / including the server CFC,Also please see screen shots of the setting on my cfbuilder project.Latest Build from phonegap - You can see error using apk belowhttp://fqadmin.atstech.co.za/apptemp/ATS-FQ_3321208.apkCFbuilder Applicationhttp://fqadmin.atstech.

Can somebody explain how to define a remote function that will accept POST and then process a json object in the request body?<cffunction name="examplePostEndpoint"      consumes="application/json"      produces="application/json"     httpMethod="POST"     returntype="string"     returnformat="json"     access="remote">     <!--- <cfset s = "#getHttpRequestData().content#"> --->     <!--- How to get body in here and convert to a struct? --->     <cfcontent type="application/json" >     <cfreturn serializeJSON({"some": "data"})></cffunction>

Bonjour,Je cherche à faire un composant ou un include pour faire une table qui alimente une autre table ( Pays - ville).Etant débutant, j'ai trouvé du code sur un site mais malheureusement ...<cfcomponent><cfform name="mycfform">  <CFQUERY datasource="#session.dbname#" name="AddTable">SELECT Pays,VilleFROM MondeWHERE sitename='#session.site#'  <cfselect name="#Pays#" bind="cfc:bindFcns.getpays()" bindonload="true">  <option name="0">--#Pays#--</option>  </cfselect>  <cfselect name="#Ville#" bind="cfc:bindFcns.getvilles({#pays#})">  <option name="0">--#ville#--</option>  </cfselect>  </CFQUERY></cfform></cfcomponent>Merci par avanceMarc

Hello all!I'm tryin to reinstall coldfusion 10 x64 on windows 2008 R2 64 after uninstall.The installer show me this warning and error.I manualy delete installation folder and all registry entries.Colud you help me?

In our application, we are running a large query with  100k rows and then displaying it in HTML. Then an Export button triggers writing the report to an Excel spreadsheet in the .xlsx format using the <cfspreadsheet> tags. We are finding that the memory usage for creating this report and writing the file jumps the memory usage up by about 1GB. The problem is that it is not released for a while by GC. When we have multiple users running and exporting this same type of report, the memory keeps climbing up and reaches the heap size allocated and kills the serer's performance. A reboot is usually necessary to clear it out. Is this normal expected behavior or how should we be dealing with this issue? Is it possible to easily release the memory usage of this operation after the export has completed so that others running the report readily get access to the freed up space for their reports? Also  SpreadsheetSetCellValue, SpreadsheetFormatCell take much memory.And the final ou

Hi all,We have some old servers running CF-9.They connect to an Oracle server. No problems. The datasource is set up in CfAdmin, everyting funcions fine.Now I would like to set up a developer-site on my workstation - a Windows10, and I have Java10 installed.I install Coldfusion-2018, developer edition. Everything seems to be ok. The service starts, and I can run a little script in my browser that dumps out the server-configuration.Then I try to set up a datasource (DS) to an Oracle database on a server.The server is across a VPN-tunnel, but everything should be set up properly. I have Sql Developer installed, and everything functions fine from that utility.But I do not get a connection when setting up the DS in CfAdmin.Having done the DS-parameters and pressing Submit, It says in the bottom left corner: "Waiting for 127.0.0.1", and after some 30 seconds this msg is returned:Connection verification failed for data source: MYDATASOURCE java.sql.SQLException: Timed out trying to establish

hi, anyone successful in running cf11 with apache in Mojave?  i get an error with mod_jk.so, something along the lines of mod_jk.so is invalid, needs to be signed...thanks in advance..

Bonjour a tous,Voici mon problème,quand j'essaie d'installer coldfusion, lors de l'installation j'ai un warning et une erreur, le warning est que je n'ai pas les droits administrateurs et l'erreur est"Error: Services Marked for Deletion"One or more of the $PRODUCT_SHORT_NAME$ services are currently mared for deletion. Restart the computer and then restart the installer to continue with installation."Quelqu'un a déja eu ce probleme ?Merci !M

While working through my migration from Windows Server 2008 to Windows Server 2016 (clean install) I came across a problem, none of my CFM files would load, I just got a 404 error.I was running IIS, my root was the default innetpub/wwwroot for the CF2016 install, but my web sites are in another directory.When I installed my 2008 server some time ago everything went fine. I did recently notice the two mappings for CF_scripts and Jakarta, and wondered where they came from. I'm pretty sure CF was installed and then I went to IIS to add my sites.This time things were different, after pulling my hair out for an hour or two I realized that those mappings were not present. I ran the Web Site Configuration Tool, removing the ALL setting and then putting it back, and all of the mappings were now present and the sites were now working fine.The question I have is, why am I now having to run this when I didn't have to do it before and does this mean I'll need to run it every time I add a new site?

Hi there,Wondering if Coldfusion * can be installed on WIndows 10 Ent 64 bit.Joe

I've ran into a strange issue while working with comments in excel spreadsheets. When not using xmlformat (.xls) comments work fine, but if I start using xmlformat (.xlsx) I start getting "Multiple cell comments in one cell are not allowed".  I'm running ColdFusion 2016I'm including a snippet of code below that will work fine for .xls style documents but error out for .xlsx style documents.<cfscript>  // Runs without error  mydoc = spreadsheetNew("Test", false);  setComments(mydoc);  spreadsheetwrite(mydoc, "#expandPath("./")#test.xls",true);  writeoutput('<a href="./test.xls">Download good</a><br>');  //Throws java.lang.IllegalArgumentException: Multiple cell comments in one cell are not allowed, cell: E9  mydoc2 = spreadsheetNew("Test", true);  setComments(mydoc2);  spreadsheetwrite(mydoc2, "#expandPath("./")#test.xls",true);  writeoutput('<a href="./test2.xlsx">Download bad</a>');   

I have a MySQL query of table column where I want to include ONLY values that have letters and commas.(but does not need to have a comma)I want to exclude any records that contain any number or special character that is not a commaThe field contains names like this that I want John, Smith  or John SmithBut a lot of others are likeJohn, Smith 1234John, Smith**John/SmithJohn, Smith 255-4422that I don't want.How do I exclude these from a MYSQL query?

(CF2016/MSSQL 2008)I have a need to move data from one table to another for multiple records.At the moment I am using a CFLOOP to execute multiple queries which I know is not an efficient way to do it.The data types are the same, although the field names in each table is different.I believe it can be done with an insert select statement, something along these lines:<CFQUERY name="MoveData" Datasource="MyDatasource">INSERT INTO DestinationTable (DestinationField_1,DestinationField_2,DestinationField_3)SELECT (SourceField_1,SourceField_2,SourceField_3)FROM SourceTableWHERE Something = MatchingValue</CFQUERY>However, I am a little stuck, because one of the values, let's say for arguments sake it's SourceField_2 will not come from the SELECT query from the destination table, it is actually a value which is part of a submitted list that I am looping over.<CFLOOP LIST="#submitted_game_uid#" INDEX="game_uid">So what I want to do is open the CFQUERY above the loop, and then t

Playing a bit with CF.I have a page that's working fine pulling info from MSSQL.So for example if I do a search for 'Smith' it pulls all the Smiths as followsSmith, R, DOB, Address, etcI would like to have a link for each record pulled that the user clicks on to get more detailed information about that Smith.How can I do this?Thanks