ColdFusion

I am looking for assistance on how to best manage the output of a text field that spans across a page break when printing a report. The Content within the text field is split across two pages with part of the text lost in the margins of footer and header of each page. I need a way to force a page break if the content with in a text field spans two pages. ThanksJeff Dumont

I am trying to add how many records have the Ethnic value of "P", "U", or "W". I have tried different variations of:iif (query.ethnic_cod = ["P", "U", "W"], 0, 1) and the report errors out.Please advise.

We have a jdbc datasource setup to a DB2 database that works fine for about 6 days and then we get the error I've included below. If we restart the ColdFusion service the data source starts working again. I have searched google with no luck, has anyone ever seen this before?We are running ColdFusion 11 64 bit on Windows 2012 server."Error","ajp-bio-8016-exec-4","01/28/15","23:15:00","project","Error Executing Database Query.System or internal error java.net.SocketException: Software caused connection abort: socket write error The specific sequence of files included or processed is: \\ourServerName\directoryName\index.cfm, line: 77 "coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.    at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)    at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:745)    at cfrunwinextract2ecfm2052252949.runPage(\\ourServerName\directoryName\index.cfm:77

Having an odd issue with where it will throw a 500 error instead of the standard CFError page.This will typically happen for instance if there's a recordset issue (does not exist). However, I can see errors relating to say a missing include.Any ideas would be greatly appreciated.I'm also having a weird issue with Report Builder losing connection .. but only when it's run on the server itself (references 127.0.0.1 for the server host)Closing the app and re-opening will allow you to work for a while, but you'll get kicked after a minute or two.For testing there is no AV installed, and also the internal firewall has been disabled.Thoughts? Ideas?

Hello - I need to upgrade ColdFusion from v9,0,0,251028 to at least vCF9.0.1.  Can someone please direct me to a site with directions/procedures for doing that?  Thanks very much.

Hi! I am working on a website project in which they require to play swf videos without installing Flash Player. It was tested on iPad it is not possible to view the videos. Is there a way to solve this in CF?Many thanks

using CF10 with Fusebox 3.0bind attribute for cfgrid is invoked via  cfc. this invokation is calling fbx_settings.cfm instead of directly calling the cfc (location specified using cfc dot notation) happens in CF10 and not in CF8. reasonings / suggestions ?

Need some assistance...   After upgrading to CF 11, we have some users who's AD accounts are being locked out while using a CF program.  This wasn't happening on our previous version of CF.  The code has not changed in any of the programs which leads me to believe that it's either a setting in IIS or in ColdFusion.    Any ideas or suggestions?

Since upgrading to CFB 3, I am unable to view "ColdFusion Documentation" (Help).  How do I restore this functionality?

How much does Coldfusion cost.. the lastest one?

I have been trying to validate a few fields before submitting a form. Once the fields are validated by CF I want to pop up a sign in form if the user is not signed in. However, the problem is that the sign in form is pop up without validation. inquiry.cfm<cfif not isdefined("form.p1")>   <cfform name="inquire" action="inquiry.cfm" method="post">   <input type="hidden" name="p1" value="1">   <cfinput type="text" name="email" size="50" maxlength="50" required="yes" autofocus="on" validate="email">   <cfinput type="text" name="subject" size="50" maxlength="50" required="yes" validate="noblanks">   <cftextarea name="message" cols="45" rows="8" wrap="soft" required="yes" validate="noblanks"></cftextarea>   <cfif signedin>   <input type="submit" value=" Send ">    <cfelse>   <input type="submit" value=" Send " onclick="signin(); return false

Is it possible to add a jdbc datasource to the tomcat container running a cf 11 instance?  If so, is the any documentation on how to do this?thanks in advance..

I have an application that makes use of some session variables to preserve and check login information; not an uncommon technique.  I have recently instantiated a test server in the cloud using ColdFusion 11 and IIS 8.0. I am running Windows 7 Ultimate with IE 11 installed.  My colleague has a laptop running Windows 8.1 and whatever version of IE that is installed with that operating system ( I will verify version and update later).I am able to access and use the application without problem over the open internet, but my colleague can login, go to the main menu, but once he selects a template for any activity (This is where the login status is checked) he is redirected to the login page because the session variables that were previously set for him no longer exist.I had a similar problem on my computer about 2 months ago.  I researched it and found advice to clear out cookies and temporary internet files in my browser.  This fixed my problem.The problem is that the

I have a pretty fast machine and it takes CB Builder 3 like 3 minutes to load. What can be done or does everyone just accept this?

Trying to set up my brand new and ultra-clean dev box, running Win 8.1, SQL Server Express w/Tools 2014, CF 11. Having a really difficult time of it. Is there a step-by-step resource available. Are there common errors made in the SQL install that I may have made?Also, when I last used CF Studio (a long time ago, yes...) there was a way you could view and manipulate your datasources/databases from within studio. I haven't been able to find that in CFBuilder... It was really useful, so I cannot imagine they would have killed it... so... where is it?Finally... Any recommended reading for someone who's taken more than a decade off CF development? (and for that matter, programming of any sort)

When using the CFEXCHANGETASK tag to create a Task in Exchange, a UID is returned.  In Exchange 2010, the format is like this, which is Exchange Web Services (EWS) format:AAMkAGMwODNlNWZkLWM2NWQtNDJjMS04ZThiLTk5MTA1YzI1ODZmYgBGAAAAAADPyj6cVxiBQKuRB7Ygt4sEBwBplZyf6cGiTIbMibBUW679AAAAAAETAABplZyf6cGiTIbMibBUW679AAB3C9DBAAAWhen working with Exchange 2007, the UID format is like this:AQEAAAZhJ4amAAAAAAAAAAAAAAAAI cannot determine what that format is, and I don't have direct access to the Exchange server to do some sort of internal search of the Exchange store.Does anyone have experience with understanding exactly what this is?

Hi,I just installed ColdFusion Builder 3.0 and it will not do the syntax highliting on existing files - only if I type them in from scratch. Anybody have an ide whats going on?

I'm having an issue with Flash Remoting that we have been able to track down as being cause by our vulnerability scanner.  About 2 minutes into the scan process it causes flash remoting to fail and it does not recover until the ColdFusion Application Service is restarted.  What's worse is that I'm not seeing any errors in the log to identify that there is a problem and it's a error the end user is seeing and reporting to notify me of the issue.Any thoughts of what might be causing this?  Is there any logging I can enable to help troubleshoot / identify when I have a problem?Bellow is a modified snippet of the code we are using to do the call. In alert("Error while calling cfc:" + stat.description); is where we are seeing the error.  function getCurrentDate()  {   mx.managers.CursorManager.setBusyCursor();   var connection:mx.remoting.Connection = mx.remoting.NetServices.createGatewayConnection("http://#cgi.HTTP_HOST#/flashservices/gateway/")

Variable BLOG is undefinedI created mango blog a year ago and it was working fine but now it is showing me error in admin panel login like this Variable BLOG is undefinedVariable BLOG is undefined.at cflogin2ecfm1129036560.runPage(C:\sites\accounts\ddddd.com\www\blog\admin\login.cfm:7)Login page code :  <cfif structkeyexists(templates,"login")>  <cfset request.adminLoginTemplate = blog.getSetting('skins').path & blog.getSkin() & "/" & templates['login'].file /></cfif>application cfc code <cfsetting showdebugoutput="false"><cfset blog = request.blogManager.getBlog() /><cfset isAdmin = findNoCase(blog.getSetting('urls').admin,arguments.targetPage)/><cfif isAdmin AND NOT ( request.blogManager.isCurrentUserLoggedIn() ANDlistFind(request.blogManager.getCurrentUser().getCurrentrole(blog.getId()).permissions, "access_admin") )><cfset request.administrator = request.blogManager.getAdministrator() /><cfinclude template="ad

Running CF 9,0,1,274733 and I must qualify my post by saying that I know enough about CF to be dangerous.We have a number of schedule tasks that run once per day at different times of the day. These tasks do things like query the database and email staff about low on stock items and almost expired items, etc. We installed some critical security updates on our Win 2008r2 server a few days ago and the double emails started that night. I don't want to uninstall those security updates to fix this issue.Here are some things I have checked and tried:a) I cleared the cache in CF Admin.Clear Template Cache NowClear Component Cache Now Still getting dupesb) Restarted the CF services in the services.msc in Windows. Still getting dupes.c) Restarted the server. Still getting dupes.d) I ran a few of the tasks manually by clicking the Run button in the CF Admin Schedule Task list. Still getting dupes.e) I added the spoolenable="no" attribute to the cfmail tag. Still getting dupes.f) I recreated some

I filed a bug report on the fact that in CF9 and CF10 one cannot truly "edit" a Solr collection.  (If you click on a collection to edit it, you are not presented with what is currently being indexed in said collection - you the the default file extensions .htm, .html, .cfm, .cfml)Adobe responded by saying "It's not a bug, it's a feature."As a result, here is my view of Adobe products.

I need to show by counselor how many students were accepted, cancelled, enrolled, etc. I also need grand totals. I tried using a calculated field where I entered:iif(trim(query.dispos) eq DE("Accepted"), 1, 0) in the perform calculation on field but I always get 0 for the answer. I tried using single quotes around Accepted but that didn't make a difference.Any ideas?

Here is what I am trying to do. Retrieve a bunch of results from a  REST request. Run a query to see if I should be excluding any of the xmltext entries coming back from the rest request. Build an array of the REST xmltext entries except the entries in the cfquery.I have it all workign except building the array minus the entries that came back in the cfquery. Here is my code so far.<cfquery name="getqueue" datasource="#application.settings.dsn#">select * from friendswhere Deactivatedate < #DATEADD('d', 1, CreateODBCDateTime(now()))#</cfquery><cfoutput query = "getqueue"><cfhttp  blah blah><cfset nodes_parse = XmlParse(CFHTTP.FileContent)><cfset Nodes = xmlSearch(nodes_parse,'friends/friend/date/activedate/')><cfset roleArray = ArrayNew(1)><cfloop from="1" to="#arraylen(Nodes)#" index="i">      <cfset NodeXML = xmlparse(Nodes)><cfset ArrayAppend(roleArray, '[sel_members][]=#NodeXML.activedate.xmlTe

I've just installed CF11 on my cloud server (running Windows Server 2008 R2) for a shopping cart app using SQL Express Edition in the backend. After periods of inactivity, especially every morning, when I go into my app, it clocks for about a minute then errors out. Eventually, after another try, I'm able to run my app but it's sluggish for another couple clicks then it's back to normal.  I've been running this app on an older version of CF for almost a decade (I just upgraded to CF11 last month) and this problem never happened during that time. Can you provide any guidance on how I can fix this problem?

Hello, everyone,I've got CF10 installed on my dev system.  I've created several Solr collections.  I have turned on Sandbox Security, and added defined directory permissions for C:/ColdFusion10/cfusion/collections and C:/ColdFusion10/cfusion/jetty folders.  I have edited both paths so that NOTHING is disabled.If Sandbox is on and I remove a collection from within CFAdmin, when I try to use the CFCOLLECTION action="create" tag, I get java.io.filePermission "read" access denied messages.If I turn off Sandbox, the tag runs fine.What else do I need to do in order for CFCOLLECTION action="create" to work while Sandbox is on?V/r,^_^