ColdFusion

Hello,We're running CF 11 Standard Edition on Linux and need to connect to an Oracle database.  We've done this before on CF 9 using Oracle's JDBC drivers (ojdbc5.jar and ojdbc6.jar).  I downloaded the newest JDBC drivers from Oracle, but soon discovered that CF would not start with these drivers installed.  When I downgraded to the older version installed on our CF 9 instance, CF 11 worked fine and we could connect to Oracle.  I am installing the jar files into /opt/coldfusion11/cfusion/wwwroot/WEB-INF/lib.These older drivers work fine:/opt/coldfusion11/jre/bin/java -jar ojdbc5.jarOracle 11.2.0.2.0 JDBC 3.0 compiled with JDK5 on Sat_Aug_14_12:16:40_PDT_2010#Default Connection Properties Resource#Mon Jul 13 14:14:59 EDT 2015/opt/coldfusion11/jre/bin/java -jar ojdbc6.jarOracle 11.2.0.2.0 JDBC 4.0 compiled with JDK6 on Sat_Aug_14_12:18:34_PDT_2010#Default Connection Properties Resource#Mon Jul 13 14:15:04 EDT 2015These newer drivers do not:/opt/coldfusion11/jre/bin/ja

We upgraded from CF9 to CF11.  We copied the cacerts file to the new server but now am getting handshake failure with cfhttp tag.  Spoke with tech on their end.  He said he sees the original request come in.  They send back their part of handshake and are expecting to see something from us which they are not.  Turned on SSL logging and can see the verbiage "valid certificate found".  It just appears that for some reason we are not completing the handshake.  All we see in logs after clienthello portion, serverhello portion, serverhellodone portion, is I/O exception handshake_failure.  Is there anything special in the CF11 upgrade that needs to be done in order to configure for SSL cfhttp tag to work?

Hi,When using the CF9 in-build Oracle driver, the query works well, but when it is changed to use the ojdbc6.jar, then getting the below issue.ORA-00933: SQL command not properly ended.Issue particularly happens when we do an Insert using a select query inside cfquery. i.e.INSERT INTO Table1  (  id  , name  , viewtime  )  SELECT   tab_id as id  , name  , viewtime  From Table2

Good pm!Client is interfacing with me through web service. My soap response looks like this<?xml version="1.0" encoding="utf-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">  <soapenv:Body>    <ns:WhatPasswordResponse xmlns:ns="http://ws">      <ns:return>password </ns:return>    </ns:WhatPasswordResponse>  </soapenv:Body></soapenv:Envelope>but client is expecting it to look like this<?xml version=”1.0” encoding=”UTF-8”?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body>    <ns2:WhatPasswordResponse xmlns:ns2="http://ws">      <ns2:return>password </ns2:return>    </ns2:WhatPasswordResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>I have already tried passing xml as string, but client does not

     Hi guys,I'm trying to create multiple pdfs with <cfdocument> tag inside a loop.When I say multiple pdf files , the counter could reach up to 1500 files.The result should be a zip with all the files .    The problem is that after a while the request crashes because of : java.lang.OutofMemoryError : java heap space .    My question is : has coldfusion a limit in generating <cfdocument> pdf files? I tried also , to break all this action into multiple threads , putting only 100 pdf files on a thread, but even so some of the threads ended with java heap space error.     Have anyone of you encountered this problem before ? Any tips or help it will be gratefully apreciated.     Best Regards,      George T.

Disclaimer, I'm just barely past beginner CF developer. I am using cfspreadsheet to open an Excel document and read some values from the first sheet. It blows up with "An error occurred while reading the Excel: org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException" and specifically "</font> does not close tag <br>."I've Googled left and right trying to find good material on Reading/Writing Excel with CF but not really finding much. Here's what I have:<cfspreadsheet action="read" src="#theFile#" sheet="1" query="data">Besides not knowing exactly how to read what I need from that (yet) I can't get that far because it crashes. Specifically I need to read B2, E2, B3, E3, B4, E4, B5, E5, B6 and E6.Anyway, this particular spreadsheet has 9 sheets, but I only need to read those values for sheet 1. The problem is in sheet 5, column M1 there is a button that has text that wraps and says Reset Data. I KNOW that if I remove the word Data from it, then I can

