ColdFusion

Hello, all,I think I may have posted regarding this issue, before, but didn't get any response; I (unfortunately) have to try, again.I am using a Regular Expression to map the full physical location on the HD of where the website is located.  I need this for a CFFILE tag.The reason I'm using a RegEx instead of hard coding the location is because the location varies depending upon whether it is being used in development, staging, or production.  (Yeah, I know.. all three should be mirrors of each other - I'm working on that.  )For example, our DEV environment needs the CFFILE tag to point to E:\ColdFusion10\cfusion\wwwroot\www\ folder.Our staging environment needs the CFFILE tag to point to C:\ColdFusion10\cfusion\www\ folder.Our production environment needs the CFFILE to point to F:\webdocs\cf\www\docs\ folder.I really do NOT want to be hackish about this and use a CFIF or CFSWITCH to set the "this.webrootmapping" variable.  Besides, if anything gets changed, I'd h

Hello,We've an existing CF9 application with IIS 6, JRUN (web.config file) in Windows Server 2008 using Oracle database connection, as the licence of CF9 going to expire by this year we've already bought CF2016 and we're planning to upgrade as CF2016 and IIs 8 on Windows Server 2012, It's for a small application and we're not CF experts please let me know for below questions.1. Whether the tomcat software required for the above setup and why?.2. please let me know the installation details for the above setup, what all the software's need to install for it.Thanks a lot in advance.

Das erscheint wenn ich auf Seite bearbeiten klicke:Zugriff verweigert. Diese Datei ist möglicherweise nicht vorhanden oder es ist ein Problem mit der Berechtigung aufgetreten.

I am getting Oracle error ‘ORA-01461: can bind a LONG value only  for insert into a LONG column' when trying to insert into an ORACLE BLOB field. The error occurs when trying to insert a large BLOB (JPG), but does not occur when inserting a small (<1K) picture BLOB.(JPG). Any ideas?BTW, when using a SQL Server datasource using the same code.... everything works with no problems.ORACLE version is 11.2.0.1The ORACLE datasource is JDBC using Oracle's JDBC driver ojdbc6.jar v11.2.0.1 (I also have tried ojdbc5.jar v11.2.0.1; ojdbc5.jar v11.2.0.4; and ojdbc6.jar v11.2.0.4 with the same error result.)Here is my code:<cfset file_mime = Lcase(Right(postedXMLRoot.objname.XmlText, 3))><cfif file_mime EQ 'jpg'><cfset file_mime = 'jpeg'></cfif><cfset file_mime = 'data:image/' & file_mime & ';base64,'><cfset image64 = ImageReadBase64("#file_mime##postedXMLRoot.objbase64.XmlText#")><cfset ramfile = "ram://" & postedXMLRoot.objname.XmlText>

We have a custom built website with a lot of database integration (http://www.lake-link.com). We would like to have part of it run/managed using a CMS system for some content such as articles, press releases ect. I have briefly looked in to MURA. Can some kind of CMS system be plugged into an existing custom framework to handle content like this? The rest of the site is so data driven and customized I'm not sure a CMS system can do everything we need it to do for the site as a whole. Just looking for options for some content editors to manage some content without doing coding. Any advice is appreciated!

Hello everyone. I am in need to some help. I am migrating servers, and I am getting this error. I can't even get to the CF Admin. What do I do? My google-fu has not been very good on this error.HTTP Status 500 - java.lang.NullPointerExceptiontype Exception reportmessage java.lang.NullPointerExceptiondescription The server encountered an internal error that prevented it from fulfilling this request.exception javax.servlet.ServletException: java.lang.NullPointerException coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.java:129) coldfusion.bootstrap.BootstrapServlet.init(BootstrapServlet.java:59) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422) org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:198) org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.proces

Hello everyone. In the cfmailparam file   the file to be attached must be on the web server coldfusion or may even be on another server?Thank's

Hello, all,We've been seeing a lot of the following, recently, in our logs:http://www.domain.com/getfile.cfm?uuid{a CF uuid}'A=0When I entered this in my browser, I was presented with a dialogue to open or save "getfile.cfm".  My boss was in a bit of a panic, thinking that someone found a way to download our .cfm templates, thusly exposing all of our code.As it turns out, all it is really getting is the HTML generated on the fly by our CF server.  Okay.. no more sweating bullets.. but, still a concern.What is the best way to thwart attempts like this (harmless as they are)?  I've got form and URL scopes going through both Portcullis and canonicalize().  What else can I do?Much appreciated.V/r,^_^

Hi all, I am new to coldfusion. I have a page which has multi select dropdown .After selecting click on ok button calls javascript and selected values of dropdown are populated in other multipick dropdown. My question all the selected dropdown options I am storing in javascript array. How can display those in coldfusion page. Please resolve this . Thanks in advance

HI,I am getting the following message when I try to access the Cold Fusion 11 site:Service Temporarily Unavailable!The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.   Jakarta/ISAPI/isapi_redirector/1.2.40 The site has update 3 installed. the server is 32 bit.The site was running just fine yesterday and then Cold Fusion Application Server was not running.When I try to restart the service the following message appears:Windows could not start ColdFusion 11 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.The Event Viewer shows the following:The description for Event ID 259 from source ColdFusion 11 Application Server cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can

I use the same cfdocument call on two development and one production server:<cfsetting showdebugoutput="false" /><cfcontent TYPE="application/pdf" reset="yes"/> <cfheader name="content-disposition" value="attachment;filename=Details.pdf"/><cfdocument format="PDF" mimetype="application/pdf" backgroundvisible="yes" overwrite="yes" fontembed="no" bookmark="true" localurl="no" ><style type="text/css" media="screen">@1552174 "style1.css";</style>     -- content ---</cfdocument>Now this code runs perfectly on my local computer, it does not run in my development environment on remote computer, it DOES run on my multi-homed, remote production server in the inetpub/wwwroot directory but it produces a 30 second timeout error on the same production server in the inetpub/mysite directory (all other cf code runs fine.)The the content is the same, directory structures are the same, the template names are all the same (except for the serve

I have multipe dropdown list in a html form, now i have to store selected values to database using coldfusion[Moved from the general Adobe forum lounge to a product-specific support forum - Mod]

Hello Community!Working on application isolation paired with multi instance load balancing and came across what I would consider a bug.The uriworkermap.properties file included in the mod_jk.conf for Apache on RHEL 7 is seemingly completely ignored by my virtualhost.In all the documentation I came across, the uriworkermap.properties is where to specify the mount points for each of the workers.What clued me into it not working as I had anticipated, was that every time I ran ab to test the load balancing between different application paths, the first worker listed in workers.properties->worker.list would always handle the requests.The solutions I have come across so far :1. Include the uriworkermap.properties inside of the <virtualhost> configJkMountFile "/opt/coldfusion2016/config/wsconfig/1/uriworkermap.properties"2. Or Add JkMount entries in the <virtualhost> config#Load balanced application isolationJkMount /mysecureapp1 secureappsJKMount /mysecureapp1/* secureappsJKMo

The code is no longer worked on some Chrome/IE browsers. It will open Excel but nothing loads. <cfheader name="Content-Disposition" value="inline; filename=Report.xls"> <cfcontent type="application/vnd.msexcel">

Hi, I would like to know if Oracle stored procedure are supported in Coldfusion 2016 Standard (exept for reference cursors).I try to call a simply stored procedure like this:CREATE OR REPLACE PROCEDURE MYDATABASE.TEST_PROC( FIRSTNAME IN VARCHAR2,LASTNAME IN VARCHAR2,FULLNAME OUT VARCHAR2)ASBEGIN  FULLNAME := FIRSTNAME || '  ' || LASTNAME;END;/With this coldfusion code:<cfstoredproc procedure="TEST_PROC" datasource="mydatasource" returncode="No">   <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname=":FIRSTNAME" value="John">  <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname=":LASTNAME" value="Doe">  <cfprocparam type="Out" cfsqltype="CF_SQL_VARCHAR" dbvarname=":FULLNAME" variable="fullname"> </cfstoredproc>But I receive this error:ErrorCode 17041Message Missing IN or OUT parameter at index:: 4Anyone can help me?

Hello Community!If you are running Coldfusion 2016 Enterprise Instance Manager and have a Tomcat connector for the primary cfusion instance running TLS, you won't be able to start new instances.As it turns out, this happens because the instance manager creating the new instance doesn't know how to handle a TLS connector port of 8443 and mostly clones it verbatim.When trying to manually start the new instance, you will see something like this :sudo ./cfstart.sh Starting ColdFusion 2016 server ...The ColdFusion 2016 server is starting up and will be available shortly.Some other server/application is using the port 8443Change the server connector port in the file /opt/coldfusion2016/cfusion1/runtime/conf/server.xml and start the server.Exiting .....Ex: <Connector port="8502"The solution is to modify the Instance's TLS port to an available one :<Connector scheme="https" keyAlias="test" useServerCipherSuiteOrder="true" secure="true" protocol="org.apache.coyote.http11.Http11Nio2Protoco

Hi guys, going nuts trying to figure this out....I'm using a function within a CFC to dynamically populate 3 select boxes with data, which works fine.........The problem is, anytime one of the dropdowns pulling from the database contains a comma (such as in the phrase DRIVER'S), the page either produces a bind error, or the effected box populates as blank...This only happens on any data containing a comma.....I've tried using CFQUERYPARAM in the query, but that's not making any difference in this respect.The CFC:<!--- GET APPLICATIONS BASED ON LOCATION --->    <cffunction name="getApplications" access="remote" returnType="query">        <cfargument name="Location" type="string" required="no">        <!--- Get data --->        <cfquery name="data_applications" datasource="#application.dsn#">        

I am having an issue with my ColdFusion 10 enterprise server. On the ColdFusion Administrator page, underneath "DATA & SERVICES" I am missing "Rest Services". Does anyone know how I can get this option to show up?

Someone please help me to findout why I am getting below error while hitting coldfusion administrator url after updationg to CF-11 8 release.Error invoking CFC /CFIDE/administrator/updates/download.cfc : Internal Server Error [Enable debugging by adding 'cfdebug' to your URL parameters to see more information

Hello,I am currently considering virtualizing our current ColdFusion 11 Standard server and would like some clarification on the licensingaspect. Reading the EULA it states one license allows for one virtual machine with up to two vcores/vprocs. What I’m unclear about is the GHZ restrictions. The 5GHz is per vcore or per virtual machine?  Is this a host restriction or can be throttled on the VM instance? For instance, can you have a single VM with 2 vcores at 3 GHz  with a single license or do they need to be throttled at 2.5GHz?As far as physical server if I understand correctly you define CPU not by physical processor but # of cores divided by 4.  So one standard license would cover a one physical processor with up to 4 cores or 2 CPU with up to 8 cores total?Please correct/clarify as needed. Thx!

I have a local ColdFusion 10 Developer version on my local machine.I use ColdFusion to create a CSV file and save on the server and create a link using following code.Browsers open the CSV file as a text file and I use right click link to save target, my Windows Explorer save a a html file.It works on the other server using the same code.I would like to know are there any configuration to set ColdFusion recognize CSV file format when save the target and it lets browsers know to use Excel to open CSV files.  Your help and information is great appreciated,   Regards,   Sourises,<Cfset thisPath = ExpandPath("*.*")>     <cfset f_dir = GetDirectoryFromPath(thisPath)>   <cfset f_name = "#dateformat(now(), 'mmddyy')##timeformat(now(), 'hhmm')#.csv">   <cffile action="WRITE" file="#f_dir##f_name#"   output="MtField1, MyField2" addnewline="Yes">   <cfloop query="#myQuery#"> &n

Hello, I am just beginning to work with CFGrid and CFForm and I have an extremely simple flash CFGrid that is not populating. The headers load fine from my query, but the data does not. I am sure the query returns data, because I output it on the screen directly before I display the grid, and everything is fine. Here is the code: <CFQUERY name="getCommunities" datasource="#datasource#"> SELECT * FROM VG_Community </CFQUERY> <CFOUTPUT query="getCommunities"> #intCommunityID# - #strCommunity#<br /> </CFOUTPUT> <CFFORM name="communityForm" width="80%" format="flash"> <CFGRID name="communityGrid" format="flash" height="425" width="600" query="getCommunities"> <CFGRIDCOLUMN name="intCommunityID"> <CFGRIDCOLUMN name="strCommunity"> </CFGRID> </CFFORM> I do not know if this is relevant, but due to my installation, I do not have direct access to the webroot/CFIDE/scripts folder. However, I have copied the folder to

Hello, all,We recently received a new STIG for our environment, and one of the "findings" is for request timeout error template.  Basically, if the CFAdmin setting is blank or set to default, it's a finding.  We are required to create a custom request timeout error page and place it in the webroot (where CFIDE is not), then update the CFAdmin to point to it.Problem is that I have no idea what the request timeout error page is supposed to do.  I tried to review the code for the default .cfm page that handles this, but (of course) Adobe encrypted it, so I can't see what it's doing.Pointers greatly appreciated.V/r,^_^

Hi All,I'm not sure what I'm doing wrong. The form that I have has 11 records but my CFloop to CFQUERY is only returning 1 result. I'm expecting to see 11 records in the Recordset2_UPDATE query. The Recordset2_UPDATE query is just a SELECT statement for now, for testing.<cfloop from="1" to="#form.totRecords#" index=ct>  <cfquery name="Recordset2_UPDATE" datasource="Incident_Reporting">    SELECT '#form.ID#' as "UID",        '#listgetat(form.ID,ct)#' as ID,        '#listgetat(form.AllDocumentsAttached,ct)#'  as AllDocumentsAttached         FROM dbo.tbl_P1    WHERE        ID = #listgetat(form.ID,ct)#</cfquery></cfloop>Thanks for the second set of eyes!John

Hello, all,I just wanted to let everyone know about something that recently happened to me.  I have a side-project that is nearing completion, and I started up a hosted account for it, which currently just displays one page with a link to the org FB page, and a notice that the site will be going live, soon.Someone guessed my password for my Network Solutions account page, and on 06 JULY 2016 submitted a DNS Change Request, pointing the DNS from the Hostek DNS to something at ZTOMY.COM.  As soon as I discovered it, I changed it back to what it should be; foolishly, I didn't change my password, so about an hour later, the hacker logged back on and switched it back to the ZTOMY.COM address.I have changed my password, and re-changed the DNS back to what it should be. THE IMPORTANT THING TO KNOW:  The ZTOMY.COM address was re-directing from my website to a page that looked authentically like a Network Solutions page, asking me to enter a CAPTCHA and log on to confirm my email