Skip to main content

ColdFusion

The official community for ColdFusion.

10000+ Posts
ScootMeadows
ScootMeadowsParticipant
 Questions
A
andrél93139241Inspiring
 Questions
Extract row ID from a query (from cfspeadsheet)

Hello,I working with Coldfusion 10.I use cfspreadsheet for reading an Excel document. The result is in query. See example below.As you see (black circled) you have the row ID 1, 2 and 3 (representing the row number of the Excel sheet).I would like to read that value. Question:How can I read this value ?Reason: I must make a query of query to filter data. In case of mistake (bad values or missing values) I must display an error message which explain that "wrong value on row xxx".After the query of query, the quantity of rows are not the same as the Excel document and the row id is not correct.My ideas is to add a column to the result of query of the query with the row id of the original query (which represent the row number).I already search on internet, this forum. But I don't know how to do that !Or any one have a better ideas?Thank you so much for your helpBest regardsAndré L'Hoir

3481
A
N
NC Beach BumParticipant
 Questions
<cftextarea> Richtext not working

Using ColdFusion 10.   I setup a <cftextarea> with richtext="yes" the correct code for the richtext toolbar.   The screen works on my PC in IE, Chrome, and Firefox.   In a demo for my dozen testers I could not find a single screen where this <cftextarea> with richtext="yes" that it worked on.  The text area was may an inch.   I did some digging and found issues folks logged from CF 8 but nothing new so I was thiking this was a bug but now in Version 10 it's been taken care of.   Also found a reference putting in the "AjaxOnLoad" command which I tried by placing the command after the closing </body> and before closing </html>.   I have tried IE 9 and IE 10 and Chrome but as far as users go it's not working.  Thanks!

39554
clifj49030817
WolfShade
WolfShadeLegend
 Questions
XMLHttpRequest.onreadystatechange - FireFox vs IE

Hello, all,I'm posting this question here because I don't have an account on any other forums, and I don't know where else to go.I have a .cfm page that is using Javascript XHR to post a single word value to itself which will determine how something is going to be processed.PSEUDOCODE:<div class="thisNav" id="getStats">Get User Stats</div><div class="thisNav" id="pruStats">Prune Stats (6 mos)</div><div class="thisNav" id="expStats">Export User Stats</div><script>     var thisNav = [].slice.call(document.getElementsByClassName('thisNav')).map(function(d){          d.onclick = function(event){getThis(d.id);};          });     xhr = new XMLHttpRequest();     function getThis(act){          xhr.open("POST","filename.cfm",true);     

15581
WolfShade
E
EDUARDOMATIASParticipant
 Questions
O
oleungParticipant
 Questions
lic62282549
lic62282549Participant
 Questions
coldfusion mobile app - connection to remote database server under cfclient tag

down votefavoriteI am writing cf mobile app and using cfclient tag. I am encountering issue with remote datasource connection and can’t get it resolve. From cfclient I am using “rooms” as my datasource string which is defined in administrator as data source. It is connecting to remote sql server. “Tblblogs” exist in rooms database, but under cfclient i get error that “No such table exist”. However, if I take same query [blgQ] that selects “tblblogs” outside cfclient, it works fine without issue. I am not sure why it is not making right datasource connection under cfclient (as defined in administrator)<html >   <body>   <h2>Add Expense</h2>   <form >   <table >   <tr>   <td>Date:</td> <td><input type="date" id="dateTxt"></td>   </tr>   <tr>   <td>Amount:</td> <td><input type="number" id="amtTxt"

39231
BKBK
Community Expert
stevenw35330200
stevenw35330200Participant
 Questions
How to troubleshoot a 502 error?

