ColdFusion

I have the following script that will fire off an email when a set number is achieved, ie: "minrequire" is set to 6.  When six students have subscribed, an email is sent to the moderator. The problem is the email is being sent multiple times as more students subscribe, instead of only once at 6. Below is the script I am using. Why is this sending more than one emails?<cfquery name="getNumber" datasource="#application.dsn#">    select CourseTitle, rid    from signups    where courseTitle = '#eventname#' and rid = '#rid#'    </cfquery>        <cfif getNumber.recordcount EQ #getCount.minRequire#>

I'm not highly technical, and this is probably something easy, but here is my dilemma.First, define some variables:<cfset datasource = '#MyDatabase#'><cfset query_tbl = 'MyDatabaseTable'><cfset field1 = 'actual_fieldname'><!--- a field in MyDatabaseTable --->Then, run a query using those variables:<cfquery name="cfqGetItems" datasource="#datasource#">  SELECT *   FROM #query_tbl#   ORDER by #field1# ASC </cfquery>Then, attempt to display the query output:<cfoutput>  <p>#cfqGetItems.field1#</cfoutput>Insead of the values for "actual_fieldname", I get an error message: "field1 is not defined in query cfqGetItems".I realize that defining the output as "#cfqGetItems.field1#" is incorrect, but how can a "translation" be done?  What is the correct way to get the output to generate the values for "actual_fieldname" instead of thinking it is still dealing with the variable "field1"?Thank you very much for any help!

