ColdFusion

Hello. Does anyone successfully use the coldfusion builder debugger or even successfully launch a site wirh URL rewriting? For example:C:\Site\Controllers\Login.cfc -> http://website.dev/loginI just loaded up the site myself myself and never used run or run configurations in ColdFusion Builder but now that I am trying to debug it is pretty annoying to get an invalid URL every time I debug.Thanks for any ideas or pointers. ~ Ben

Hello, everyone.I need to do a QoQ and get a COUNT() of the records that fit a certain criteria, using TRIM and UPPER to make sure the match is solid.In Oracle, it would be SELECT COUNT(*) as TOTALS FROM tableName WHERE UPPER(TRIM(both ' ' FROM columnName)) = 'THISWORD'But Oracle conventions don't work in QoQ.  What would be the CF QoQ equivalent?  (I'm sure it's something simple and I'm just too tired to see it.)Thanks,^_^

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-738f.html

Hello!I'm on the phone to Adobe, but at over an hour in the queue it's not looking promising.We're looking to buy CF10 enterprise, We have a development server, a staging server (acceptance testing), the production server and a failover server (disaster recovery).Will the licensing of ColdFusion for the production server allow the other 3 environments to run the fully fledged CF enterprise with no IP restrictions? Any insight in what happens during install?I don't want to be using the developer edition of CF10.Any answers?Thanks, Dan1hour 40minutes in the queue ... still no idea when someone will answer.

I've seen a couple posts about this on a couple different sites/blogs, but no solutions, so I figured I'd post the question myself and see if anyone's come up with any workarounds or alternatives.I love the functionality of the cfinput type="datefield", but I'm having the common problem that I cannot get it to display inline. For example, I'm working on a calendar, and on the create_event.cfm page, I want to use these inputs for the dates and for repeating event options. The line I'm trying to have on the page is:Repeat daily until <cfinput type="datefield" name="repeatuntil">However, when the page loads, because of the <div> tag and css that CF automatically generates, it aligns the datefield to the left, as if it was written like this:<cfinput type="datefield" name"repeatuntil"> Repeat daily untilDoes anyone know a way to override the automatically generated css to get it to display where I want it? If not, does anyone know of a good alternative where I can still ha

Hello,I try to update a  CF 10 Developer Edition to CF 10 Standard Edition .On the System Information page I entered a new  product serial number in the New License field and press submit button.The Licence Key was saved but the Edition is still "Developer".Do I have to install the software again?System Information:Server Product ColdFusion Version ColdFusion 10,282462 Tomcat Version 7.0.23.0 Edition Developer     Operating System UNIX   OS Version 5.10   Adobe Driver Version 4.1 (Build 0001)   regards Claudia

Hello,We migrated our site to 64-bit Windows 2008 recently. The consequence of the migration is that DLL files that were compiled in 16-bit systems would no longer work in Windows 2008 -- specifically the CFX_FMakeTree.DLL which is throwing an "unable to load library" error. Does anybody know if there's a 32-bit or 64-bit version of that DLL? If not, what are you using as a replacement? Thank you.Best regards,Chung Lee

I believe I've encountered a bug in Coldfusion 9 and 10.  Whenever includeEmptyValues (the third parameter) of ListRest is set to true it appears to return the entire list with no elements removed.I've verified this behaviour with the following test.<CFSET olst = 'a quick red fox jumped over the lazy brown dog'><CFSET rlst = ListRest(olst, ' ', true)><CFDUMP var="#rlst#">The result is "a quick red fox jumped over the lazy brown dog".

In the past couple of weeks hackers have somehow been getting access to my application.cfm file and altering it, making my website not come up properly.Is this a known security problem and does anyone know how to protect the file from getting hacked?

