ColdFusion

LET'S SAY I HAVE 2 FOLDERS...Framework Components - Holds components that are used across multiple web applications which are setup to use the framework.Application Components - Holds components designed for specific web applications (not global in it's functions)In short, think of owning a Pizza store and a Burger store.  A method called "OrderIngredients" would exist in the "Framework Components" folder, because both stores (web apps) would utilize it.  However, the function "MakePizzaSlices" would be in the "Application Components" folder of the Pizza web app only, since there's no need for it to be in other web apps (that don't make pizza)So here's the thing.  The FW COMS folder has about 12 coms, totaling about 542KB of code.  The APP COMS folder (for this particular app) has 4 files totaling 88KB.SO HERE'S MY QUESTION...Performance-wise, have you found it better to just instantiate everything into the APPLICATION scope onApplicationStart so that code can refer

Hello all,This is a strange one, and in all the years I've been using CF (since beta) I haven't run across it.. but I'll give it a whirl here.I have a server with 3 databases/datasources on it.   Each are for their own web site.All three are MS Access databases (quit laughing).One of those databases does NOT have a username/password set up on it,  and it works perfectly.Two of them DO have username/passwords set up on them,  and they have been giving 'cannot connect to database' errors over the past week now.The problem isn't in the coding,  or in the CF setup itself, because they work fine for a couple days.. then suddenly they stop working.Since the only real difference between the 'working' and 'non-working' datasources is that the one's that don't work have username/passwords set up,  could that be causing the problem?I'm not sure what would cause it..  kind of 'grasping at straws' at this point.   My sites are hosted on a 3rd party host

I have a new application where users will be uploading graphics for display on their customized page.   The issue is the graphics are sometimes massive and are almost never cropped nor cented for use on their page.   Is there a way to handle this?  Running Coldfusion 10 with Msft SQL Server 2008.Thanks - NC Beach Bum

When i get data from DB...data contains #Example : VB#when i pass this data on url...not passing whole data.lanvar = "beginner VB#"mypage.cfm?lan=#lanvar#how can fix this issue?

<link rel="stylesheet" href="css/jquery-ui.css" /> <script src="scripts/jquery-1.8.3.js"></script> <script src="scripts/jquery-ui.js"></script><script>    $(function() {       $("#datepicker").datepicker({ minDate: 0 });    }); </script> this loop returned records from table.  Supposed it returned 5 records.  The code below only show the calendar for first text box.  how can I display every calendar all of tex boxese <cfloop query="q_sale_order"><cfinput type="text" value="#dateformat(sale_date, 'mm-dd-yy')#"  id="datepicker" name="sale_date#id#"  /> </cfloop>Thanks

Hi folksToday installed CF10 Standard edition on a server that had been using CF7.  Figured it was time to get current.  This server is running Win2003/32bit and IIS 6.  Anyway, after configuring CF10, if I access a few of my sites using just the URL without "/index.cfm", I get the following IIS error:Page Cannot be displayed:HTTP Error 403.1 - Forbidden: Execute access is denied.Internet Information Services (IIS)Now, if I include "/index.cfm" all seems to work fine and I can login/navigate my site fine.  I've confirmed that index.cfm is in my default documents panel in IIS6 and I've even run the remove_ALL_connectors.bat and then reconfigured them and still no luck.  The same ones that worked before, work now.  The ones that didn't, still don't.Now full disclosure, since I read CF10 could live alongside CF8, CF9, I stopped CF7 but left it installed when I installed 10.  Then after 10 seemed to be working fine, I uninstalled CF7.   So that'

Hi All,I am using the following code to convert a ColdFusion Query Object to ColdFusion structure to work in Kendo UI datagrid.<cffunction name="convertQueryToKendoJSON" access="public" returntype="Struct" hint="Converts a ColdFusion Query Object into Kendo UI format JSON">          <cfargument name="queryObject" required="true" type="query" hint="ColdFusion Query Object" />          <cfset var returnStruct = structNew() />          <cfset var tempArray = arrayNew(1) />          <!--- Loop over the query Object and create one structure Object for each row and query fields are the structure keyfields                    Store the structure into an array Object. --->   &nbsp

Hello,I'm trying to apply the hotfix to our new CF10 server, but the update page says 'no updates were found'.  This also shows when I click the 'check for updates' button.  Could it be b/c i'm behind a corporate firewall?Is there anyway to manually install the hotfix?

Hello - I'm having some trouble getting cffileupload to work.  When users click the 'Upload' button on the object to upload fiels, they encounter a Windows security dialog that prompts them to log in.  Has anyone encountered this?  We're using IE8, and the server is Windows 2008 and IIS 6.  Users to have full permissions to the folder to which they're uploading.  I'm thinking this is an IIS issue.  Thanks very much.