How do I begin to troubleshoot a 502 error?CF11/Windows 2012r2/IIS8FusionReactor installedI connect to twilio to send sms messages, and have a page setup to collect their callbacks when messages are sent.  They are sending me notifications that at random, they are receiving 502 errors when posting to the callback page.<html>   <head>   <title>502 Bad Gateway</title>   </head>   <body>   <h1>Bad Gateway</h1>An upstream server returned an invalid response.   </body></html> The callback page receives the info and writes to a db.  A call that usually takes 15ms to process on average.Sometimes they may hit my server with 200 call back requests pretty rapidly.  At random, 1, multiple or none of those requests may result in a 502 error.I have never physically seen a 502 error appear in the application.log, coldfusion-error.log, etc....I also have isapi_redirec

16001
BKBK
Community Expert
M
michaels29100817Participant
 Questions
MusicManMD
MusicManMDKnown Participant
 Questions
richardS5266
richardS5266Participant
 Questions
ColdFusion 2016 Application Service not starting

I recently installed CF2016 on my PC and it started up fine. However, I stopped the application service and now I cannot seem to start it back up again.It would give me the following error:"Windows could not start the ColdFusion 2016 Application Server on Local Computer. For more information, review the System Event log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 2."I checked the CF logs and found nothing pertaining to the startup failure.Here is the Windows WER from one of the failed attempts:Version=1EventType=APPCRASHEventTime=131402179068123256ReportType=2Consent=1ReportIdentifier=2bb1fc78-4189-11e7-9e2a-acfdceda6aa0IntegratorReportIdentifier=2bb1fc77-4189-11e7-9e2a-acfdceda6aa0Response.type=4Sig[0].Name=Application NameSig[0].Value=coldfusion.exeSig[1].Name=Application VersionSig[1].Value=2016.0.0.0Sig[2].Name=Application TimestampSig[2].Value=56c57b78Sig[3].Name=Fault Module NameSig[3].Value=coldfusion.exeSig[4].Name=F

27621
BKBK
Community Expert
frank000000
frank000000Participating Frequently
 Questions
Issue with Coldfusion 2016 install on Windows Server 2012

I had a successful install on one server.I tried to install on another server and it will not accept my admin password at the configuration prompt once the install is completed.  I uninstalled and reinstalled 4 additional times and it just won't accept the admin password as it was entered during the installation process.  As a result, all of the services don't start and I can't access the CF administration utility at all.The services that DO start are:ColdFusion 2016 .NET ServiceColdFusion 2016 Add-on ServicesColdFusion 2016 Application ServerThe services that don't appear in the services list on the server with the issue (but are part of my successful install on the other server):ColdFusion 2016 ODBC AgentColdFusion 2016 ODBC ServerDoes anyone out there recognize this issue?Thanks in advance.

16333
richardS5266
V
vmavmaParticipant
 Questions
I
IT-Services_AMParticipant
 Questions
D
dlegate2Inspiring
 Questions
L
LZJonesParticipant
 Questions
CF 10 Administrator

Hello,I attempted to login to the CF 10 administrator and got an error message:  "An error occurred while executing the application. Please try again or contact the administrator."Attempted to login with an incorrect password and got an error message: "Invalid User name or Password. Please try again."The username and password were not changed.I have two instances of CF Admin (Test and production) and both are inaccessible and throw the same error message (An error occurred...).The applications are running.I restarted the service successfully.Update 20 was manually completed in July 2016. I was under the impression all further updates were set to "automatically" update, but I could be wrong. My first thought is that an update automatically occurred on April 25, 2017 (Update 23) which may have caused this problem.Any Idea why I can't login to the administrator?Thanks,Lucy Zoe

5620
L
K
kt03Inspiring
 Questions
T
tmessierInspiring
 Questions
cfdocument running slow when generating PDF

I have two servers configured the same way. They're running CF 8 Enterprise (exact version is 8,0,1,195765), Java version is 1.6.0_04. Servers are Windows 2008 Server Standard. On one of them, generating PDFs using CFDOCUMENT is very fast. On the other it's painfully slow, can take minutes for a simple PDF. I've checked everything I can think of on the two servers and they seem pretty much the same. I checked the iText jars, they appear to be the same as well. I've seen other people post with slowness issues, but many posts relate to dynamic images, which are not an issue here because I have a PDF with no images in it. I'm totally out of ideas as to what could be causing the difference in performance. Anybody else run into this and find a solution?