Hello,I'm trying to encrypt a file with CFEXECUTE, using OpenSSL. When I run the code in the command prompt, it works fine and the new encrypted file appears in the correct folder. Also, I can run CFEXECUTE with OpenSSL with just one argument and it works fine. ie arguments="version". But the following does not return a value, nor does it create the new folder:<cfexecute name = "C:\Program Files (x86)\GnuWin32\bin\openssl"    arguments = "aes-256-cbc -a -salt -in ""C:\Users\Dev2\Documents\My Stuff\OpenSSL\secrets.txt"" -out ""C:\Users\Dev2\Documents\My Stuff\OpenSSL\secrets2.txt"""     variable = "result"    timeout = "5"></cfexecute><cfdump var="#result#">Any ideas?Pete

Hello, everyone.What is it called when you are CFOUTPUTting records from a database, but you limit it to (arbitrarily) 5 records, and include a "More..." link at the bottom that, when clicked, appends the next five records to the ones that are there?Whatever it's called, I'm looking for a script to do just that.Thank you,^_^

Hello, everyone.We're using CF9 in both dev and production environments, with little chance of upgrading to CF10 anytime in the near future (it's my understanding CF10 does have a way of detecting a file mimetype that CF9 doesn't have.)What is the best way to restrict uploads to specific file types in CF9?  We just need to limit uploads to primary Office (doc(x), ppt(x), xls(x), etc.), PDFs, and gif/jpg (no bmps, pngs, etc.)Obviously, just detecting file extension is fruitless.Thank you,^_^

Hi, I have an application where onMissingTemplate would fire off when any missing .cfm file was executed.  This was in CF9, I upgraded to CF10 and it no longer works as expected.  Is there a setting I need to change in CF10?CF9/application.cfc - with onMissingTemplate/doesnoteexist.cfm - Fires onMissingTemplate/nofolderhere/doesnoteexist.cfm - Fires onMissingTemplateCF10/application.cfc - with onMissingTemplate/doesnoteexist.cfm - Fires onMissingTemplate/nofolderhere/doesnoteexist.cfm - DOES NOT fire onMissingTemplateThanks for any help!

After having made several attempts to migrate from a ColdFusion 8 Standard server to a ColdFusion 10 Standard server, it feels like I am "almost" there. I'm using the 64 bit installer from Adobe's website.I'm using a Windows Server 2008 (64 bit) server with IIS 7.5.The installation itself goes smooth and the services start and are running. But at the end of the installation it says "ColdFusion Installed, but with errors" and it generates a log file.The log file reads:Migration Error: : Check that "C:\ColdFusion8" is a valid directory and is an installation of either ColdFusion MX 6 or ColdFusionMX 7and further down says:Status: WARNINGAdditional Notes: WARNING - Could not migrate settings from previous version of ColdFusionCustom Action:com.macromedia.ia.action.MigrateColdFusionActionStatus: ERRORAdditional Notes: ERROR - class com.macromedia.ia.action.MigrateColdFusionAction NonfatalInstallException nullThe applicationHost.config file has new XML referencing the ColdFusion 10 director

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7347.html

I'm working on inserting a recordset up Google Calendar entries into my site database. I have a form set up that allows me to insert new entries into the data table, but when I try to loop the insert query over the Google recordset, I get nothing (no errors, but no entries added to database).Here's my form, which both displays the values from the Google query and populates fields (mostly hidden) with those values to submit to the Insert query. There's also a line that checks to make sure the event hasn't been canceled (canceled events are still listed, the start and end times are just set to null values):<form method="post" action="<cfoutput>#CurrentPage#</cfoutput>"><table cellpadding="2" border="1"><cfset thisRow = 0><cfloop query="band_events"><cfif IsDefined("starttime") AND IsDefined("endtime") AND starttime NEQ "" AND endtime NEQ ""><cfset thisRow = thisRow + 1><cfoutput><tr>  <td>#thisRow#</td>  &l

HiI am trying to invoke a .net webservice method that receives an array of strings an i noticed that if i do this:<cfscript>     text = arraynew(1);     text[1] = "Hello";     text[2] = "world";</cfscript><cfinvoke method="Hello"  webservice="http://localhost/Service1.asmx?wsdl"  returnvariable="response">     <cfinvokeargument name="array" value=#text#/> </cfinvoke>I get this errorCannot perform web service invocation Hello. The fault returned when invoking the web service operation is: ''java.lang.IlligalArgumentException: argument type mismatchhowever if i do this it works well:<cfscript>     root = structnew();     text = arraynew(1);     text[1] = "Hello";     text[2] = "world";     root.string=text; </cfscript><cfinvoke method="Hello"  webservi

