ColdFusion

sample code :<cfscript>    myQuery = queryNew("id,name,amount","Integer,Varchar,Integer",                 [                         {id=1,name="One",amount=15},                         {id=2,name="Two",amount=18},                         {id=3,name="Three",amount=32}                 ]);     writeOutput("The new query is:");    writeDump(myQuery);</cfscri

[UPDATE - The following is a very long thread.  If you tire of reading all the updates, see our update below from Sep 28, 2019 for the resolution.]   The compilation below is the entire conversation Adobe deleted (how convenient) when moving to the new forums.  Unfortunately, the original links to those how posted are not live, but you will be able to read the entire conversation.  If you want to see the original post in the old Adobe forums, here it is - not sure how long the link will live. But the text of that original post and the many replies to it are offered below:   Original Post Checking in to see if anyone else out there is dealing with Adobe bait and switch based on havingan application developed in CF that other businesses use? We were sent a questionnaire earlierthis year under the guise of getting a "better deal" for our existing 3 perpetual Enterprise licenses.As a result of what was clearly a bait and switch tactic, Adobe is now claiming we are

Every time I restart the coldfusion serives I have to go back into the dsn setting for each datasource and retype the password also a deleted dsn keeps coming back. Can anyone help , this is getting anoying.

I'm trying to use ORM to CRUD some change logs. I already have a pretty simple table structure that would require 2 joins. I've created entities for both of the joined objects. I'd like to fetch change logs with these objects populated. I already have the tables. I don't have or want any official foreign keys setup; I just use the "_fk" convention to indicate it references the PK of another table. change_logs --------------- change_log_id change_log_type_id_fk message user_id_fk change_log_types ---------- change_log_type_id name users ---------- user_id name ------------------component entityname="ChangeLog" accessors="true" persistent="true" table="change_logs" { property name="id" type="numeric" column="change_log_id" fieldtype="id" generator="native"; property name="message" type="string"; property name="type" column="change_log_type_id_fk" cfc="ChangeLogType"; property name="user" column="user_id_fk" cfc="User"; } component entityname="ChangeLog

This is an age old question, and we're currently using an age old version (CF9), upgrading soon.  I'm a developer of 25 years but have only been using CF for about 8 mos. I have to get data from two different datasources and join them together.  Outer join, of course.  I've read many topics on this.  I had originally done this by looping at a query of the main table and selecting from a query from second table.  My supervisor & former CF programmer doesn't want us to use a loop/select. They first suggested a UNION of the two tables but that's not giving me the results I need. I thought of selecting from one table then inserting them into a temp table on the second datasource but when I try to do an insert into the temp table then selecting from the query of the first table, CF tells me I can't do that either with error "Executing the SQL statement is not allowed."Any suggestions on correct ways to outer join tables from two datasources w

I'm having an issue with uploading or looping through the the file names of my images to my database table.I am able to select various images and upload the selected image on my local machine to a specific folder that I designate. After the image files are put into my folder, I am having some difficulties because I want to insert the file names of the images that I just inserted into my folder, into my database. I'm trying to use the cffile parameters to do that.My question: Being that it is multiple files being uploaded at once, do I need to do a cfloop on a  cfquery insert in order to capture and insert the names into my database? My attempt at the code is below. The upload work just fine. But It chokes out at the insert portion. What do you think could be the issue?<cfparam name="form.fileUpload3" default=""><cfif len(trim(form.fileUpload3))><cffile action="uploadall" fileField="fileUpload3" destination="#cookie.c.webpathmultipleimages#" accept = "image/jpeg

Has anyone been able to inject a Docker Swarm secret into a Docker Compose file's environmental settings?  So in the documentation they have "serial" as an environmental variable we can pass in via either an env_file or just directly into the compose file (or just putting it into the docker run commnand). The issue is I can't use a Swarm secret and I don't see a way to inject it via the setupColdFusion.cfm file they want us to run as I don't see that capability via the Admin API. Has anyone been able to avoid putting in your serial/license key in plain text on a Docker Compose or Environment file?  I've tried injecting it after runtime but it doesn't seem to work.  I am a bit of a Unix novice so really all I've tried is setting the environmental variable named serial and restarting CF.  I'm curious if anyone has had any success. Thanks!

I am trying to build a query where the end-user can search a field in the table for multiple keywords. I've tried several examples I found by searching SQL forums yet I keep getting Incorrect syntax near 'keyword*'. Does CF do it differently? Something Like this....<cfif isdefined("form.search1")><cfquery name="Messages" datasource="somedatasource">Select *From SomeTableWhere AffiliateID = #Session.AffiliateID# AND Contains(messagefile, '#Form.Search1#*')<cfif isdefined("form.search2")>AND Contains(messagefile, '#Form.Search2#*')</cfif><cfif isdefined("form.search3")>AND Contains(messagefile, '#Form.Search3#*')</cfif>Order by SomeField</cfquery></cfif> Greatly appreciate any help...

