Questions

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

I need to combine  form and query codes but I couldnt make it.This is my CFML codes<cfform name="ADDADA" method="post" ><table border="3"><tr><td><strong>Musteri ID: </strong></td><td><input type="text" name="MHid" ></td></tr><br><tr><td><strong>Musteri Hareket Aciklama: </strong></td><td><input type="text" name="MHaciklama"> </td></tr><br><tr><td><strong>Musteri Tipi: </strong></td><td><input type= "text" name="Mtipi"></td></tr></table><br><input type="submit" name="Kaydet" value="KAYDET"></cfform><cfif IsDefined("form.MHid") and IsDefined("from.MHaciklama")><cfquery NAME="ADD" datasource= "DENEME" >INSERT INTO musterihareketleri (MusteriID,Aciklama,MusteriTipi)values (<cfqueryparam cfsqltype="cf_sql_integer" value="#cfform.MHid#">,<cfqueryparam cfsqlty

Is it possible to connect to an external instance of CF 2018 from the Coldfusion Performance Monitoring Toolset? We have our usual internal servers that have been picked up across the subnet. We also have 1 external server outside of this network that we would like to monitor on the same toolset. Can this be done? Assuming ports are opened etc. Dont seem to be able to set an external IP as the host for the datastore either. Initially trying it does not seem to work. Either more ports need to be opened that I am not aware of or it is not possible.  

ColdFusion and REST REST-assured, REST integration in ColdFusion is as easy as it gets! Build a simple web service from scratch and test the APIs in the REST Playground app. See the recording here. Get started with ColdFusion API Manager Monitor, measure, secure, and monetize your APIs using the Adobe ColdFusion API Manager. API Manager is a full-featured management tool that integrates all aspects of development and management processes for your API needs. See the recording here. Performance Monitoring Toolset Identify performance bottlenecks, leverage information from thread dumps, run code profiler, run memory profiler, auto-tune connectors, and much more. See the three-part webinar- Overview, Scenarios, and Troublehooting. We have more great webinars! Check out the full list at ColdFusion webinars. We have more webinars in the pipeline. Register now. Did you register for the ColdFusion Summit 2019 yet?  Now is as good time as any.   

Brand new blank system, W2K16.  Followed the lockdown guide - i.e. added IIS, required options, installed CF2018, set permissions etc.  I can access the CF Administrator but when I run the wsconfig to connect to IIS it tells me to enable the ISAPI options (Asp.net, CGI, ISAPI Extensions, ISAPI Filter).  I doubled checked my server setup and all have been selected, server has been restarted etc.   The only odd thing that differed from the documents I read was that the CF2018 installer never asked if I wanted stand alone server or J2EE installation.  It goes right from Serial Number to Select ColdFusion Server Profile.

ıam making a alittle project.ı had a sql database and tables.but ı need some information too.Iam writting code .ıts not workıng.ıs ıt true or?<cfquery name="ADD_BUDGET" datasource="#dsn#">INSERT INTOKAYITYEN(AD,SOYAD)VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" value="#attributes.AD#">,<cfqueryparam cfsqltype="cf_sql_varchar" value="#attributes.SOYAD#">)</cfquery>