I have the JRUN4 installation with IIS as web server. I want to apply the 'secure', 'httponly' flags to cookies for the applications which are running in the environment. we can have the secure and httponly cookie configurations in jrun-web.xml, but this approach impacts all the applications that are running in that environment.By applying the secure, htttponly attributes in jrun-web.xml requires all the sites should be configured in SSL protocol. In order to overcome this I have implemented a servlet filter ( using java servlet api), which sets the secure and httponly attributes to cookies. The filter implementation code we have a method response.getHeaders(). This method is not available in the servlet API version (2.3) that comes with JRUN4 and coldfusion. Due to this i am getting the below error after configuring this filter in web.xml.I replaced the servet api jar file (servlet-api-2.5-6.0.0rc0) under the <JRun4-home>\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\l

We are installing CF10 Enterprise on Windows 2008 RC2 with IIS 7.   We installed using all default selections, straight-forward installation, and applied the mandatory update.  So far, so good.When we go to the updates page for automatic updates for the latest current hotfix 7 (at the time of this post), which is cumulative, the install and download process runs fine, the instance restarts, but then when we check again to see the available updates, it shows all the updates from 1 to 7 again, as if we didn't apply the updates at all.  Installed updates tab shows no updates having been applied.  However, looking at the system info page, the udpate level shows HF7.We tried a variation, applying one hotfix at a time.  This worked through hot fix 2, but after applying HF 4, it 'froze' there with the same problem as described above, not showing any fixes having been applied after HF 2. This is incredibly frustrating.  I have no idea if HF's have been applie

Hi,I'm trying to create a report in coldfusion report builder that takes 2 parameters; startdate and enddate. These two parameters correspond to two fields in my sql database. However, both the fields are of type datetime and I can't work out how to insert them into my report? If I change the type in the report to string I get an error message so it's not that. Had a look on the internet but haven't been able to find any answers.I'm using coldfusion mx7Does anybody have an idea?ThanksStevie

Hi,        We have a scheduler file with .cfa extension  in the cf scheduler  which trigger some mails to certain recipients on execution.At the bottom option fo the scheduled task, we have checked the option to 'save output to file' and has given the filepath. On direct execution of the given url, the  file is executed successfully and mails are fired.But while trying to execute the same via scheduler it is not firing the mails. On investigation of the output file,found the error message 'File not found'. Is it possible that the file get  executed when directly browsing the url and shows 'file not found' errorwhile executing via cf scheduler?(CF 8 is used.)

I have a sidebar item on the front page of my website that pulls a "featured pic" out of my photo gallery and keeps it there for the day.  While it's not really important when that day starts and ends (people are of course, in all different time zones), I'd like to have the pic up for 24-hrs-ish.I started to write a complicated script to check the date and rotate the pic every day, but then I thought I might do it the "cheap" way, and just cache the query for 24 hrs.   The problem is, if I leave the page and return, I get a completely different pic.  I'm thinking that since my query is in the request scope, the caching is failing because CF sees the query name as being different.Here's my code:<cfquery name="FeaturedPic" datasource="#request.dsn#" cachedwithin="#createtimespan(0,24,0,0)#" maxrows="1">SELECT    photos.pic_id        , photos.pic_file        , albums.album_url&nb

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSc3ff6d0ea77859461172e0811cbf3638e6-7fc5.html

My administrator installed the coldfusion-security-hotfix-apsb13-03 and now I am getting 500 server errors when trying to submit forms. Added the var postparametersLimit because we have some large forms but I am still getting the error. Running cf 9.0.1.

I have a page where the day and date is displayed like this.    < Previous Day      -  Wednesday January  23, 2013   >    Next Day How do I make it so when the userclicks on < Previous Day    link that they go to Tuesday January  22, 2013 and when they lick on > Next Day they go to Thursday January  24, 2013  etc?