ColdFusion

The project I'm working on is accessing it's data from a MS Access db. When creating a new person in the database there are several tables where data has to be inserted and updated.I had the problem, that when the second, third… insertion fails, the first one is already done. So I wanted to wrap the insertions in a cftransaction, so when a call fails the other ones get rolled back.But now no insertion takes place, even when there's no error. I haven't found reliable information whether it is possible to use cftransactions together with MS Access dbs. Is there any definite statement if it works with MS Access at all or with which version it will work?Hope you can help me out.

I'm having a problem with xmlParse and CF11. I have a site running perfectly under either CF9 or CF10. It uses xml files for various site settings and static content. Under CF11 I'm receiving the following:An error occurred while Parsing an XML document. Invalid byte 2 of 2-byte UTF-8 sequence.I've sent the document through various xml validators, no issues. Like I said, the exact same document parsed fine under CF9 & CF10 -- in fact it was created by CF9 and/or CF10. Any ideas on what might be causing this (other than a CF11 bug) and a possible work around. (it's hard to create a work around when I'm not even sure the issue)BTW, I downloaded and installed the latest CF11 yesterday. A check for updates does not show any available.

Using Ext-JS drop down menus and the flash cfgrid with the wmode set to anything has no effect.  According to the docs, set wMode to transparent or opaque and everything else should float over it.  It doesn't do anything and I am starting to remember why I never used this feature before.  Adobe, tell me how to fix this yesterday please!

Hi Everyone,I'm looking for a CF10 download link? I used to be able to download older versions here:Adobe - ColdFusion Support Center : More DownloadsHowever since the release of CF11 I haven't been able to find it anywhere on the Adobe.comCheers,Chris

I can only find downloadable files for CF11, is there a downloads area for earlier version?  I would like to download that latest/last release of CF10 if possible.

Does anyone know if it is possible to activate Coldfusion offline?And if it is, how it can be done?Thanks in advance guys

So here is the logic I have I just can t figure how to codeIf the date is between 5/31/2014 after 3:00 PM  and 6/7/2014 up to 3:00PM  <CFSET payweek =1>If the date is between 6/7/2014 after 3:00 PM  and 6/14/2014 up to 3:00PM <CFSET payweek =2>If the date is between 6/14/2014 after 3:00 PM  and 6/21/2014 up to 3:00PM <CFSET payweek =3>I know I could code all of the weeks but isn't there a way to do this with a loop when you have know starting date 5/31/2014 and time and set length 7 days?

Installed CF11 on MAMP Pro 3.0.5 on OSX Mavericks. CF server is started as well as Apache and MySQL. When I navigate my desired CF virtual host, It only displays the code within index.cfm in the web browser. Also, when I navigate to localhost/CFIDE/Administrator/index.cfm, it tries to download the file. Any suggestions would be appreciated!

Recently, we upgraded our webserver to IIS 7.5 and ColdFusion to CF10, and ever since then any forms I have which use CFFORM (not flash) will not load on any Macs, with any browsers.  I've noticed that these same sites, when running on a Windows 2003 Server (also running CF10) do show up on all browsers in apple machines.Before I convert all of these cfforms to regular forms, can anyone help me with this?  I suspect it must be a setting on IIS 7.5 that needs tweaking, but as far as I can tell all of my filters and and settings are correct.  And yes, everything works fine on PCs.  Any ideas?

I've inherited a ColdFusion site (CF5), despite no background in CF, but have been tasked with making a change to the behavior of the site. I'm running into a problem with cookies, though.A site on another domain is linking to this site and includes a query string. Now I'm checking for that value (a zip code) in the index.cfm file and storing it in the cookie and that seems to be working fine. I looped through the cookie collection and dumped the results, and the zip code was there. So at this point, all is well.But then the user clicks on a button, which reloads the index.cfm file with a different <include>, and the cookie no longer has any values other than CFID and CFTOKEN. This was confirmed by looping through the cookie collection, and later by Fiddler.Client storage is set to cookie, and I can't find anywhere in the index.cfm, application.cfm, or the included files where the cookie is being set to expire.Here's the line that's storing the value:     <

We've had CF10 running for months now with very few problems. This Tuesday i start to hear of the CF instance crashing in the mornings. I restart service and it runs again for the day. Wednesday it is crashed again, so i restart service twice before it will start working. Thursday the service is dead again. all my efforts to restart service or reboot server only allow it to work for minutes at a time. it starts working fast as normal, then slows, then really lags, then Time Out errors from queries and then crashes the CF instance again. on and off like this all day and still today. I try tweaking some CF Admin settings but nothing seems to give a lasting help. Server seems to be running just fine (Windows server running IIS). I can get general HTML pages to work continually even during worst behavior of CF. I checked my SQL server as well and it is running fine, no strange or overwhelming queries. I rerouted traffic to the staging server instead of the Live Prod server and after a few

Is there a way to get such tools ?A coldfusion page may contain html, css and js lines of code...