Hi All,Our couldfusion application stopped working a few times last week due to the process "911.exe" which costed 99% CPU. Once we kill that process, everything back to normal again. The problem is process "911.exe" should be in C: root, but we found it in "ColdFusion8\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp56746.tmp" and been recognized as a virus. We kill it, it will appear again and again. Does anyone have the similar problem? How can I fix it? I think this folder "temp\wwwroot-tmp" is used to store chached files, uploaded files. Does that mean someone uploaded some files with the virus?Thanks in advance.Wei

We found strange issue during simple calculations. When trying to calculate:1089.11 + 97.63 - 1186.74we are receiving:-2.27373675443E-013but this value shoud be 0 (zero). Please try the following in your CF:<cfoutput>#1089.11 + 97.63 - 1186.74# (should be 0)<br />#1079.11 + 97.63 - 1176.74# (should be 0)<br />#1079.11 + 107.63 - 1186.74# (should be 0)<br />#1189.11 + 97.63 - 1286.74# (should be 0)<br />#1089.11 + 97.63 - 1186.64# (should be 0.10)<br />#2089.11 + 97.63 - 2186.74# (should be 0)<br />#3089.11 + 97.63 - 3186.74# (should be 0)<br /></cfoutput>It's strange and we are not sure how to deal with this issue. Of course we can use Round, we can use some other methods, but we don't want to review all our applications to check if such situation occured...Pawel Dulak

Hello All,I am so new in ColdFusion. I'm trying to move one website (coldfusion) to another hosting.I have a problem in cfr pages. I don't know how do I have to see them?I couldn't open them in any editor?Do I have to install any spesefic software in the destination hosting in order to run them?this is the error that I got :"some address in the hosting ex: d:/file:report/fff.cfr"  .cfr appears to be malformed or contain errors.If any one can help me, I really appreasiatethanks you in advansedbahar

I have completed an install of CF10 on a Win2k8 R2 box.  I enabled the recomended IIS services and the installation competes with know shown errors.  I selected to use the built-in browser.  At the setting migration wizard, I enter the password and it goes to the competing install screen.  At this point it resets back to the login screen.  No errors are displayed, but the wizzard does not open the administration webpage.What could I be doing wrong, or what should I be looking at?Thanks in advance.

Here's some exciting news about ColdFusion Splendor. We will soon have pre-release open for Adobe ColdFusion Splendor, next major version of ColdFusion server and ColdFusion Builder Thunder, next major version of ColdFusion Builder. This time we will have a single pre-release program for both Builder and Server. If you are interested in being a part of the pre-release, do take this survey linked here.Please realize that participating in this survey does not guarantee a pre-release invite. The plan is to start the pre-release with a reduced number of participants and eventually increase the number of pre-release of participants. You will receive an invite as soon as your interest is accepted. The acceptance may happen now or in the coming months when we decide to increase the number of pre-release participants.Your participation will be valuable in shaping up the future version of ColdFusion.

My website host updated from CF5 to CF9 and from I think MySQL 4 to 5 and now when I run my job application form I get this error while trying to execute it. anyone know how to fix this?Error Executing Database Query.You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'leave, supervisor, description) VALUES('ddMar-19-2013', '', '', '', '', '', '' at line 1

I currently have 2 domains on my server. The first one is serving CF templates fine, but the 2nd  is throwing a 500 error whenever a cfm template is hit. This error is thrown regardless of the contents of the template. A completly blank cfm template throws the error, but serves fine when changed to an htm file. There is no Application tag on the part of the site that is being accessed. The fact that only 1 domain is throwing a 500 on a blank template leads me to believe that there is a server misconfiguration somewhere. I have verified that the cf connection is in place as well as the tomcat ISAPI for the domain in question. I believe a problem there would throw a 400 or 403 error however.Does anyone have any ideas?CF 10 64bit Running on IIS 7 Windows server 2008 R2 standard

I have a simple issue where people are doing data entry for numeric data.   The requirement is for them to enter whole numbers without punctation.   Since the data deals with dollars sometimes folks don't read and they want to enter things like dollar sign, comma, and decimal with cents.   This throws a data conversion error as the data is going into a numeric field and not a text field.   What do you do in this case?   I am using Coldfusion 10 with Msft SQL Server 2008.   Thanks!   NC Beach Bum