The ColdFusion Summit is a confluence of everything in the realm of web applications. If you develop web applications, this is the place to be. For designers, developers, strategists and thought leaders, the ColdFusion Summit provides the perfect forum to exchange ideas, inspiration and experiences. Be there and learn from the experts! The Mirage, Las Vegas it is on Oct 1 and 2, 2019. Register today for the ColdFusion Summit!

i'm getting no images at all whenever is try to display images to the browser from a folder from my local computer. Below is the code that i'm using: <cfset webpath2 = "C:\ColdFusion2016\cfusion\wwwroot\The_Resolving_Door\photos\#cookie.communityID#\"><!---the #cookie.communityID# is the name of the folder that matches the ID of the current saved cookie---><!---output-images---><cfdirectory action="LIST" directory="#getDirectoryFromPath(expandPath('*\photos\#cookie.communityID#\*'))#" filter="*.JPG" name="dir"><cfloop query="dir"><cfif dir.type is "file"><!--- <div> ---><cfoutput><a href="#dir.name#">   <img src="#dir.name#" width="50"></a></cfoutput><!--- </div> ---></cfif></cfloop> Could i be doing something in error as a reason for my images not displaying. The images are in the actual folder but nothing is displaying? Thanks for any insight...  

Hello, all, Trying to index a SOLR collection from a database query.  If I set the action to FULLIMPORT, it tells me that I have to use FULL-IMPORT.  If I use FULL-IMPORT, it tells me I have to use FULLIMPORT.  WTF?? Anyhoo.. I've submitted a bug to Tracker.  Anyone else run across this? V/r, ^ _ ^

Hi. I output the file sizes from a <cfdirectory> list that I use, and it shows in bytes. Is there a way to make it so that if it is over 1024 bytes it shows 1KB (or 1.2, whatever the appropriate size is) and in MB if over 1024 KB, and so on... The files will get large, and I don't want to be outputting extremely large file sizes.Thanks!

How to take an integer with no leading zeros and display it with leading zeros? Thank you in advance.

We are currently trying to migrate our PROD environment from CF8 to CF10.  Everytime we try and add a CF10 instance into our cluster... the following error starts happening:java.sql.SQLException: Lock wait timeout exceeded; try restarting transactionHere are some environment specifics:Old Server:Coldfusion 8CentOS 5.x (32 bit)MySQL 5.084New Server:Coldfusion 10CentOS 6.4 (64 bit)MySQL 5.084Is this possibly driver related? Unchecking "Maintain Connections" seems to fix the issue, but I have read that unchecking that can cause more harm than good.

I created pie chart in cold fusion 2018 and add the property show3d="yes".When show3d="yes" then url link is not working but in show3d="no" case url link is working properly.I need to create 3D pie chart.My sample code is <cfchart   show3d="yes" xAxisTitle="Department" yAxisTitle="Salary Average" url="https://www.google.com/" >     <cfchartseries type="pie" seriesLabel="Average Salaries by Department">         <cfchartData item="Finance" value="75000">         <cfchartData item="Sales" value="120000">         <cfchartData item="IT" value="83000">         <cfchartData item="Facilities" value="45000">     </cfchartseries> </cfchart>Please tell me what I am doing wrong.

Hello, all, Trying to index a database for a SOLR collection, and getting a not found error message:"Error from server http://{AN IP ADDRESS}:8989/solr/myCollection: Expected mime type application/xml, got text/html.  Error 404 not found.  Problem accessing /solr/myCollection/dataimport  Reason: Not found" Now looking in {drive}:\CF2016\cfusion\jetty\multicore\collections\myCollection, there are two folders and a file.  Folders are conf and data, file is core.properties.  I am not seeing a dataimport folder.  Not sure why.  Thoughts? V/r, ^ _ ^

Bonjour,Comment fait on pour passer de mode developer en mode graphique a partir de l'administration de coldfusion ?dans settings summary, nous sommes passer en mode developer apres un redémarrage du serveur 