Hello everyone,I’m trying to export the contents of function output to a excel using the click of a button. I have created a action page for the button, which calls the export to excel standard code using cfheader and cfcontent tag. Exporting the excel using these tags works fine but after the cfcontent tag I have created a form and redirecting it back to the calling page. The code after the cfcontent tag are not executing and page is not redirecting.This is the code i'm using for exporting to excel.<cfsavecontent variable="strExcelData"><cfoutput>#fn_retrieveData()#</cfoutput></cfsavecontent><cfheader name="Content-Disposition" value="attachment; filename=Audit_#DateFormat(Now(),'ddmmyyyy')#.xls"/><cfcontent type="application/vnd.msexcel" variable="#ToBinary( ToBase64( strExcelData.Trim() ) )#"/> <form name=frm_AuditTrail method=POST action=tchk_AuditTrailSearch.cfm><cfoutput>          &n

I have Coldfusion 9 and I wonder if it is possible to send emails you have in the queue every second. Currently we send mail through Gmail server and you do not need classified as Coldfusion send spam emails with an interval of one second each. Anyone can help me?

When creating an rss feed, we only have 4 fields to use, date, title, content and link. How can i combine two fields creating one field out of two?

Hello,I am not able to get to CF admin after installing CF 10. I am getting a '500 internal server error' along with the following message. How do I get around it? Thanks.Best regards,Chung Leetype Exception reportmessage description 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:472) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414) org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:203) org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(

I'm looking over the datasource settings for MS SQL Server and I have some questions about.Limit ConnectionsI can't think of any reason to use this except to help minimize the damage of a DOS attack. Max Pooled StatementsI understand that this should be set to equal the amount of unique cfquery tags that use the cfqueryparam tag and cfstoredproc tags. Thats great an all but why?TimeoutThis is how long it keeps each connection to that datasource open. Is there any reason to change this and how would you determine the right setting?Query TimeoutIt defaults to 0 (no timeout) and I don't want a query running forever. I can't think of the last time I had a query run more than 1 second. Any reason why I wouldn't want to set it to 5 seconds or less?Thanks Phil

My client wants to move to a ColdFusion clustering environment for better availability and scalability of the site. I know how to setup clusters and instances in the ColdFusion Admin. We should also use J2EE session mgmt for sticky sessions.But I am not sure of other code level changes required while moving from a single server to clustering environment.Anyone having any experience please suggest? Or any helpful links that I can prefer?I have asked the same on SO but did not got any response . Any help would be greatly appreciated.

Hello, I wanted to see if you can control which columns from a query get written to a excel spreadsheet. I have some items in my query that I do not want in the spreadsheet but need for my query, if that makes sense.Thanks.Steve

If I understand correctly I should be able to have the application name from application.cfc show up in my SQL Server connection string (i.e. in the program_name column of sp_who2) if I go in to the DSN advanced settings and check "Application Name" under Client Settings. However having done that I still don't see anything in the program name columns of the sp_who2 result set. Any ideas?Thanks!

Hi,We have a CF 9 multiserver setup that's been running quite nicely for the past year. Recently, a domain admin password changed cocked up our IIS, which we got working by changing the admin passwords for each app pool within IIS 7.Since then, though, I can't access the main CF Admin page, which gives a 404. I can access the admin pages for the multiple sites by visiting the internal IP of the server and specifying a port (192.168.xxx.xxx:8301, 192.168.xxx.xxx:8302, etc), but if I try and do this for the main CF Admin site (port 8300) again, I get a 404.The guy who set our server up is long gone, and although I know enough about CF to keep things running, this has got me stumped.I'm convinced the problem lies with IIS, but I was wondering if anyone here has any experience of such a problem?

Is there any way of defining the size of markers in CFMap?? It is really frustrating me!!Many thanksJan

One of my table is saving an HTML form which contains coldfusion variables. In my code I am querying this table and I need to display this form in the front end. But while dsiplaying I am getting the coldfusion variable name itself instead the processed value of the variables.HTML Form saved in the db table:================================    <form action="" name="ci_entry_form" id="ci_entry_form" method="post">    <table width="100%" height="100%" border="0">    <tr>    <td align="right"><b style="color:red">*</b> <label class="pop_up_letter_font">G/L #     :</label></td>    <td>    <input class="pop_up_textbox" type="text" name="gl_number_text" id="gl_number_text" maxlength="21" value="#ARGUMENTS.chkDetails.GL_ACCT_NBR#" required/>       <select class="pop_up_dd" name=

I am using ColdFusion 11 on a Windows Virtual Server 2008.  The CFMAIL tag is producing duplicate messages (3 each time with IE11 and 2 each time with FireFox.  Numerous tests have produced the same results.  I tested with and without the mail spooler enabled - no change.  The code is simple. no loops, no query, no double-click of the 'send' button.  I have seen other complaints about this in other forums with the only solution being "to disable CF scripts that start/stop the mail spooler".  1) Does anyone have a suggestion?  2) How would I disable the CF Script to start/stop the spooler?  Robert

we have frequently encountered the same issue ‘ Service unavailable’ and need to restart the ColdFusion application service.can someone help to open a case with adobe.thanks.regards,jimmy