I have a basic question on how to handle a simple notification system.  I have an intranet site that contains a simple blog.  When someone creates a new blog article, I would like to notify users with a badge or any notification method.  What is the best way to handle this?  Timestamp the blog post and compare it to the last time the user logged in?  I assume there is a simple lightweight way to do this.  I can write some process that compares timestamps but I can see this method getting klunky.  Should I consider using a push system once a blog post is created?  thoughts?

Hey Group.I have 36000 files or so on a windows 2008 server.  CF11 Enterprise Update 5Love SOLR indexing for it's speed but having issues with some of the docs.  PDFs especially.  These are documents of a legal nature so i cannot share them but the problem is pretty straight forward.I get the: "Could not index the file [path here] .pdf in SOLR. Check the exception for more details: An error occurred during the extracttext operation of the cfpdf tag.When i run cfpdf extract on the file I get invalid document [path] specified for source or directory.cfpdf action="extracttext" source="http://localhost/[path]" name="mypdf"When I run the same with useStructure="false"cfpdf action="extracttext" useStructure="false" source="http://localhost/[path]" name="mypdf"and dump the variable I get all of the text along with what looks like poorly formatted xml (xml closing tags missing) I dont really care if that is how I get the data as it is only used to let the uner know what document

I have a very simple which is working in CF8 using IE10<CFHEADER NAME="Content-Disposition" VALUE="inline; filename=sammy.jpg"><CFCONTENT TYPE="application/unknown"    DELETEFILE="No"    FILE="c:\inetpub\mysite\sammy.jpg"  reset="Yes">I recently upgraded to CF11 and now the same code is not working on IE10, but amusingly it is working in Chrome and Firefox.Any clue?

Our company intranet site was built by a third party.  It's been using CF MX7 Standard.  They have an upgrade for the site which requires CF 8.01 or better.  I'd read of issue with 10 and thought it safest to upgrade to 9.  What's the procedure for upgrading?  I gather I need to purchase 11 with a downgrade to 9.  I understand there's a utility in the developer edition that analyzes the site for issues, which I'd like to use.  Thanks for any help.

We are using CF10. I am writing a query that feeds into an adobe report builder report. Several tables are involved.I need the name, address, and the checklist items on one row. There can be up to 3 checklist items per name, one name, one address.The data looks something like thisJoe Student123 MainHIJoe Student123 MainPDSam Student124 MainJPAnne Student125 MainHIAnne Student125 MainJPThe output should look like this:Joe Student     123 Main     HI     PDSam Student   123 Main    JPAnne Student   123 Main    HI     JP

Can ColdFusion 10 be configured to work with the Oracle 12c drivers? If so, what are the configuration instructions?Thank you for your time.

after applying update 16 it says:  10,0,16,293399(PreRelease)      is this accurate?   is PreRelease the production version of this update?

We have a purchased license for ColdFusion Version 10 Enterprise on Windows and Solaris platforms.  We need the linux platform installation file. How do we download it?

Hi. I have a search page that searches on a part number. It displays results into a table dynamically. The rows are ordered by a field called ECID. It's just an auto number field I have set up in Access. There are different numbers of rows that are displayed each time a search is done depending on what was searched. I would like to only show the first result for a different search I want to do. How do I do that? I don't have a cfoutput query. Instead I'm using a cfloop query. I can't remember the reason, but I think I needed to use this. I know in a cfoutput query I could use the maxrows function, but I can't use it in a cfloop query. Does anyone know how to get only the first row to display? Is there some other way to make this work? My cfloop query looks like this: <cfloop query="MainActionSearch"> Thanks.Andy

Hi,I just recently upgraded to ColdFusion 11 from ColdFusion 10 and noticed that quotation marks are not being escaped in ColdFusion 11 when those are entered in a textbox.Here is an image from my ColdFusion 10 server where the quotation marks are automatically being escaped.Here's the view source from Google Chrome:Here is an image from my ColdFusion 11 server where the quotation marks are NOT being escaped.Here's the view source from Google Chrome:Does anyone know if this expected behavior or a bug? Do we really have to use EncodeForHTML() on every form field value now?

I am having an issue where my variable output is displaying the variable name and not it's value. I am currently using a MacBook Pro running OS X Yosemite. I am using ColdFusion Builder 3 to build the code and MAMP to run a local server. I have a very simple output to test whether or not I am getting correct output. The code is as follows:index.cfm<!DOCTYPE html>    <html>          <head>                <title>Demo</title>          </head>          <body>                <h1> hello world</h1>                <cfset name = "John">     &n

