ColdFusion

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?

I have this form with 2 images as submit buttons <INPUT TYPE="image" SRC="assets/images/lgstart_b.png" ALT="Submit Form" name="time_in"><INPUT TYPE="image" SRC="assets/images/lgstop_bo.png"   ALT="Submit Form" name="time_out">The problem is I can tget the next page to acknowldge either button. I am using CF9Here is the form2.cfm page <cfif IsDefined("FORM.time_in.X")>TIME IN<cfelseif IsDefined("FORM.time_out.X")>TIME OUT<cfelse >Nothing</cfif> I get an 'undefined' message onlyI know I have done this before what am I missing?Here is the form with the  2 images as submit buttons <form action="form2.cfm" method="post">           <table cellpadding="0" cellspacing="5">            <tr>                        &nb

Hello, everyone.I've got an intermittent CFMAIL issue that has me perplexed.I'm using CFMAIL to email notifications of changes made to records in a database.  In the form that is used to make these changes there is a field that has email addresses of developers who need to be notified of these changes.  These are a comma-delimited list of email addresses (which, according to CF9 cfmail documentation on adobe.com, is the correct way of sending to more than one address.)Some of the records will send the email, update the timestamp on the "mailsent.log", append the new email notification to "mailsent.log", and the email is received by the person(s) to whom it was sent.Other records, however, will (apparently) send the email, will NOT update the timestamp on "mailsent.log", but WILL append a successfully sent entry to "mailsent.log" (even though the timestamp was not updated), and the email is NOT received by the person(s) to whom it was sent.  In these cases, the timestamp

There was an upgrade from CF 9.0.0 to CF 9.0.1 done. When looking at cfdump, it still says 9.0.0.251028. Does that mean the upgrade didn't work ?If so, could this explain why hotfix 2 won't work-CF administrator won't run.

Running CFMX7 on an Ubuntu10.04 box - been good for a few years. However, I'm now having trouble connecting to an external MySQL 5.5 server.Not sure what bits that CF is actually using. I was using mysql-connector-java-3.1.14-bin.jar and when I try to add the datasource in CFIDE ADministrator, I get:Connection verification failed for data source: psdb java.sql.SQLException: Access denied for user 'web120-paysys'@'xx-xx-xx-xx.dsl.in-addr.zen.co.uk' (using password: YES) The root cause was that: java.sql.SQLException: Access denied for user 'web120-paysys'@'xx-xx-xx-xx.dsl.in-addr.zen.co.uk' (using password: YES)I tried updating the connector to , but that just changes the error message to this:Connection verification failed for data source: psdb  com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. The root cause was that: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnect

I have used CFCACHE in prior versions of CF and the cached page would be kept in the directory I specified.Now when I use the tag in CF9 the page appears to be cached but I can find any cached pages in the directory I specified????Here is my code:<cfcache timespan="#CreateTimespan(10, 0, 0, 0)#" directory="C:/inetpub/websites/ssl/dev/page_cache/" stripWhiteSpace="true" usequerystring="true"      >The page appears to be cached as it loads quickly but I cant find where CF puts the cached version.This is a problem because when I need to flush the cache I dont know which directory to flush.Any idea where my cached pages are?

So I got CF10 installed on my server next to xampp, when I launch the installer and get to this screen:http://puu.sh/1uAB4Then when I click "ADD" and go to xampp conf folder etc. I get this message:http://puu.sh/1uADvAnd then click OK, I get the next error message:http://puu.sh/1uAEIIs there any way to resolve this problem, or maybe the download link to Coldfusion 8? Kind regards, Lennert

I have found my needs go beyond what was released with the CF9 hotfix and most code examples are about 3 years old. I have the following necesseary tasks1.) List contents in a bucket "folder style". CF's directoryList() seems get all objects with a prefix and does not support the deliminiter required to not return object in a "sub-directory"2.) Generate and upload form for clients3.) Generate and expirable link for private objectsCan someone point me to some code that might help accomplish all three. I'm also looking at AWS's Java library, but it looks daunting.

When browsing to:www.calumetphoto.comI get the following error:Could not find the ColdFusion Component or Interface iCongoFramework.com.iCongo.common.hackerSafe.from a;ll browsers on my laptop.It looks as though the error applies on to this systemAny ideas?David

Hello, everyone.I'm using CFMAIL to send a text-format email whenever a database record is inserted or updated.  Works great, I just have one question.Since the information contained is dynamically generated, how can I indent a block of text?  Can't use <blockquote>, that just appears in the email as "<blockquote> text </blockquote>"; it's displayed, not parsed.Is there a way to indent a block of text if the email generated is text instead of HTML?Thanks,^_^

I've got a cfdiv and binding it to a checkbox. When the checkbox is checked, it shows the value of the checkbox in the div as expected. How can I get rid of that value if/when the checkbox is unchecked?