Local site working for days.  Had to restart computer for Updates.  Server starts fine and http://127.0.0.1:8500/CFIDE/administrator/index.cfm works fine still.  But now site under root http://127.0.0.1:8500/ initally was getting a file not found error for say /test/1.cfmNow I'm getting Could not find the ColdFusion component or interface /Applications/ColdFusion10/cfusion/wwwroot/Application.cfc.  for say file.Absolutly nothing has been change other than I had to restart computer. I've tried several restarts.  Cleared Cache.Thanks for any help.

I've got an HTML type CFGRID (using CF10) and keep running into this issue where it's not passing all the fields that I modify.  Say I have 5 rows, and I modify the same 3 columns in all 5 rows (entering prices).  All 15 cells get the little red modified indicator, but when I submit the form, the resulting form variables don't contain all the changes.  I'm dumping out the form object, and looking at the "grid.rowstatus.action" array to find which rows need updating, as well as the individual arrays containing each column's data.I can't see any pattern to why it sometimes omits rows or even just cells I've modified.  And it's not always the same, and sometimes it gets it right.  I haven't been able to find any references to similar behavior, so I'm kind of stumped, and at this point, I may have to ditch the cfgrid and try a JQuery grid of some sort to see if it works better.Anyone have any ideas?

Hi all,We're running CFMX 7 7,0,2,142559 on Windows 2003 Server, and have been experiencing the dreaded 'SpoollockTimeoutException' error.An exception occurred when setting up mail server parameters.This exception was caused by: coldfusion.mail.MailSessionException: An exception occurred when setting up mail server parameters..coldfusion.mail.MailSpooler$SpoolLockTimeoutException: A timeout occurred while waiting for the lock on the mail spool directory.The only "fix" has been to restart the ColdFusion service. Sometimes this resolves the problem for months at a time, othertimes it pops back up in just a matter of hours.I've tracked this issue using the sysinternals.com Process Monitor, and the output when the problem exists is as follows:3:15:55.8811675 PM    jrun.exe    996    QueryOpen   X:\CFusionMX7\lib\coldfusion\mail\MailSpooler.SpoolLockTimeoutException_en_US.properties   PATH NOT FOUND    3:15:55.8

I have a simple grid with Cold Fusion 9.0.2<cfquery datasource="db" name="q1">          Select 'a', 0          union           Select 'b', 0          union           Select 'c', 0          union           Select 'd', 0          union           Select 'e', 0          union           Select 'f', 0  </cfquery><cfform name="formgrid" action="customersku_submit.cfm">     <cfgrid name = "gridname" format="html"         selectmode="

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec1a60c-7ffc.html

Hi guys,We upgraded our server from Coldfusion 8 to 10 not too long ago and there were problems initially but most of them got fixed. Now the issue is that  dates are not getting retrieved properly when, prior to the upgrade, it was.Let's say that on the database for a particular person, it shows the date as 8:34 AM but when you try to display the date, it only shows up as 00:00 AM (or 12:00 AM depending on how we changed the format in the output). The strange thing is that the information is getting passed TO the database properly (Oracle 11g), its just not retrieving it right and what's stranger is that the days, months, and year is getting retrieved ok, just not the seconds, minutes and hours. I've tested using different types of functions for the output (timeformat, datetimeformat), used -Doracle.jdbc.J2EE13Compliant=true and -Doracle.jdbc.V8Compatibile=true, updated our ojdbc14.jar to ojdbc6.jar (since our JDK was 1.6), and tried various other solutions that were on the web a

I'm about to throw my monitor through the wall on this one.  I'm working on a process to retrieve order files from an sFTP server, and I have to delete them off the server after downloading them.  The CFFTP action="remove" call is returning a success status code, but the file is not actually being deleted from the server.  I've tested this under both FTP and sFTP (the server supports both), and it's the same both ways.  I also tested deleting the file through an FTP client (SecureFX), and that way it DOES actually delete the file, so I'm inclined to think it's not the server somehow blocking the action.Here's my code:<cfset ftpfolder="/Outbox/orders"><cfftp connection="ftpconn" server="#ftpserver#" username="#ftpuser#" password="#ftppw#" action="open" secure="true"><cfftp connection="ftpconn" action="changedir" directory="#ftpfolder#"><cfftp connection="ftpconn" action="listdir" directory="#ftpfolder#" name="orders"><cfdump var="#orders#"&

I tried to access admin page of CF10 server develop version from another machine on the same network, but I got HTTP 500 error.I thought that CF10 developer version can acceess by other 2 machines.I would like to know does CF10 allow to admin from other machine, if yes, what should I look for this issue.If not, is it that developer version only allow another 2 machines to access the web page only.Your information and help is great appreciated,Regards,Iccsi,