ColdFusion

I have following code to generate a csv file using my stored procedure return.After file created, I create a link to let user access.The link does not add my file name variable.Are there any better way to add my variable to the link that user can access the file just created or just created the file on the local machine that user can access locally?Your information and help is great appreciated,Regards,  <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#">   <cffile action="APPEND" file="#f_dir##f_name#"   output="#Field1#, #Field2#  addnewline="Yes">   </cfloop>   <br>   <a href=

Hello, all,TSIA.  I once wrote some CF code that would validate a UUID as long as it was in either CF (8-4-4-16) or Oracle (8-4-4-4-12) format.I have since lost that code, and I'm not quite wrapping my head around a simple regex that will validate both formats.REMatchNoCase("^[0-9a-z]{8}-([0-9a-z]{4}-){3}[0-9a-z]{12}$",form.str).. will match the Oracle format.  But I do remember there being a way to validate both formats without using a long regex and the pipe, typing out both formats.  Please help me with this.V/r,^_^

HelloI'm testing a CF11 server on a Centos 7 64-bit (up to date), Plesk 12.0.18 Update #86. The website works fine, however the issue it in the admin side. Once I login to the admin and click the button or navigate in the admin for more then a few minutes I get the error from the subject. Then the CF is down and the only way to "fix it" is to restart it.The CF11 is up to date with update 9 installed, then the connector was built from sources (ColdFusion 10 and 11 RHEL connector configuration) and loaded in to the webserver. The workers.properties are bellow:worker.list=cfusionworker.cfusion.connection_pool_size=500worker.cfusion.max_reuse_connections=500worker.list=worker1worker.cfusion.connection_pool_timeout=60worker.cfusion.type=ajp13worker.cfusion.host=localhostworker.cfusion.port=8014The connector settings are bellow.    <Connector protocol="AJP/1.3" port="8014" redirectPort="8447" maxThreads="500" connectionTimeout="60000" tomcatAuthentication="false"/>I hav

This new forum software sucks but I digress.  I'm not sure where my first post of the following ended up but here it goes again. Sorry for the double post if you found it here or somewhere else...I have two CF11 installs, my desktop and a production server. I believe both have the same SOLR version but I'm not sure how to tell since I don't see any SOLR version info on the CF server info page. Indexing the exact same PDFs, my local copy includes the symbols © and ® within the result sets of a search whereas the production server includes the encoded © and ® equivalents. What am I missing? Why are the two result sets different?

Hi all,I've looked through the forum and can't seem to find another instance of this occurring, so I'm going ahead and starting a new thread.The issue we're having is that CF11 (Update 7) often won't restart correctly after a server restart. It seems to get stuck on the 'Starting license' stage and hangs, with no other error messages:"Information","localhost-startStop-1","09/17/14","03:15:31",,"Starting license..."This only happens when CF11 is run as a service. We can manually restart CF11, so as a workaround we've created a script that runs on startup to restart ColdFusion "manually" (i.e. outside of automatic service startup).The three machines that this is happening on are running Windows 2008 R2, with 8GB AM and a 2.1GHz quad core processor. We're running JRE 1.7.0_67.We only have these three machines running ColdFusion, so I'm not able to compare it against any other of our servers. Has anyone else seen this before, or have any tips on what I could try to allow ColdFusion to star

Hi all,I have this issue:Apache Flex Users - Time zone issue I am stuck trying to set the MyProxyBootstrapService example described inFLEX: Handling Timezone Offset - Stack Overflow Anyone from here can help?Thanks in advanced.

My office is (finally) upgrading from CF8 to CF10, so naturally I wanted my development environment to match the server environment.  I've been trying to find a copy of CF10 Dev Edition all morning, but it's just not to be found.  CF9? Sure.  11 is everywhere, but no CF10.Then I read this: Adam Cameron's Dev Blog: ColdFusion 10: be prepared, Adobe is removing the downloadsWhat's the deal?  Someone on that thread mentioned a security problem with 10.  Is that true?  If so, I'd like to warn my people who are installing 10 as we speak.Thanks.