49943
W
blue snaggletooth10873542
blue snaggletooth10873542Participating Frequently
 Questions
A
ACS LLCInspiring
 Questions
S
samdParticipant
 Questions
Default ScriptSrc folder plus strictnumbervalidation

I have a ColdFusion 11 server set up and I've set one up and it works fine with no problems. However on another server that is built I can't get the following working at the same time together.I have my DefaultScriptSrc pointing to a newly named virtual directory in IIS as per the lockdown guide. For instance I have a virtual directory called "cfscripts".  This virtual directory points to the CFIDE\scripts directory in IIS.  Therefore in CFadmin I have the parameter set to "\cfscripts\"1. Cfform works just fine.  You can clearly see that it's looking for cfform.js in src="/cfscripts/cfform.js"2. However we set the parameter "strictnumbervalidation=false" at the top of our code in the apps as we want it to behave like in prior ColdFusion releases.  This does not work.If I change the virtual directory cfscripts to point to CFIDE instead of CFIDE\scripts then the strictnumbervalidation works but the cfform doesn't. I'm not sure why on this server it works this way.

4001
BKBK
Community Expert
WolfShade
WolfShadeLegend
 Questions
Complex query - Oracle 12

Hello, all,I'm not really sure if this can be accomplished.  But I'm going to give it a try, and I could really use some help with a complex query involving two tables (many-to-one, relational).First, a little background.  Oracle 12 database.  Chained commands are disabled.  Stored Procedures are not allowed.  (Not my choice; these are upper level decisions, above my paygrade.)  This is a very weak metrics-ish project.  Basically do a very, VERY lame job of "fingerprinting" a client browser for tracking purposes (but not the nefarious tracking you might be thinking of - it's to see in what order which links of one of our sites is being utilized, believe it or not to improve UI/UX.)The reason I am bringing this question here?  Because I am OCD when it comes to keeping databases as small as can be, and I want to run a scheduled task once a month that will prune the data - under specific conditions, just about anything older than 6 months.TABLES:web

3371
BKBK
Community Expert
J
junglefishParticipating Frequently
 Questions
cffile, accept, .docx misreporting as .zip

Using CF11, MacOS.I have a file upload which accepts doc, docx, pdf. Doc and pdf behave as expected. However, whenever I try to upload a docx I receive the following error: "The MIME type or the Extension of the uploaded file application/zip was not accepted by the server".I saw that there was a similar bug that was meant to be fixed in CF11, see this thread: Tracker My cffile tag looks like this:<cffile action = "uploadAll"  fileField = "arguments.stuData.addDocuments"  destination = "#dirTemp#"   nameConflict = "MakeUnique"  result="arrResult"  accept = "application/pdf,application/msword,application/vnd.openxmlformats-officedocument.wordprocessingml.document,application/x-tika-msoffice"/>Can anyone help?

12021
J
I
inAfogParticipating Frequently
 Questions
Anyone have success connecting server to server with Google API from Coldfusion?

I have been working for weeks trying to interpret and follow the instructions on Using OAuth 2.0 for Server to Server Applications for connecting our work SQL based calendar to our Google calendar. I first tried directly interacting using HTTP but was not successful in creating the correct signature, even tho I used Ben Nadel's 2015 JSONWebTokens.cfc as a resource. Then I came across Java Integration Guide CFML Documentation and realized that it might be possible to use Google's provided JAVA client library, which would be ideal for security reasons.  Has anyone successfully connected server to server with Google APIs using either method? If so, I could really use help.Here is where I am stuck in the JAVA route:I have downloaded the Google APIs Client Library onto my server test folder, lets call it /usingJAVA/calendar/I have an application file in /usingJAVA with the following lines indicating JAVA class file paths:<CFSET this.javaSettings = {loadPaths = ["/usingJAVA/calendar/

12901
I
M
mugeshmParticipant
 Questions

Resources

Community Guidelines Help Center Learn tutorials
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices