Questions

I'm creating 2 filtering drop downs and I can't figure out why my code isn't filtering the results on the page.  Please help...Here's the code.<cfparam name="form.personnel" default=""><cfparam name="form.status" default=""><cfquery name="q" datasource="#dsn#">     SELECT *     FROM table     WHERE 1=1          <cfif val(form.personnel) GT 0>               AND Sector = <cfqueryparam value="#form.personnel#" cfsqltype="cf_sql_varchar">          </cfif>          <cfif val(form.status) GT 0>               AND reqStatus = <cfqueryparam value="#form.status#" cfsqltype="cf_sql_varchar">    &

Where do I see a list of my discussion threads?  I'm not crazy about the navigation of the forums.  The old, original one was much better and easier to navigate.

I'm very new to ColdFusion and learning things as I go.  I'm wondering how to import an array into a dropdown list.  I created the array and the dropdown but can't get it to work properly.  I would like to see a quick example.Please help thanks...

Hi,I'm using a VPS with CF 8.01 (Enterprise) and recently upgraded Java from 1.6.0_04  to 1.6.0_11 to fix a memory leak issue.Changed the jvm.config lines below to reflect the upgrade:#java.home=C:/ColdFusion8/runtime/jrejava.home=C:/Program Files/Java/jdk1.6.0_11/jreThe system info in CF admin still says the java home is C:\ColdFusion8\runtime\jre and the version is 1.6.0_04What's worse, is that in CF admin under 'Java and JVM' I now get the following error:Element JDKPATH is undefined in FORM. The error occurred in jvm.cfm: line 174Called from jvm.cfm: line 145Called from jvm.cfm: line 143Called from jvm.cfm: line 1-1 : Unable to display error's location in a CFML template.So I'm now unsure if the server is using the newly installed 1.6.0_11 java version or the old version.Does anyone know how I can fix this error in CF admin?Any help appreciated.Thanks,Robin.

I have some fields that are varchar, however, they have numbers in them.  JSON does not return them inside quotation marks because it is interpreting it as a number.  Real numbers do not work, either.  Is there a workaround?<cffunction name="jqgridCP" access="remote" returnformat="json">I'm trying to populate a cfgrid with data from a cfquery.  The fields that have numbers as data (not all do) but are varchar in the database return empty cells.It appears to be adding .0 to the numbers.

Am having difficulties getting to talk to tech support about this one.  Work for a Municipality which got ColdFusion V 3.1.2. installed 7 years ago before Adobe ownership.      Water plant stores O&M manuals in it.    It has apparently never been updated.    Now the IT dept. wants to update the server because is Windows Server 2003 and is running out of support, but does not know what to do about updating ColdFusion.My questions; if is web-based, why a local server is needed?   If so, can the keycode be moved to a new server with a 65-bit OS?.   Is it a new version of ColdFusion needed?   If so, does a new product and/or support has to be purchased?I appreciate any help on this.

I have two report functions:1. counts all the occurrences of courses that match a specific school year.2. gives me a total count of coursesI also need to count the occurrences of  courses that do not match a specific school year. How can I subtract the value from the first report from the second report function?Is there a better way to do this?

Hi... trying my hardest to make the CFC Generator work in CFB 3 but my error logs are filled with errors. The one in particular:Failed to install extension Adobe CFC Generator.zip -Directory "Adobe CFC Generator" already exists at install location... and here is the stack trace:com.adobe.ide.coldfusion.appcodegeneration.install.ApplicationDirectoryExistException: Directory "Adobe CFC Generator" already exists at install location  at com.adobe.ide.coldfusion.appcodegeneration.install.IDEInstallManager.extractZipFile(IDEInstallManager.java:440)  at com.adobe.ide.coldfusion.appcodegeneration.install.IDEInstallManager.installIDEApp(IDEInstallManager.java:403)  at com.adobe.ide.coldfusion.appcodegeneration.install.IDEInstallManager.install(IDEInstallManager.java:157)  at com.adobe.ide.coldfusion.appcodegeneration.install.ExtensionInstallAction.install(ExtensionInstallAction.java:164)  at com.adobe.ide.coldfusion.appcodegeneration.install.ExtensionInstallAction.acces

I received a CF11 marketing email today from Adobe with the Subject line: "Adobe ColdFusion 11: lots more to explore!".  So I clicked the link at the bottom to whitepapers and other resources.  I was surprised there are no datasheets, whitepapers or anything regarding CF11 here Data sheets and White papers | Adobe ColdFusion 11 Family.  Why not?  Makes it seem like Adobe doesn't care.  It's especially odd given that it's in a promo email specifically for CF11 asking me to "explore", yet there was nothing to explore.  This is feedback for Adobe marketing.  Thanks for listening.

Hi I have Windows 2003 server with CF11 installed. also I have SQL Sever 2005 on different server. I can not connect to SQL database it shows error 'Connection verification failed for data source: DBTest java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Conflicting connection information. When the instance name is specified, it is invalid to specify the port number. The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Conflicting connection information. When the instance name is specified, it is invalid to specify the port number." ?

Hi, all,We've got IDA's who are testing our work by attempting to SQL-inject harmless code into our project(s).Because of the way we have both DEV and PRODUCTION set up, whenever their attempts cause an error, all they see is a generic error message that comes with a 200 response.  This is going into the webserver log as 200.In order to see what happened, the IDA's have to pull the PCAP data and manually scan that, looking for the events.Is there a way to trigger something other than 200 responses, so all they have to do is look at the webserver logs?(Yeah.. I know..  a dev actually trying to make an IDA's job a little easier????  Has Hell frozen over??)V/r,^_^

Hi, We noticed that a call to https://www.googleapis.com/ via CFHTTP stopped working after our sysadmin switched the IP of our web server. The error from ColdFusion is:JSON parsing failure at character 1:'C' in Connection Failure After researching, I tried using the keytool ([CF 10 root]/jre/bin/keytool.exe to import the top-level certificate (GeoTrust Global CA), which was exported from Google Chrome 42 in DER format.I used the following flags:-import -v -alias GAGLOBAL -file [.cer location] -keystore cacerts -storepass [password]It appeared to add correctly, as it displayed the owner, issuer, etc. and asked if I wanted to trust the certificate. I replied "yes", and it responded "Certificate added to keystore" [Storing cacerts]. I then restarted the CF 10 application service. The same error persists.Please advise.Thanks,Dave

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