Hello all-I just completed a full documentation project on a program I've been working on for 2 years.  I am absolutely thrilled that is over!  (The documentation, not the coding!)Within the documentation (which is meant to be printed out) I included various passwords.  I know this should not be part of the final docs...but I'm wondering- What is the accepted method of documenting passwords?I have:  ColdFusion admin passwords, Windows Server passwords, Datasource Passwords, Application 'universal' passwords, etc.Where do you put these passwords?  How do I include them in the final printed documentation?  If we have a server meltdown, someone will NEED these passwords to get everything going.  I need to make them available, but I don't want to be stupid.  Suggestions?My system does not deal with sensitive information- except user passwords.  But, we need to keep things protected...just not at the HIPAA level.Also...if you haven't done a massi

I recently upgraded from CF9 to CF11 (development version) running on localhost and I am having the following issue. I have a CFC that saves some data, creates a few cfcharts and saves them to disk. The following is getting added to the beginning of the JSON object that is returned to the client, causing the ajax call to fail:<script type="text/javascript">/* <![CDATA[ */_cf_loadingtexthtml="<img alt=' ' src='/CFIDE/scripts/ajax/resources/cf/images/loading.gif'/>";_cf_contextpath="";_cf_ajaxscriptsrc="/CFIDE/scripts/ajax";_cf_jsonprefix='//';_cf_websocket_port=8577;_cf_flash_policy_port=1243;_cf_clientid='xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx';/* ]]> */</script><script type="text/javascript" src="/CFIDE/scripts/ajax/messages/cfmessage.js"></script><script type="text/javascript" src="/CFIDE/scripts/ajax/package/cfajax.js"></script><script type="text/javascript" src="/CFIDE/scripts/chart/cfchart-server.js"></script>This only happens w

I have discovered that in an environment comprised of Windows Server 2012 R2 and CF11 (or CF16) that CF date functions contained within CFQUERY will produce ISO 8601 datetime values.  For example, the value of start_dt in the following query will contain the letter 'T' between the date portion and time portion of the value of start_date:<CFQUERY name="qry_dates" datasource="mydatasource">     SELECT #now()# as start_dt,     last_name     FROM mytable     WHERE last_name = 'Smith'</CFQUERY>The value of start_dt will be something like: 2016-06-28T09:38:24My database is installed in SQL Server 2014 Standard on a server running Windows Server 2012 R2.  This did not happen with the same code where CF11 was running in WS12 R2 but the database was in an instance of SQL Server 2012 running on WS08 R2.  I need to eliminate the ISO 8601 formatting, i.e. eliminate the 'T' in the datetime str

I've installed two instances of ColdFusion on separate servers.  One using the "Development" environment install option (not to be confused with the "Developer edition"; these are licensed servers), and the other using the "Production" environment install option.I can't access the ColdFusion admin pages of either server from my laptop, but I can access the admin pages for each server from the servers themselves, respectively.How do I change the server configuration so I can access the CF Admin screen from my laptop?Thank you in advance for your help!

CF2016 is doing some weird alignment on tables.  I saw similar behavior when I converted this to div's, so I don't think it's necessarily unique to tables.  Either way, the code below results in different results in CF10 vs. CF2016.  See attached pics for comparison.   ----------------------------------------------------------------------------------------------------------------------------<cfpresentation format="ppt" destination="c:\mydir\myfile.ppt" overwrite="yes" title="test" >  <cfpresentationslide>    <table>       <tr>              <td>td1</td>              <td>td2</td>        </tr>        <tr>          

I'm migrating a site from CF8 to CF2016 and when I cfdump the cookie scope in my application.cfm file, I see the cfid and cftoken values passed from the browser, however when I move that cfdump to the template being called i.e. default.cfm, the cfid is there but the cftoken had disappeared completely. Anyone know why?