The tech specs do lot list this OS (http://www.adobe.com/products/coldfusion-standard/tech-specs.html) but it is liseted on the Enterprise Edition specs (http://www.adobe.com/products/coldfusion-enterprise/tech-specs.html)

I just posted a comment over on Ben Nadel's site about this issue but I wanted to get some feedback from my fellow ColdFusion developers to see if anyone else has ever experienced this issue:I have a function within a CFC that creates a query object and then nests another query object inside it (masterQuery > subQuery). The CFC returns the query object and to make things easier I loop through the query columns and bring everything into the local VARIABLES scope using the following format: "#a#" = masterQuery["#a#"] where "a" is the name of the query column.After I had all of the query columns in the VARIABLES scope I tried to run a QofQ on the subQuery and low and behold I got an error message:"coldfusion.sql.QueryColumn cannot be cast to coldfusion.sql.QueryTable"However, when I tried a different method for bringing the masterQuery columns to the VARIABLES scope, I was able to get it to work: "#a#" = evaluate('masterQuery.#a#')After doing some playing around using GetMetaData().get

I don't usually get this type of error message when using cfinvoke this way (see below) but this time I keep getting this error no matter how I modify my logic or my codes.I've spent a week trying to find what's going on and could not find the answer. Can anyone help please?This is the last modification I made with my codes and I still can't get pass this section due to the error message.This expression must have a constant value. RowIteration.cfc: line 107105 : ThisRowNo="#Trim(arguments.ThisRowNo)#"106 : Camp="#arguments.Campus#"          107 : LYear="#arguments.LYear#"> Here is how my codes, it used to work when I do it this way:<!--- I'm looping over an array & validate each required array elements --->  <cfset arr_FileContents = ListToArray(list_w_null2,chr(10), true)>  <CFSET var_Count=1> <cfloop index="i" array="#arr_FileContents#">    <CFSET PipeLine = Replace(i,chr(9),"|", "ALL")

We are seeing this error since going to ColdFusion 10 enterprise. We have installed all the updates. Server is Windows 2008 64-bit with all the latest updates applied.This appears to be very random, but it is causing some headaches with the mail spool. If 10 emails are in the queue, 9 will go out and 1 will go to undelivr even though all the parameters are the same. We move the file back to the spool and it goes through.Right now I am dedicating a resource to monitor the spool so all emails go out (we send out hundreds per day from our app) but we need some type of resolution. Any help is appreciated!

Hi all!I'm having an issue where cfgridcolumn takes the number 65.20 and displays it as 65.2 because it appears to always round to 1 digit after the decimal.How  do I get it to display "65.20"? (two digits after the decimal)Thank you!B.

Hello,I have some code that can be used to check if a URL exists where arguments.u is a full URL (http://www.google.com/ for example) - from this I can determine if a URL exists or not as part of a broken link checker for our content.<cfhttp method="head" url="#arguments.u#" resolveurl="no" throwonerror="no" />But, in some cases, that arguments.u will be a https URL, like https://www.keeleklikk.ee/ - which is a valid URL and I can access it no problem.But this gives me the following response from the cfhttp:structCharset[empty string]ErrorDetailI/O Exception: peer not authenticatedFilecontentConnection FailureHeader[empty string]MimetypeUnable to determine MIME type of file.Responseheaderstruct [empty]StatuscodeConnection Failure. Status code unavailable.TextYESHow can I modify my cfhttp call so that it properly checks https URLs as well as regular http ones?Thanks,Phil.

Please reply soon.

This is probaly a begineers question so apologies if it is a bit basic. It could also be a MySql fix rather than Colfusion!I have a textarea field on a web form using the popular text editor ckeditor. The form is posted to a Coldfusion page and the data is added to a MySQl database.This works fine until someone adds a " in their text input. This being the escape character an error is generated!ie:<cfquery name="insert" datasource="text_test">insert into TEXT (TEXT1, TEXT2) values ("#Form.text1#", "#Form.text2#");</cfquery>Any theories on how I can get round this would be gratefully apreciated.Many thanks,Paul.

My question is not specific to ColdFusion, I know how to set HTTP status codes.What I am wondering is if anyone knows of any best practices for what to do when a known attack comes into a site. I am speaking primarally of specifically formatted URLs of people scanning to find weaknesses in my sites.I have collected a large number of URLs that we get scanned for regularly that are clear attempts to locate weaknesses.Should I?Send a 404 telling them the attacked page does not existsSend a 503 making them think it erroredSend a 200 with a blank page making them think they go to a real pageSomething else I havn't concideredI am trying to avoid any sort of escalation on their part thinking they can hit my site harder, IE, if they get a 503, might they believe that my site could be weak and they step up the attack...Any thoughts would be greatly apreciated.Thanks

Hellow everyone,I want to be able to search the whole keyword not just the part of this.  For example, if user enters a keyword "material", i want the results return the list of document that contain the whole word "material" not matter, match, matchup, etc.I've tried with type="explicit" but  got an error message ""error executing query:unknown_handler_explicit".  It doesn't matter what type i specify, i always got this message.  Can anyone plz help?ThanksLisa<cfsearch      name = "myDoc"     collection = "customer"     criteria = "#url.search#"     type="explicit"     startrow=1     maxrows = "100">

We have CF 10 Enterprise installed on Window Server 2008 R2, using IIS with multiple web sites defined. These are set up in IIS in the standard way of mapping a domain name to an IP address. The sites are pointed to various directories on the D drive and CF is installed on the C drive. What is happening is that occasionally a call to a CFM script will error out, and in the CF log it shows that the file wasn't found because CF was looking for it in C:\ColdFusion10\cfusion\wwwroot instead of in the correct directory on the D drive. I did some testing by adding an index.cfm to C:\ColdFusion10\cfusion\wwwroot and I found that file overrides the index.cfm in the root of the site in IIS. How can I get this resolved so that the CF web site is not interfering with my IIS web sites?

Got a cfserver that needs quite a few datasources, so it's tedious to enter them by hand. Is it possible to do a trick like the old copying neo-query.xml?

First time I tried this tag CFPDF to create images of each pages.But, the quality result is fully unacceptable. Bad images, and text unreadable.Loosing time. Why creating such tags ?I am using CF v9.Is there progress in next version ?or is there someting which can be done to get the Quality ?Also the scale at 100, is very small compared to original PDF.it seems it does 50% at 100 scale ?Thanks for any help.I am vey desapointed.(last message I have seen in the forum date of 2010, so I post this new)Pierre.

This is critical.Our server is giving the folloowing 500 error:java.lang.NullPointerException at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:285) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)I have restarted the entire server a few times, but this error keeps coming up.This is business critical, and I am not an expert at Cold Fusion.  Please help!

