ColdFusion

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

We are moving FROM: Internally built web-based training courses using CF8 environment; not SCORM-enabled TO: new LMS hosted outside the firewall. I'm looking for infomation from anyone who has done this, or can it be done? Can we SCORM-enable our current courses (built using Dreamweaver, embeded Flash, Coldfusion pages with SQL database access) and get them to commuicate with the LMS remotely? We are a year away from this, but I need to know if all the content we built with CF is going to be able to be used in this new environment. Any resources out there that addresss this?

This may be an Acrobat question, but I'll start here.I am trying to do a mail merge using CF <cfpdfform tag.I have a query with 100 records that loops through the PDF with these form fields.My query loops through and adds/inserts the query values to each PDF and creates 100 pdf's with the filled in values.Because I don't need to worry about the length of any of these values, It works great.But here is where I have my issueWhen the query value is within a sentence I don't know how large to make the text field on my blank fill in PDFWhen the city name is Ida the field needs to be a certain width and when the city name is Oklahoma City it needs to be a much larger width..Is there a way to deal with this?ShouldI be using a different way to merge query data with these PDFs?

I have a session timeout of 4 hours for my application.If I am logged into my application on 3 different devices like thisLogged in times for devicesDevice 1 - 4 hoursDevice 2 - 1 HourDevice 3 - 5 minutesIf my session times out on Device 1, does it end my sessions on the other 2 devices?

I am using GetHttpTimeString() function to get the current date and time in UTC/GMT. But when I format it using DateTimeFormat, its returning different results:In CF2016, when I do this:<cfdump var="#GetHttpTimeString()#"><cfdump var="#DateTimeFormat(GetHttpTimeString(), "yyyy-mm-dd HH:nn:ss")#">it will return:Tue, 18 Sep 2018 17:44:27 GMT --> UTC2018-09-18 17:44:27 --> still in UTCIn CF2018, when I do this:<cfdump var="#GetHttpTimeString()#"><cfdump var="#DateTimeFormat(GetHttpTimeString(), "yyyy-mm-dd HH:nn:ss")#">it will return:Tue, 18 Sep 2018 17:44:27 GMT --> UTC2018-09-18 12:44:27 --> current date/time in my timezoneUnless I pass a third argument for the timezone, it will use the server's timezone by default.Is this an intentional change, if it is, I can't find anything in the 2018 Release Notes.Thank you!Ollie de Guzman

Hi, Is there an updated version of the: ColdFusion11_CFMLRef.pdf with the new tads/functions on 2018?Thanks

Hi I have the variables set <cfif orderID = 5>      <cfset stype = "'ABC124','DEF567'"><cfese><cfset stype = "'VACD123','KHOL567'"></cfif><cfquery name="qQuery" datasource="#ds#">select .....from............where ......and serie in in ('#stype#')</cfquery>when out put the query, I got below (1) which is not right because nothing returned.  When i run the query and hard code like 2 I got records.  What did I have wrong here? Thanks1) serie in ('''ABC124'',''DEF567''')2) serie in ('ABC124','DEF567')

I receive the error: "Entity input stream has already been closed" when accessing my REST web service performing a GET operation.  Any insight to this problem would be much appreciated.

I upgraded to CF2018 from CF2016, running on a Windows 2016 Server with IIS. I am using subdomains.  Example: A user logs into app.mydomain.com using cflogin and they click a button to create a batch of work to do.  The button click launches an ajax remote call to job.mydomain.com to setup a job queue in the database sets a task in the CF Scheduler.The scheduler launches the job page on job.mydomain.com that queries the job info.  It knows what subdomain it was from and what user created it, so within a cfthread it executes a remote call to app.mydomain.com and does a cflogin allowconcurrent=true for the userid that was sent.  This way it can know the permissions and whether this user can process it.In CF 2016 it works great.  Upon upgrading to CF 2018 it logs the user out as soon as the scheduler runs and does the cflogin within the thread. Does anyone have any idea what might have changed from 2016 to 2018 that may have broken this?  Or any ideas how I c

All,I got my CF2018 up and running, nice and secured, with a copy of our production webfiles.  I am now attempting to apply hotfix-1 against the environment.I download the file from the updates area (our servers do not allow external internet connections) and attempt to run the jar but it seems to be failing in the pretasks stating I do not have sufficent privileges.  Basic info: Have full access to all drives impacted (read/write/modify)Have access to start/stop the service (windows 2016)I am using Oracle JDK 10.0.2 java.exe to run the command lineThe summary states: Summary-------Installation:  Cancelled during pre-install.32 Successes0 Warnings0 NonFatalErrors0 FatalErrorsSo it stats the user account should have rea/write privileges to the files in the CF root directory and to start/stop the service.  Yet the log starts I have all the access and each part is successful..  Is there a better log file than the one created during the .jar installation?

Is anyone experiencing any non-display issues with coldfusion maps/Google map API? I am using coldfusion 2016 on a windows 10 laptop. My maps are not showing up in real time on my PC or on my smart phone Whenever I make it live. It is showing up fine on my PC in the development mode. What I am trying to accomplish is to dynamically produce map markers based on the address of our club members. Could I be missing something?  Or is there an easier alternative to Google maps that I can dynamically produce the same results using another map provider? My application.cfc page <cfset this.googlemapkey="AIzaSyDy_iL-h-2CxckkV4dh-agNjbMLHFHu0pQ">On my locations.cfm page<cfmap name="fruit" height="300" width="1200" centeraddress="714 W. Main st. Richmond, va 23219">  <cfmapitem name="my_address" markercolor="cccccc" address="511 W. Marshall St. Richmond, Va 23220"><cfif #session.user_id# EQ "#scois_verify.scois#"> Google Maps<cfmap name="Fruit Map" height="600"