Hi I need help in this matterThe error which i get is this Element A is undefined in FORM.cfusion/wwwroot/ADD_DENEME.cfm: line 42  <form name="add_deneme" method="post" ><table border="3"><tr><td><strong>Musteri ID: </strong></td><td><input type="text" name="a" id="a" required="yes" ></td></tr><br><tr><td><strong>Musteri Hareket Aciklama: </strong></td><td><input type="text" name="b" id="b" required="yes"> </td></tr><br><tr><td><strong>Musteri Tipi: </strong></td><td><input type= "text" name="c" id="c" required="yes"></td></tr></table><br><input type="submit" name="Kaydet" value="KAYDET"></form><cfif IsDefined("form.a")><cfquery datasource= "DENEME" >INSERT INTO MusteriHareketleri (MusteriId,Aciklama,musteriTipi)values (<cfqueryparam cfsqltype="

Hello ColdFusion Expert,I have a question regarding flat file processing using ColdFusion.Currently at our company we used webMethod to process big data file( > 200MB) - it is working fine and fast but due to the maintenance cost is to high we decided to use ColdFusion. The question is how to process big data file using ColdFusion without consume high memory that will effect the application performance?

My question is whether or not hosting companies listed as 'Partners' have agreed to any terms and conditions - do they have any obligations?If so, what are they?If so, and they are not living up to them, who do I talk to/email at Adobe?I ask here, because I got no where on the phone with Adobe.I ask because I am using one, and I have a serious issue.Shared server environmentCurrently running CF 10 - productversion is 10,0,13,287689 - released 4 years agoThe latest CF 10 update is 21, released over 7 months ago.Aside from all of the security patches, I need at minimum update 18 - released over 16 months ago,to resolve an issue with https calls that are currently not working, despite using keytool to add certificates to cacertsI requested CF update. Their platform team is "working on it", no ETA.Further, I asked this question:My question to management was why updates are not applied in a timely fashion -the current update (10) on the site was released 4 years agothere have been 11 update

I was rather surprised to find out that in cfscript, using querySetCell inside a query loop does not set the column value immediately available for use. The column value is only present AFTER the loop is complete.for (row in query) {value = row["LAST"]  & ", " & row["FIRST"]; //value="Doe, John"querySetCell(query,"NAME",value,query.currentRow);//value of row.NAME is not setif (value == row["NAME"]) {writeoutput("Match");     //never} else {writeoutput("No Match"); //always}}writedump(query); //value of row.NAME is setHowever, if you use direct assignment, the column value is immediately available for use.for (row in query) {value = row["LAST"]  & ", " & row["FIRST"]; //value="Doe, John"row["NAME"] = value;//value of row.NAME is setif (value == row["NAME"]) {writeoutput("Match"); //always} else {writeoutput("No Match"); //never}}writedump(query); //value of row.NAME is setI find this rather disturbing. Is it a bug? Depends on how you look at

This concerns something I started in forums https://forums.adobe.com/message/11250048#11250048 which I can no longer reply to or add etc. It looks like forums have been replaced with community - is that correct? Anyway onto the subject at hand and following on from the forum thread. I have done some more testing on this issue and have found some differences in the way SOLR behaves on CF 2018 Standard v Enterprise. What I'm looking for from anyone who can help is some clarity over this issue as I currenty undertand it.  I think Charlie Arehart might have been on the money when talking about possible differences between SOLR on Standard and Enterprise as the key to understanding this issue although I would dearly love to access some documentation to clarify all of this of course. Like the hosting provider I ran the query directly in SOLR on my development machine. Unlike the hosting provider’s machine it returned an additional column in the search results ca

Can I just buy CF8 Ent and use for webhosting? I've a bunch of linux hosting. My friends want to rent a few and use for their CF app but I'm not sure that I can use the CF Ent that bought from Adobe Store or from a distributor for hosting services? Or I have to use some special licensing from Adobe for that kind of thing? Not sure about that. Because I've heard that MS has many kind of MS Win Server licensing (web hosting != internal company web server) Please suggest! Jedt S. Bangkok

I’ve been a long-time advocate for ColdFusion. There have been several threads prematurely referencing ColdFusion’s demise that I have chimed in. But now in dealing with our Adobe account management representative, I am left dumbfounded.Background: We have purchased and are using 40+ Standard CF licenses. These license purchases and use started with CF5 when Allaire still owned CF and have been upgraded to mostly CF9 but just starting CF11 -- and then the wheels fell off.Like idiots, we wanted to determine if Enterprise pricing might now work for us as were starting to incorporate a VM environment (from an all pizza box environment). In asking some simple questions our sales rep is now claiming that we are violating the acceptable usage portion of their license agreement:2.6.4 Prohibited Use. Except as expressly authorized through a separate custom hosting agreement, Licensee is prohibited from: (a) using the Software on behalf of third parties; (b) renting, leasing, lending, or granti

hello ,Iam workıng at local database.I add a new database.ıts workıng.but ı dont know that how can ı connect ıt?Are there any wrong at code?table name: KAYITYENDatasource:DENEME <cfquery name="ADD_BUDGET" datasource="#DENEME#">                                               INSERT INTO                                                               KAYITYEN               &nb