ColdFusion

I have been trying to set up a local development environment on both my Snow Leopard and Lion machines.I think I'm having problems with the connectors, but the solutions I have located online have not resolved the issue. (The GUI hasn't been able to create the connectors for me either.)I get this error:9/15/12 10:36:47.104 PM [0x0-0xe00e].de.appsolute.MAMP: httpd: Syntax error on line 549 of /Applications/MAMP/conf/apache/httpd.conf: Cannot load /Applications/ColdFusion9/runtime/lib/wsconfig/1/mod_jrun22.so into server: dlopen(/Applications/ColdFusion9/runtime/lib/wsconfig/1/mod_jrun22.so, 10): no suitable image found.  Did find:\n\t/Applications/ColdFusion9/runtime/lib/wsconfig/1/mod_jrun22.so: mach-o, but wrong architectureAnd am unable to start Apache (MAMP) after manually adding the following to my httpd.conf file:# JRun Settings LoadModule jrun_module "/Applications/ColdFusion9/runtime/lib/wsconfig/1/mod_jrun22.so" <IfModule mod_jrun22.c>     JRunConfig V

Hello, all,I've got a query that is grabbing picture album names, the associated "cover" image for each album, other bits of information for each picture album, and a subquery to grab the total number of images per album.If I run the query in MySQL Workbench, everything is correct.  If I do a CFDUMP of the query, everything is correct.When I output the results to the page, the values for number of images per album is concatenating all of the values, and decrementing the number of (number of images) per iteration of the output.For example, let's pretend that my query as run in MySQL Workbench looks like:albumID          name          caption          active          imageID          imageWidth          imageHeight&nb

Is there a way to automatically submit the form on change and keep it in the layout. If I do an onchange it opens in a new tab?<cflayout type="vbox" name="status">                        <cflayoutarea>                          <cfform name="myform" format="html" action="Status.cfm" >                            <span class="ticket-functions">Status:</span>                            <cfselect name="status" onchange="this.myform.submit()"  > 

