Questions

Hi all,How can I compare a date in query of query? The date can be null in some records.       <cfquery name="qryData" dbtype="query">             select *             from qryTempData             where (datecompare(ppbe_id_expiration, dateFormat(now())) >= 0) OR (ppbe_id_expiration is NULL)       </cfquery> I also try:        <cfquery name="qryData" dbtype="query">             select *             from qryTempData             where (ppbe_id_expiration is NULL) OR (cast(ppbe_id_expiration as date) >= cast(dateFormat(now(),'mm/dd/yyyy') as date)   &

I have a ColdFushion (9) function calling a SelfHosted WCF C# WebService. I publish it to my Virtual Server, and call it from SoapUI and it works.When I call it from ColdFushion using CFInvoke, I get a red box with a list of methods.When I call it from ColdFushion using CFHTTP, I get xml with structure names but no data. I cannot help but think that how I receive the response in CF might have something to do with not getting my email record(s) data, since it works in Soap UI.

I have a Calculated field that is set up for a Distinct Count the Perform Calculation on looks like this:(query.prg_cod EQ "UNDERGRAD " AND query.level_ LTE "2" AND query.soc_sec)Sometimes it counts the when the prg_cod is not equal to "UNDERGRAD " and sometimes it counts when the level is "3" or "4". It also counts the first record in the group regardless of the values.I am using the Report Builder.

‌ggood morning,i am new to This forum. I am working on a PC, using MySQL and Coldfusion 9. The query below does a multiple row insert just fine with one problem. The query is inserting the same ID of one of my students the number of times that I specify. Is there a way to loop through the insert so that all of the different ID's of the inactive student are inserted for each new row? Am I missing something obvious?<cfquery name="maxID" datasource="master">select max(stuid) as maxid from student</cfquery><cfquery name="student" datasource="master">select count(stuid) as inactive_numberfrom namewhere type = 'senior'AND squadlt = '#session.user_id#'AND CITY = 'richmond'AND STATUS = 'i' order by stuid</cfquery><cfquery name="student2" datasource="master">select stuid, fname as namefrom namewhere type = 'senior'AND squadlt = '#session.user_id#'AND CITY = 'richmond'AND STATUS = 'i' order by stuid</cfquery><cfset initialmaxid1 = (#maxID.maxid# + 1)>&lt

Hi,I'm using CFGRID to display the result of a search function using a query on a page. The user may hide some columns from the CFGRID page.  Then the user exports what is shown (only selected columns) on the page.  Currently, the user can export to PDF but all columns are included. As a temporary solution, I advised the user to use PREVIEW on the page then print to Adobe Writer to create a PDF.    I spent time searching in the internet, but haven't found any solution.  There's one blog from Raymond Camden - Exporting from CFGRID | Raymond Camden's Blog, where he mentioned about ColdFusion.Grid.getGridObject using CF8.  When I looked at the CF documentation, it led me that this object is using Ext JS JavaScript library, which I'm not familiar with.  I am using CF10, which seems to be using Ext 3.1 version (?). My question is....Is it possible to export to PDF only the selected columns from my CFGRID page?  Anyone has done it?Where can I find

Everyone,This may be a very basic question, but I am just not getting it.  What I am looking to do is the following:  I have Meraki wireless access points installed and I want to use the API search through the list of MAC addresses to see which users are connected and display that they are in the office on an internal web page.The Meraki's send the data in JSON format.  This is where I am having a problem figuring out what to do.  I know I need to send the JSON to a Coldfusion page but I am not sure how I should be capturing the data on the Coldfusion page.  I have tried reading the examples but I am just not sure where to begin.  Any help that can be provided would be greatly appreciated.Thanks in advance.Dan

My CF application links to the MS SQL database of my accounting application. If a specific record is being edited in the accounting application and I try to update that specific record using the coldfusion application, the coldfusion system hangs until the accounting application releases the record. This is fine except the user in the accounting application may have left the editing screen open and the record may not be released for minutes or longer. Once this is the case the hanging coldfusion request creates further locks.How can I manage the situation so that I can send a message to the user that they cannot gain exclusive access to the record and so cannot update it until the record is free thus preventing the hanging situation which escalates the problem?RegardsRichard

Can you migrate Cold Fusion 7.0 to Cold Fusion 11.x?

Have a CF template that uses the cfhttp command to execute a template that extracts and formats data from the database.  When using the cffile command to write that information to a file:<cffile action="WRITE" file="#pdffolder##getpdfid2.pdfid##client.account#letter.html" output="#cfhttp.filecontent#" mode="644">the execution receives the message""cfhttp.fileContent has length of -1"Trying to figure out how to determine the cause of this issue,RegardsWeldon Moore

I'm using bootstrap to create a pop up windows which will have a wizard, when you click on the button "Launch demo modal" it will give you the pop up windows to select the date and then you will click next, on the next page in the same windows I would like to somehow display the results from the selection from the first window, see below for what I am looking to do, certain tags might be out of place but this should give you an idea. If anymore has experience or have an alternate way of doing this , input is apprecicated.One question I have is how do I make the "next button" save the selection from the calendar which I can then cfoutput out to the next step.<button type="button" class="btn btn-primary btn-lg" data-toggle="modal" data-target="#myModal"> Launch demo modal </button>  <!-- Modal -->  <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">    <div class="modal-dia

Are ColdFusion's clickjacking filter options (Clickjacking issue - adding multiple url patterns in a single filter mapping) needed if using Internet Information Services' (IIS) HTTP Response Header option setting X-Frame-Options?  Is ColdFusion (Java) interpretation of page IFRAME content occurring independently of IIS web server's interpretation?

I have a few questions about CF 11. I have just installed CF 11 on a Windows 8 server. Thisis an all new server and software installation. It isn’t to where it can beviewed outside of our network just yet until we have everything installed andrunning properly on it. When it is all complete we will turn off the currentserver and change the name of this one and make it public. We have thecertificate on it from the live site. So the name of the certificate and thename of the server do not match.I have had my websites on CF 7, CF 8 and CF 9servers previously. We have used mappings on all of our previous versions with image tags and ahref tags. Havethings changed in CF 11 to not allow this anymore? An example is <imgsrc="/PACTlogin/loginIMages/LoginPicture1.jpg" alt="Login Image"/>.(/PACTlogin is the mapping) We use the mappings like this because we havedynamic pages being built. The same goes for ahref tags. An example of it is <ahref="/pact/pactacademy/Index.cfm">PACT Academy

Hi,Can anybody instruct me to install verity k2 server manually on my windows server. without interpreting the current settings and functioning. System Information Server Details Server Product ColdFusion Version 9,0,2,282541   Edition Enterprise   Operating System Windows Server 2008 R2   OS Version 6.1   Adobe Driver Version 4.1 (Build 0001)   Should you need any further information please do let me know Thanks in advanceAmal

Does anyone know where to find it if it is? Someone at my work told me that you have to install 11 and then downgrade. Is that true?Thanks,Andre

I need to give counts of students in various different groups (FR/SO, JR, SR that have enrolled and have not enrolled). This count is needed for about 30 awards. I am looking for recommendations.

How big of a security issue enabling RDS on developer server for ColdFusion Builder? What's your take on it? If it's on a dev box, is it okay to enable RDS?Thanks!

In the Debugging & Logging > Log Files screen/page, are there workarounds for easily export/download the data that's listed in that screen? I do not want to download the log. Basically, all I want is the table that shows the File Name, Type Size, and Last Modified information.Thank you,Charlie

I have a report that outputs to an excel spreadsheet. One of the columns is Estimated Amount that is based on Total Amount * Yield Rate. My user want the ability to change the Yield Rate on the spreadsheet and see the new Estimated Amount. Is there a way to accomplish this in Report Builder?

I use a bespoke CMS to FTP all CF files from my CFserver to a different server that can only host static HTML files.I do this by using a <cfloop> but FTP is to slow to take all those several hundred pages in just one loop.In the loop I currently use<cfloop ...>     <cftry>          <cfftp ...>          <cfcatch type="Any">               <meta HTTP-EQUIV="REFRESH" content="1;url=thispage.cfm">               <cfabort>          </cfcatch>     </cftry><cfloop>To restart the loop where it broke and start again by 'reloading' the page...However I would like to automate this using <cfschedule> - but <cflocation>

If I modify the file to point a data source database to a similar SQL server hosting a copy of the same database, can this work without breaking CF?CF version: 9 standard.

CFIMAGE captcha was working on my DEV system, where the wwwroot is in the same folder as CFServer is installed.It is NOT working when I move it to staging, which is identical to production - including the fact that CFServer is on 😧 drive, but wwwroot is on E: drive.Is there a way to map a location for the CFFileServlet folder?  I think this is the reason it isn't working in staging.V/r,^_^

Hello, I made the switch from CFBuilder 2 to CFBuilder 3 and would like to get the same color coding in CFBuilder 3, but this seems very difficult to achieve. I tried the different provided profiles, but none of them seems to match.Is there a way to use the same profile (by importing it from CFBuilder2 or so)? Thanks in advance

I'm trying to troubleshoot some bugs and errors in CFB3 and after I run the uninstaller and reinstall Coldfusion Builder 3 my projects all magically reappear as soon as I open the newly installed version of CFB3. Can anyone share where these property/xml files are that keep this info around on my machine? I'm on Mac OSX 10.10.2 and I'm working with CFB 3 version 3.0.0 build 292922.Thanks,Rich

Is there an easy way to do this?A client needs to scan all code and, of course, it doesn't scan cfm's.It will scan java. 

My agency recently started using HP's Fortify Scan tool, which is designed to scan CF code directly, rather than the rendered page.  The scanner always seems to flag our pages for a certain error when I use the following code (used to create a PDF on the fly): <cfheader name="Content-Disposition" value="attachment;filename=#pdffile#"> <cfcontent type="application/octet-stream" file="#expandPath('.')#\#pdffile#" deletefile="Yes"> 01. is line 299 in my code.I'm basically generating a filename elsewhere on the page that's based on what a user is requesting, then using the code above to create a downloadable PDF of that file.The error is: Header Manipulation (Input Validation and Representation, Data Flow) The file myfile.cfm includes unvalidated data in an HTTP response header on line 299.  This enables attacks such as cache-poisoning, cross-site scripting, cross-user defacement, page hijacking, cookie manipulation or open redirect. I'm thinking there's one of two po