Does anyone know where I can download Coldfusion 10 standard?

Can ColdFusion 11 process .htm and .html extensions?

Hi,This is for a legacy site. I'm not the person who developed it and am new to Coldfusion. This is happening when doing a search query.Cold is old but running on CF9. Previous db was MSSQL 5 but was converted to MSSQL 14 during this conversion.Code<cfquery name="registrylist" datasource="#DSN#">  SELECT  Registry.registryID  ,Registry.categoryID  ,A.textImage  ,Registry.categoryOrder  ,B.InvName  ,B.retail_price  ,C.brideLastName  ,C.brideFirstName  ,C.groomLastName  ,C.groomFirstName  ,Registry.ProductID  ,Registry.quantity  ,Registry.quantityGot  ,Registry.inventoryType  ,Registry.nonInvDesc  ,Registry.nonInvPrice  ,Registry.nonInvDesc  ,event.eventDate  ,EventType.eventName  ,event.eventID  ,C.RegistrantID  ,B.Desc_Short  ,B.img_large  ,b.Personalize_Flag  FROM Registry,event  ,registryCategory A  ,products B  ,registrant C  ,ev

Aloha All,Thank you for any help in advance.  I am attempting to insert the image name into a database so I can recall it later.This is my code for uploading the photo.<cfif isDefined("form.image") >    <cffile action = "upload"         fileField = "image"         destination = "D:\home\manpcs.com\wwwroot\Realtor\images\"         accept = "image/jpeg"         nameConflict = "MakeUnique">        Done uploading image!        <cfoutput> #form.image#</cfoutput><cfelse>    <cfform method="post" action="test.cfm"         name="uploadForm" enctype="multipart/form-data">        <cfinput name="image" type="file">      &

I cannot connect to "Update" site in CF Administrator.  I need CF 11 Update 5 for Windows Server 2008 R2 (64 bit).  Where can I get it please.

I am in the process of moving a ColdFusion 8 application to ColdFusion 11.In CF 8 app I  have a page with Cflayout tabs with the source defined tin the cflayoutarea tag with cfinput datefield which works perfectly showing the Datepicker when the calendar icon is clicked.Now, when I use the same app on CF 11, everything works fine except the Datepicker is not showing no matter what I do. It works if the cfinput datefield is on the first tab, but if it's on any other tab besides the first, it does not work. Anyone have any idea how to make it work? I get the following error in JavaScript:Unable to get property 'split' of undefined or null referencecfcalendar.js, line 43 character 1 LINE 43: _206=_205.SPLIT("/"); Appreciate any pointers.BTW: The datepicker cfinput datefield works fine when the field is not inside the cflayout area.

I'm trying to upgrade from 9.0 to 9.01 in order to use Mura. (Our hosting center never did the upgrade.)I ran the hotfixes on Adobe's page, but that doesn't seem to upgrade the server. It still says 9.0. Is there an actual "upgrade" file that needs to run first? ie not just a hotfixI don't see it here: https://helpx.adobe.com/coldfusion/kb/hot-fixes-coldfusion-9.htmlI think CF9 support ended in 2014, but can I at least get the upgrade to 9.01?Dodd

After a couple fruitless hours of trying I need some help...  I'm trying to sign a URL for a REST API and, for the life of me, can't get CF to output the expected result.  The API is Aspose and the the instructions are here:http://www.aspose.com/docs/display/totalcloud/Request+FormatAccording to their example I need to hash this URL: http://api.aspose.com/1.1/storage/folder/test_folder?appSID=c821f123-1a8b-4b97-925a-9d69a6b2fcd8Using this Key: 23e9d89a967a5f18142221fa8f7cbcd0And the result should be:Z98TBrlwdtx3pTa6fWVD/Q0c2dE=According to the C# example they give the algorithm should be: HMACSHA1 and the encoding: UTF8I cannot get CF to produce this result. I've tried using the CF function hmac().#toBase64(hmac(url,key,"HMACSHA1","UTF8"))# gives me: MjYwMkQxN0EyM0IyMzkxNjNDMDU4QTQyMjc3RDgyNkMyNzM0NTA3OA==I've also tried suggestions and variations found here:http://stackoverflow.com/questions/9186773/coldfusion-hmac-sha1-encryptionand Ban Nadel's Crypto.cfc.What am I missing