Hello, all,I've been running into a brick wall for the last day or two, over this.I'm trying to write a query that will return an ID if it exists in the database; if the ID does not exist, I want to return a 1 (numeric, not string).Here is what I have, so far, that isn't working.  (It's throwing error messages in SQL Developer).DECLARE    v_count number(2) := 0 ;     BEGIN        SELECT COUNT(thisID) into v_count        FROM tableA        WHERE UPPER(trim(thisID)) = 'zzz'              OR trim(thatID) = '987987987987' ;         IF v_count > 0 THEN            SELECT TRIM(thisID) thisID FROM (                SELECT thisID 

Hello,I am in the midst of configuring an upgraded, CF2016 based platform for my domain. I will be deploying this in a high volume, enterprise setting, so the servers I am setting up will be multi-instance servers on a windows 2012R2 platform. They will be clustered on each individual VM, but load balanced externally through an F5 load balancer. This is on a Nutanix VM host.I started this process by doing a clean install of ColdFusion 2016 on a clean Windows 2012R2 VM, and after successfully installing CF, and doing the basic setup in CFAdmin, pulling over data sources etc., I think created an image to use as the basis for our server builds. I have then created two VMs, which I have been building up as our new hosts. In the process of configuring them, I ran into an issue where I could not get the root / primary instance of coldfusion to start it's service. On both of these hosts, I can get any other services to start properly. I have not tested to see if I can hit sites on them, 

The code below gives the number of days since Januayr 1, 1900.  I have no idea why this works. Please help. ALSO, does this work in CF10/2016 ???Today is 9/29/16 so the number should be: 42640 THANKS!  <CFOUTPUT>  <CFSET DateVar = createDate( year(now()),month(now()),day(now()) )>  <CFSET DaysSince1900 = (DateVar-DayOfWeek(DateVar)-1) + (DayOfWeek(DateVar)-1)>  days since 1/1/1900 = #DaysSince1900#<HR></CFOUTPUT>

Hello, all,My boss has tasked me with finding an ISO for ColdFusion Builder 3.As per usual, since Adobe released CF Builder 2016, the links to 3 are all gone.I cannot access the Google Drive of the CF Repo located at cfmlrepo.com, so that's a no go.Given where I work, I can't just blindly accept files from anywhere.  (Yeah, I know.. I know.. I'm really not trying to be difficult.)I was kind of hoping an Adobe Staff Member could set up a link from Adobe.com, at least a temp link that would allow access to CFB3 ISO.V/r,^_^

My code runs on a shared ColdFusion server.  Therefore I do not have access to the CF Administrator.  Therefore I cannot use the CF Administrator to enable debugging.  Is there a way within my page I can enable debugging for that page?

Broken link?Send us an email.このURLは存在しません。日本語のホームページにお戻りください。他のサイトのリンクでこのページにたどりついた場合はそのサイトのウェブマスターにリンクが壊れている旨をお伝えください。Error returned: 403

I installed ColdFusion 10 on a Windows 2012 R2 server and at the time of the install specified the server to manage all of the IIS sites.  It turns out we decided we no longer want to use version 10 and want to use version 12(2016).  I uninstalled ColdFusion 10 but now when I am reinstalling I am trying to select specify specific IIS sites for ColdFusion to manage instead of All Sites and when I go to add the IIS WebServer I get the following.  "All the IIS sites are already configured by some other version of ColdFusion".I am have checked IIS and cannot not find any references to ColdFusion files for any of the sites or the server itself.

I am trying to migrate a site from a ColdFusion10 server to a ColdFusion12 server.  I have copied over the files and setup the site in IIS but when I go to add the site connector on the new server the site I am migrating is not in the drop down to select.  I have done this with several other sites so I am not sure why this one is not working.

Hi,we are using cfzip (server is linux); the problem is that when it was extracted it was under /dir1/zip_filename  INSTEAD OF just under /dir1 ?Thanks

Hello,I do not find on the site.I would select a select a.In the first, we choose the category and in the second, the elements of the chosen category.I would like this without jquery.Thank you for your helpJean Marie

Hi,We are using CF 2016. Whenever user tries to export data to excel (Sample code as below), document is appearing as blank. Blank meaning worksheets does not appear in the exported document. But if we try to save the file locally (Saved document is not loading as expected as well) and send the document over email, recipients are  able to open the document with proper data. So issue is happening only when user tries to open / save  the file locally.I even tried to comment out cfcontent , cfheader and directly displayed WriteOutput(ResultTable.Trim() ). Data is appearing as expected. Problem with the exported document.Can anyone please suggest the possible root cause for this issue?Sample code for generating XLS:<cfset Id = application.user.MVP.Id[session.Auth.GetUser_Record_ID()]><cfset Name = application.user.MVP.Name[session.Auth.GetUser_Record_ID()]><cfif isDefined("URL.format") and URL.format eq 'Excel'> <cfscript>  URL.record_id = Id; // nee

Has anyone been able to install CF 11 or 2016 on Azure?  I tried setting it up and the installer gives me the following error.java.lang.Error: Trampoline must not be defined by the bootstrap classloader at sun.reflect.misc.Trampoline.<clinit>(MethodUtil.java:51) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:348) at sun.reflect.misc.MethodUtil.getTrampolineClass(MethodUtil.java:406) at sun.reflect.misc.MethodUtil.access$000(MethodUtil.java:78) at sun.reflect.misc.MethodUtil$1.run(MethodUtil.java:301) at sun.reflect.misc.MethodUtil$1.run(MethodUtil.java:299) at java.security.AccessController.doPrivileged(Native Method) at sun.reflect.misc.MethodUtil.getTrampoline(MethodUtil.java:298) at sun.reflect.misc.MethodUtil.<clinit>(MethodUtil.java:81) at javax.swing.UIDefaults.getUI(UIDefaults.java:769) at javax.swing.UIManager.getUI(UIManager.java:1016) at javax.swing.JPanel.updateUI(JPanel.java:126) at javax.swing.JPanel.<init>(JPanel.ja

Ok, earlier I posted that I couldn't install CF Builder 3 into Flash Builder 4.7...  So I tried simply to install CF Builder 3 into a plain old Eclipse install, intending to then install Flash Builder 4.7 on top of that.BUT COLDFUSION BUILDER 3 WON'T EVEN INSTALL INTO PLAIN ECLIPSE!!!!I have followed all the instructions.  I have downloaded the newest version of 64-bit Eclipse.  (4.6-something).  The instructions say version 3.6 OR HIGHER is needed, so I assume 4.6 will work fine.  I ran the CF Builder 3 .exe file; I selected the Eclipse Plugin install option, I entered the serial number when prompted...  The install log SAYS the install is successful.  But when I double-click on the "Run Adobe ColdFusion Builder 3 Plugin" shortcut, it just runs Eclipse -- there are NO ColdFusion perspectives or anything ColdFusion-related anywhere in there!!!WHAT IS GOING ON HERE?!!!  WHY WILL THIS STUPID THING NOT WORK PROPERLY?!!!!  I HAVE WORK I NEED TO

Anyone know how to get Flash Builder 4.7 and ColdFusion Builder 3 working together in the same instance of Eclipse, rather than having them installed separately as two stand-alone programs?Here's what I've done so far:I have Flash Builder 4.7 installed as a stand-alone program, and I wanted to install CF Builder 3 into its instance of Eclipse, rather than installing CF Builder 3 as its own separate program.  I use ColdFusion in my Flex remoting stuff, and I often need to edit ColdFusion .CFC files while I'm working on Flex projects.  I had ColdFusion Builder 2 installed inside Flash Builder 4.7 on our old test-server with no problems...For our new test-server, we purchased ColdFusion 11, and it came with ColdFusion Builder 3 for free, so I want to use that instead of the ColdFusion Builder 2 that I've been using.I've installed Flash Builder 4.7 on our new test server, and it's working fine.  When I install ColdFusion Builder 3, I select "Eclipse Plugin installation" and

Hello,On CF9, I am having no issues. Currently, I am testing on a new web server with CF11 update 10. The error I am receiving is:0 is not greater than zero or less than or equal to 0.The range passed to ArraySet must begin with a number greater than zero and less than or equal to the second number.Here is a snippet of my code (not sure if you will need more than that). The bolded code is where it is saying it is erroring out on and I believe is where I need to make a change. I am more or less looking for more ideas on what to check or if something has changed since CF9 that I have not read on. I tried referencing Re: Crosstab - array error for my issue but still couldn't find a good solution. I was told to create a new thread.---<cfset bucketlist = ValueList(crosstabcolumns2.ts_desc)><cfset bucketheaders = ListToArray(bucketlist)><cfset b = ArrayLen(bucketheaders)><cfset bucketarray = ArrayNew(1)><cfset bucketTotal = ArrayNew(1)><cfset temp = arrayset(

I am able to upload 1 GB file.However, when I upload 2.2 GB file, it get struck at 99% progress. I don't get any error.I am running ColdFusion 11 on a Windows Server 2012 R2 machine.1. In ColdFusion code, I set the file limit to 3.2 GB.main cfm page:<cffileupload   url="uploadFilesProcess.cfm?par1=#STORAGEDIRECTORY#"   progressbar="true"   BGCOLOR="##FFFFFF"   width=500   height=250   maxuploadsize=3200   title = "File Upload" />uploadFilesProcess.cfm:<cfset param1 = url['par1'] /><cffile action="uploadAll" destination="#param1#" nameconflict="overwrite" />2. In ColdFusion server setting, I set the following:Max number of POST request para: 3200Max size of post data: 3200 MBRequest Throttle Threshold: 4 MBRequest Throttle Memory: 3200 MB3. In Windows IIS filter setting, I set the max allowed content length (Bytes) to 3200000000.

When using the cfstoredproc tag I am not seeing the status code being set when the returncode attribute is set to 'Y'. Below is the code that calls the stored procedure. I am running on ColdFusion 2016 developer addition and my database is DB2 10.5.<cfstoredproc procedure="NULLID.APP_PE_USRCHK" datasource="#MM_connCFWorking_DSN#" username="#MM_connCFWorking_USERNAME#" password="#MM_connCFWorking_PASSWORD#" debug="yes" returncode="yes"> <cfprocparam type="IN" value="#attributes.USERID#" cfsqltype="CF_SQL_VARCHAR"> <cfprocparam type="INOUT" value="#app_pe_userchk__ISAUTHORIZED#" variable="app_pe_userchk__ISAUTHORIZED" cfsqltype="CF_SQL_CHAR"></cfstoredproc><cfdump var="#cfstoredproc#" ><cfset caller.app_pe_userchk__isauthorized = #trim(app_pe_userchk__ISAUTHORIZED)#><cfoutput> cfstoredproc.statuscode: #cfstoredproc.statuscode#<br> app_pe_userchk__ISAUTHORIZED: #app_pe_userchk__ISAUTHORIZED#<br></cfoutput><cfif CFSTOREDPROC.ST

Hello,I am running into difficulty installing the latest hotfix 21 on my developer edition CF. I haven't had issues before with installing hotfixes.I am installing using the Windows command line as the CF Admin method has never worked (can't download the fixes due to our network issues)The 3 fatal errors in the log file:ERROR - Could not move the file C:\{CFPATH}\lib\updates\{filename}.details to the backup location C:\{CFPATH}\hf-updates\hf-10-00021\backup\lib\updates\{filename}.detailsERROR - Could not move the file C:\{CFPATH}\lib\updates\{filename}.notes to the backup location C:\{CFPATH}\hf-updates\hf-10-00021\backup\lib\updates\{filename}.notesERROR - Could not move the file C:\{CFPATH}\lib\updates\{filename}.hotfix_021.jar to the backup location C:\{CFPATH}\hf-updates\hf-10-00021\backup\lib\updates\{filename}.hotfix_021.jarI am running the Windows command line as Administrator. So I don't believe it's a permission issue. Especially since other files are written to those location

Our company recently upgraded from CF9 to CF 2016 and after doing so we have a CFGRID that only displays the left hand paging button/arrow. All the other toolbar buttons are missing.I have searched and searched and cannot find the reason for this. I don't appear to be getting any script errors. Does anybody know what might be causing this?

I want to ask for how to set the condition for how to show the price at the last line of description. for exampleHeader 1no    Description                         Price1      testting        testing        testing                                10.00Can anybody give me some advice or solution? Because the decripstion may be got 1 line, 2 line 3 line or more.

What is CFC and how do I get it?

Hi,Currently we have ColdFusion 2016 Update 1 installed on our deployed server. After we upgraded our CF version from 9 to 2016, all cfgrids combobx columns started behaving a bit strange. Grid combobox columns are not displaying the exact values defined in cfgridcolumn values and valuesdisplay list. We have some links on the grid that opens up a pop-up with cfgrid. This grid combobox list data is getting mapped to the parent grid combobox list.For ex: If the parent grid second column is a combobox and values="true,false" and the pop-up grid second column combobox values="FE,TSE,TS", If I try to edit pop-up grid second column, true/false is appearing in the combobox list.Strangely this is happening with all the grids that have editable combobox columns. Can you please help me with theGrids settings is something like:<cfset gridArgs = structNew()><cfset gridArgs.name = "LoansGrid"><cfset gridArgs.pageSize = 20><cfset gridArgs.format = "html"><cfif SERVER.ColdF