Disclaimer...  I didn't write this stuff!!!  I'm just trying to understand WHY somebody wrote this stuff!!!I'm going through one of the Application.cfc templates I'm supposed to be responsible for when I ran across something I just didn't get.  OK So I've ran across a bunch of stuff I don't get but that isn't the point...  Turns out EVERY time a visitor hits this internal application the system generates a whole new set of Application variables for them.  The first few lines of the Application.cfc file are shown here:<cfcomponent>  <cfset this.name = "rover_" & lCase(ListLast(cgi.auth_user,"\"))> This means every unique visitor will create an application called "rover_SomeNameGoesHere".  It also means the onApplicationStart method will be getting executed once for each unique visitor. Can anybody think of a "valid" reason for creating a new application scope for every unique visitor?  Because it's an internal app we never see more

Late to the party but re the style issue - CF11 wants the ".xml" file extension (up to CF10: style="myStyle", with CF11: style="myStyle.xml").My issues/needs/questions:1) How do I get x-axis labels at say 45 degress? "Horizontal" and "Vertical" work but horiz is too wide and vert is hard to read.2) How do I loop through data sets that do not have the same count, e.g.: <cfset ra=[[30,20,40],[50,10,90,40,70,30],[88,72,64,81]]>? What I want is in the same chart have 3 groups with 1st group of 3 bars from the 1st array, 2nd with 6 bars, 3rd with 4.  The best I've been able to get is 3 groups of 6 bars or 6 groups of 3 bars. CF fabricates the extra bars to make all groups 3X6 or 6X33) How do I loop through the above parent array with cfchartseries and get the first group generate from the first array (or query, struct, etc.), the 2nd group from the 2nd array, 3rd from 3rd array? What I've tried:<cfloop from="1" to="6" index="ix"><cfchartseries serieslabel="#chr(ix+75)#"

Hello, all,I know.  The question in the title can be a bit confounding.  It is to me, too, and I wrote it!  I'm trying to dynamically add watermarking to images using imageDrawText().  A company name centered in the image.Now, if the only word(s) used are, say, a company name, then it's not a stretch to just play around with arguments until the text is centered on the image.But, what do you do if the text could change from image to image??  Suppose, for this hypothetical scenario, that after the company name the photographer's first and last name will be below the company name, and said names are of various lengths.  And to make things even MORE interesting, the images used are different sizes and a mix of landscape and portrait oriented images.I'm trying to create code that will dynamically center the text on every image in a directory.  Understandably, I'd have to get the width and height of the image, divide by two to get dead-center, then offset b

Hi,I have been recently asked to look into updating the web connectors on our server at work. First, some stats:Server RHEL 5ColdFusion 10 (64bit)Apache (not sure of the ver number)When I first did this install, I had to compile a custom connector to get it to work.  However, there has always been one issue. In the rare times where I have had to stop CF from the command lines, I can't get CF to come back up and reconnect to the webserver. However, after  a reboot everything works fine. I started researching the problem and I came across http://www.carehart.org/blog/client/index.cfm/2013/9/13/why_you_must_update_cf10_webserver_connector - Charlie's article about updating the connector. My first question is: Can someone from Adobe give me a little bit of information as to what happens when you create a connector? If I complied a connector when I first installed CF and compiled a connector *after* I have updated CF to the latest version are those connectors different? I'm asking

I need to create a report using CFReport for CSV format.I can create Excel, PDF, HTML, XML, RTF and Flash, but I am asked to produce CSV format.I search CFReport, it does not have CSV option for the format.I would like to know if it is possible to have CSV format using CFReport or ColdFusion have any other solution for this?Your information and help is great appreciated,Regards,Sourises,

When I try to apply the last security update in the coldfusion 11 administrator I get this error: "failed security verification"I Know there is a fix for coldfusion 10 Coldfusion 10 "failed signature verification" - Dark Training but i can't find a fix for coldfusion 11.Can anyone help me?