Hello, CFers!I need to access a remote page using the cfhttp. To be more specific, I need to access this page: https://sistemas.dnpm.gov.br/SCM/Extra/site/admin/dadosProcesso.aspx?numero=861738&ano=2013 (Sorry, Brazilian government sites works better only in the I.E.)This is a site of the Brazillian government that supervises mining areas all over the country. Each mining area has its own "numero" (number) and the "ano" (year) when it was registered at the National Department of Mineral Production - DNPM agency. As you can see (if you clicked the link to the DNPM website) there's a tab "Poligonal" at the top of it. Clicking on it will start a function created probably by the ASP.NET and it will generate a PNG image showing the area and some other processes near it. Example of the link above:So here is the problem: Can I get the data from the "poligonal" tab using the CFHTTP, knowing the poligonal page doesn't have a direct link? I tried all I could to find a way to get this image,

Hi Guys,Anyone saw this error when use the cfpdf tag?I need extract a text of a pdf file, but when run the script the CF Server show me this error:PDFDocException <p/> Created on Sep 12, 2006 How I solve this exception?Anyone know?TksHugsFabiano Magno Pechibella

Anyone else seen this error? It appears to be random. TIA!, -Aaron Neff

I have a report I print tracking the number of events in different categories.  Events are single items and never parts of items.The charts I am generating have the y axis divided in all different ways.Is there a way to force the y axis to be whole numbers?  I'm using CF9.ThanksExamples

Has anyone used the cfexchangecontact tag with the cfexchangefilter tag? According to all the docs I'm seeing the following should work to pull down all exchange contacts for a user: <cfexchangecontact action="get"         name="qContacts" username="#mailuser#"           password = "#mailuserpassword#"         mailboxname="#mailboxname#"           server="#mailserver#" />         <cfexchangefilter name="maxRows" value="-1"> </cfexchangecontact> ... but it generates an error: Context validation error for tag cfexchangecontact.Either the end tag </cfexchangecontact> encountered on line xx at column 3 requires a matching start tag or tag cfexchangecontact does not support end tag. cfexchangecontact works fine without an end tag, but only returns 100 records (the def

I am currently looking for a BA in the St. Louis Area who has developed in ColdFusion. You could possibly work from home, this is a project. If you are interested or know anyone who would be, please email me at kafowler@stephenjames.com.

Our application contains some legacy code that still relies on cfgrid. We’re finding that our end users can no longer use these pages once they have upgraded java. When they try to use these pages with Java 7.51, the users receive the following general exception: “Name: coldfusion.applets.CFGridAppletSecurityException: Missing required Permissions manifest attribute in main jar: http://[host]/CFIDE/classes/cfapplets.jar”.  Has there been a new cfapplets.jar released with an updated manifest for the new Java security?  If there hasn’t been one, were is the best place to check for updates of this nature?I’m aware of the ability to add our sites to the exception site list in java as outlined here: http://www.java.com/en/download/help/java_blocked.xmlHaving the user down grade will also work as a temporary solution as well.The only server environment I tested on was CF 9,0,2,282541 

I have ColdFusion 8 running on Windows Server 2008 with IIS 7.  Lately JRun has been crashing every few minutes.  I don't know what the cause could be.  Can anyone give advice on how to fix it?The jron error I am getting in the server log mentions MSVCR100.dll and states:

Anyone else having issues recently with DDX calls that seem to return corrupted text from recent PDF files. Coincidentally, Firefox 26 renders the same same document incorrectly. AFC