Questions

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"

Hi,I am trying to implement session rotation using the article at https://www.petefreitag.com/item/829.cfm I have added the relevant code to onSessionStart and added the jeeSessionRotate function to a component which i call when the user has been successfully cleared to login. I have called the function immediatley before where I call sessionRotate(). Problem is im getting a "setAttribute: Session [844E2EA3A042B40B5EA2545FC43C07FA.cfusion] has already been invalidated"  error. Anyone know what I'm doing wrong here?Thanks,Paul

We need some SOLR collections for searching. To this point, we create the collection via the admin page, and thenwe configure the /dataimport in solrconfig.xml in the collection folderwe configure schema.xml in the collection folderwe configure data-config.xml for the /dataimport in the collection folderIs there a way for all these steps to be done programatically?I assume that the <cfcollection> tag creates a collection but does only what the admin interface does.Is there a way to do all this configuration via cfms/cfcs?

My goal here is being able to identify if a file is correctly formatted or not for reading in cfspreadsheet. Technically speaking "Does this file have these X columns? (yes/no)". I don't care how this is done... but I have no other means to do it than subject it to cfspreadsheet action="read".One of the biggest challenges when dealing with imports is getting clients to use "clean" files. I've run into several situations where they will "hide, merge, etc" columns and entire tabs. Recently a client attempted to update 100 records where a tab had been "hidden". There wasn't a lot of data and due to privacy I can't share that file, however I can confirm that something about this excel sheet would trigger incredibly high cpu usage until such point that ColdFusion would crash. cfspreadsheet details:adding query="" was the trigger to cause coldfusion to use high cpu and then crash so something about trying to build it's struct was the cause.the information provided by name did now show all th

Hi all. I am using orms, so my application takes a while to start (about 3 minutes)I would love to be able to display something to the user - e.g., Starting xxx, please wait...When I add a <cfoutput> as the first line of onApplicationStart (output=true), nothing displays (index.cfm is executed).If I add <cfflush> after the <cfoutput>, message displays (index.cfm is not executed!)Any ideas?

Good morning,i am using CF2016 on a window PC.At my job i  have the role of adding new hires into our card reader box so that new employees can enter into our office. I often can get up to 10 new employee request per day. I devised a rather complicated way of converting each character of their last name into a number format so that i can quickly punch their name info into nine-digit keypad of the card reader box. The letter arrangement of the key pad is similar a touch-tone phone.I currently have two Cf pages to do what i need. The first page is a basic form with 6 text boxes that will only allow 1 character per box for the person last name. the second page is a series of conditional statements that will assign a numerical value to each character.What i want to accomplish is to have one text box that i can enter the entire last name of the new employee and then have Coldfusion separate each character from the input box of the previous page and assign then display the same numerica

Hi,I'm having trouble figuring the logic on how I can output this information.Basically, I'm querying a yearly report from my database where some donors post as "Anonymous" per year. Problem is, once they give "Anonymously" at any given year, their name stops showing up, and appears as "Anonymous" for the following years, including the previous years as well.The list should only list "Anonymous" for the current year that it is pulling the information from, if they have given anonymously for that year. Otherwise, it should just show their name.I am not sure if I need to set the years as a loop and then set an "<cfif>/<cfelse>" statement. Any help would be appreciated.This is my code where it outputs the information:<td><cfif SalAnnRep_Ovr IS NOT "">#SalAnnRep_Ovr#<cfelse>#SalAnnRep#</cfif></td>The data that I am pulling from my DB:<cfquery datasource="gnConstituents" name="GetCon">SELECT IDCon, Ca_First, Ca_Middle, Ca_Last, Ca_Suffix, isSc