I'd like to angle the labels - say 45°. Horizontal "disappears" or overlaps - neither being acceptable, while "Vertical" is hard to read and takes more space.I have found "Horizontal" and "Vertical" work in the xml call style="myStyle" in CF10 and earlier, style="myStyle.xml" in CF 11, which referencesCFexe/cfusion/charting/styles/[myStyle].xml ...-<xAxis><labelStyle orientation="Vertical" isHideOverlapped="true"/><titleStyle isMultiline="false" font="Arial-12-bold"/></xAxis>...If I put a numeric in the orientation value assignment CF errors.

It is not giving an error, but the data values are not staying when comment page is refreshed.  It does show the values immediately after loading but not after refresh.Something worth noting is the variables for ALL the blog section are not working without the get() in the variables.  For example, instead of #blogpost.title#, it wants #blogpost.getTitle()#.  The duplicate site does not do that, and when I had that issue then, I simply deleted the db tables, repopulated them, and then it worked.  I just deleted the db blog tables and repopulated them and both the comment issue and get() issue still neeed resolved.   Maybe the get() is related or should be addressed first?Here is a <cfdump var="#blogpost#"> : component workexperience.www.com.entity.blogPostPROPERTIESid1titletitlesummarysummarybodybodydateposted2005-01-01 00:00:00.0createdDateTime2005-10-10 10:10:55.0modifiedDateTime2005-10-10 10:10:55.0deleted[empty string]commentsarray1 component workexper

I've recently setup and configured a server farm running Windows Server 2012 and ColdFusion 10 Enterprise. I have a cluster created using named instances (not cfusion, though I find it curious that CF10 will allow you to cluster the cfusion instances now - but that presents problems - a different discussion later) anyhow.I began with Sticky Sessions enabled on the Cluster and it worked as expected, I then wanted to turn off Sticky Sessions so that the applications would enjoy a seemless failover. Unchecking the box on the Cluster manager, restarting IIS and CF, had no effect. Sticky was still, well, sticky. An examination of the cluster.xml revealed that the <stickysession> node was set to "false" but workers.properties still had sticky set to true, so I edited workers.properties, saved, restarted and voila the cluster was no longer sticky.Now here's where things get weird. I get a call from a member of my team, a user is losing their session and getting logged out. A test was co

I had a similar problem in this thread:  Finding the Oracle datasource... I have a CF 10 application interfacing with an Oracle 11g database; Windows Server 2012.   The original developers had different names for the datasources for Test (abcdTest) and Production (abcdProd).   I attempted to access Test after being on another project for quite a while and received the message that the datasource abcdProd could not be found... that is correct because I was logged into the Test machine.   I searched my source code and for some reason the datasource abcdProd was assigned in numerous places in the Application.cfc.   I changed all the references, cleared cache, restarted the browser and tried to login again.  Same error.  There are no references to abcdProd in the code base I am currently working with.   I have verified with the Gov't SysAdmin that CF Admin is set up correctly and my code should be pointing to abcdTest. &

Hi CF admins,I have this issue:Re: CF9 and Flex timezone issue WolfShade is suggesting to ask in this forum.Thanks in advanced.

I'm working on a clients system that has a library of CFC's in a folder called /Admin/cfcs.   Inside that folder is an Application.cfc file.There is also an Application.cfc file at the root directory.  Off the root directory are other folders in addition to the Admin folder.When I execute the template /Members/Index.cfm a few of the methods from the CFC library get executed.If there aren't any calls to the CFC library I'm 100% sure the Application.cfc in the root folder gets executed when I run any of the templates in any folder off  the  root folder.My question is if a template, such as /Members/Index.cfm, invokes a method from the CFC library does the Application.cfc template in the /Admin/cfcs folder get executed or is the root Application.cfc the one executed. I believe it's just the root one but I'm not 100% sure.  Any thoughts???  Does having an Application.cfc in the library folder cause any issues???Thanks in advance for the assist!