Questions

HiWe've just upgraded to CF11 update 3 on a 64bit Windows 2008 Server from CF10 and have found that my previous code to clear cached database queries no longer works as instantly or reliably as it did previously.I'm currently using the following code in my application.cfc file. This code would run if I were to hit the following page on the website... index.cfm?reinit=yes<cffunction name="onRequestStart" hint=""><cfif structKeyExists(URL, "reinit")><cfset cacheRemoveAll()> <!--- Added 7th Jan 2015 without improvement---><cfset onApplicationStart()><cfobjectcache action="clear"></cfif></cffunction>Here's an example of a query I'm trying to clear the cache of<cfquery name="rs_Issue" datasource="#APPLICATION.dsource1#" cachedwithin="#CreateTimeSpan(0,1,0,0)#">SELECT Issue_ID, Issue_NameFROM IssueWHERE Issue_Status = <cfqueryparam cfsqltype="cf_sql_varchar" value="Current"></cfquery>Has anyone got any suggestions of what I'm

Hi friends,I am working on coldfusion 10 and i have the following requirement,How I need to display 100 records in first page with 18 records visible and remaining 82 records visible  should be through scroll bar.Your help is greatly appreciated.Thank you in advance.

I have a form field I want to control what a user can enter.  It's for a blood product unit number.The format will always be:W1202 follow by the last 2 digits of the year 14 followed by 6 numbers 123456Final entry W120214000001.That is what the unit number will look like - eye readable.  The issue I have is that there is also a barcode and it's obviously easier for staff to enter it accurately if the scan it.The barcode has start (=) and stop (00) characters, so in this example it would look like =W12021400000100.Is there a way to detect if the first character is an = and strip it, preferably on the form?  Then, if it is over 13 character and the last 2 character are 00, strip those as well?  And while we are at it, make sure the unit number is a total of 13 consecutive characters?  Your guidance is greatly appreciated.

Hi All,I am creating the captcha using cfimage. In my project we have three different environment dev, stage , production. However I am getting the the captcha image for production and dev but in stagging I am not getting the captcha image. When I am checking captcha in firebug I am getting the image "src" attribute as, "/CFFileServlet/_cf_captcha/_captcha_img2787831475697289656.png" for all three environments but the image not displaying only for stage.Please help me.ThanksSaurav

I'm hoping to use cfpdf to add a certifying signature to a pdf.  There's no obvious way to indicate you want a certifying signature (as opposed to an approval signature), and no obvious way to indicate permitted actions after certifying.  Is this functionality just not there?Bob

In CF11, Update 1, & Update 2 in the CF11\config\wsconfig\#\ folder there was a file called iprestriction.properties that contained the following;*/CFIDE/main/ide.cfm=**/CFIDE/adminapi/*=**/CFIDE/administrator/*=**/CFIDE/componentutils/*=**/CFIDE/wizards/*=**/CFIDE/ServerManager/*=*After updating to CF11 Update 3 and then rebuilding one of the connectors that file has been removed along with the reference to it in the isapi_redirect.properties file.Was this done on purpose or was this a regression because it looks to contain security related settings?

Does anyone know what to do to fix a non-working <cflocation> tag?Upgrading web site from WS2003 ColdFusion 8 to WS2008/64bit ColdFusion 10. Upgrading CF application has required a number of CF code  and database tweaks. Application is processing normally with the following exceptionWorking on site upgrade few days ago, one <cflocation> tag in web application stopped transferring to its target page.  I've placed <p> debug statements before and after the <cflocation> tag in question; and <p> debug statement at the start of the target page.  the <p> before <cflocation> displays.  But then the page ends without transferring.  No error is indicated by either CF, CF logs, or the web server. Could this be an server application pool problem?  IIS is using DefaultAppPool application pool. I've verified Cookie session is maintained.  Also adding CF10's SessionRotate() to application home page, made no change to <cfl

I was wondering if for each file the cfindex is indexing, if I could get the last modified date of the document and insert into my custom field called "sort_date_s". I notice in the cfdump that the author and title field is extracted automatically but can I get it to extract anything else.<CFINDEXCOLLECTION="mycollection"ACTION="UPDATE" URLPATH="htttp://mywebsite.com/myfolder"TYPE="path"KEY="D:\Websites\mywebsites\myfolder"EXTENSIONS=".doc, .docx, .xls, .xlsx, .pdf, .pptx, .ppt"RECURSE="Yes"searchtype_t="docs"language="english" sort_date_s ="last modified date here">My goal is display search results from 2 collections ( a database one, and the file location one (above)) and display to the users the most current information first so that is why my files need to have some sort of date. If there is a better way, I am open to suggestions.

cflayout type="tab" name="mainTab" ><cfloop query="qgetdcfg">    <!--- Each layoutarea is one tab. --->    <cflayoutarea title="#qgetdcfg.dsource#-#qgetdcfg.djobnamespec#"       name="#qgetdcfg.dsource#-#qgetdcfg.djobnamespec#"   selected = "true"   >    <h2>Tab name</h2>    <p>  <cfset datasource = "#qgetdcfg.dsource#">  <cfset duser = "#qgetdcfg.duser#">  <cfset dpassword = "#qgetdcfg.dpassword#">  <cfset djobnamespec = "#qgetdcfg.djobnamespec#">  <cfinclude template=all_js.cfm>    </p>    </cflayoutarea></cfloop></cflayout>The above almost works. The all_js.cfm has only two parts to it, it formats a pie chart and then displays a few rows of data based on the datasource, user and password and djobnamespec variables.The two tab sho

Is there a way to display the value of cfqueryparam upon a database error?  For example:<cfquery name="causeError" datasource="#application.dsn#">      select street1 from house, #table2# where house.houseid = #table2#.houseid and house.houseid = #form.houseid#</cfquery>The variable table2 is dynamically generated and let's say an error is caused table2 being an empty string or a table that doesn't exist.  So the error given is:[Macromedia][Oracle JDBC Driver][Oracle]ORA-00903: invalid table name4 : <cfquery name="causeError" datasource="#application.dsn#">5 : select street1 from house, #table2# where house.houseid = #table2#.houseid and house.houseid = #form.houseid#6 : </cfquery>SQL   select street1 from house, where houseid = 123;So I know that the user was trying to look at a house with houseid = 123.  I can then try to replicate the error using the same record in the database which can ultimately can help me

Hi,I am using Cold Fusion 11.When I browse to obtain the file to upload, the location and file in the text box is: S:\App\test.xml<cfform action="fileaction.cfm" enctype="multipart/form-data" method="post">  <P>Enter the complete path and filename of the file to upload:</P>   <CFINPUT type="file" name="FileUp" size="90">  <P><input type="Submit" value="Upload"></P> </CFform>But when the above code execute, the following location appears in the variable:D:\ColdFusion11\cfusion\runtime\work\Catalina\localhost\tmp\neotmp803964384012527716.tmpWhen I  remove the enctype="multipart/form-data" from the code, the file is found, but the error message in the Cold Fusion admistration is:Invalid content type: application/x-www-form-urlencoded.The files upload action requires forms to use enctype=""multipart/form-data"".Is there something in the Cold Fusion 11 administration or configuration files that needs to be changed?This

Hi All,I have used Cybersource's Hosted Order Page for the past 8 years, but they are eliminating that option and are offering Secure-Acceptance in it's place. The only trouble is, Cybersource offers no ColdFusion support or API.  I have pulled apart their PHP example and thought I'd share what I have working so far. You should follow the steps in http://www.cybersource.com/resources/collateral/pdf/Secure_Acceptance_WM_Quick_Start_Guide.pdf  to get the AccessKey, ProfileID, and SecretKey you'll need for this example. Here are the two pages I created "payment_form.cfm" and "payment_confirmation.cfm". You can get the payment.css, payment_form.js and jquery.js from the PHP download link in the PDF I mentioned.  I'll post more, as I get father along...Have a good one,- Shawn=================================================payment_form.cfm=================================================<html><head>    <title>Secure Acceptance - Payment Form E

I have an application that trades virtual items and have a single page which gets all my accounts and for each one creates a thread that firstly logs the account in and then searches and buys for items for as long as the session is active.  I should point out at this point that this is my first experience of using cfthread.I'm having issues with it. Every 30 minutes (if not less) my ColdFusion server comes to a standstill and I have to restart the service. Upon restarting the service I check the logs and there are errors that say "GC Overhead Limit Exceeded".I have looked extensively online but as much as cfthread is new to me, so is the JVM and how it operates. I'm running on CF10 Enterprise Edition and have loaded up the server monitor and surely enough I can see the JVM memory usage grow and grow until the limit has been reached (just now I have it set as 2gb as when I had it set higher the memory seemed to fill up quicker). Even when I select the Run GC option in the monitor i

Need help installing cf server 4.5 on windows 2008.  The client needs acces to an old app.  They have a license for 4.5 and they don't want to up grade.  I told them I would try but in the end may need to upgrade.  I've tried to register the iscf.dll however iis 7 says its not a dll

I'm trying to connect to MySQL Community Server version 5.6 from Cold Fusion 11. If I choose the DataDirect driver, I get an error message stating that the driver does not support Community Server. So I choose the MySQL5 driver and I am able to verify the connection from the CF Admin page. However, whenever I try to run any queries using the verified datasource, I get a "500 - internal server error".Is there an updated driver I can use? Does that driver support Community Server?

When we trying extract the content from PDF containing images getting strange error in the CF11 for cfpdf tag. But its working fine for PDF with out images (i.e. plain PDF with only content) But both are working good in CF9. Sample Code : <cftry>     <cfpdf action = "extracttext" source = "sample.pdf" destination="sample.doc" overwrite="yes">     <cfdocument              format="pdf"  srcfile="sample.doc" filename="sample1.pdf" overwrite="yes">      </cfdocument>     <cfcatch type="any">            <cfoutput>Error Occured : #cfcatch#</cfoutput>     </cfcatch> </cftry>Sample code is working fine in ColdFusion 9 for PDF containing images and with out images. But below error occurred when we try to extract th

Finished installing CF 11 Developer Edition and cannot connect to CF administrator and preinstalled Apache web server. I get this message:Firefox can't establish a connection to the server at 127.0.0.1Tried these URLs:http://127.0.0.1/CFIDE/administrator/index.cfmhttp://localhost/CFIDE/administrator/index.cfmhttp://localhost:8500/CFIDE/administrator/index.cfmAm able to get a web page that says "It works" when I try to access http://localhostDoes anybody have any advice?Rob

Hi all,I have a Coldfusion 10 standard Edition installation with MSSQL 2005 on Windows Server 2008 R2 server about 2 week old.It is one of my live server and it is dealing with medium to high volume of traffic.Since deploying this server, it has been getting random HTTP 503 internal server errors, which require the entire server restart (as coldfusion application server, IIS restart will not able to resolve the problem). Within this two weeks, sometimes it can last for couple of days without problem, and sometimes it require 4-5 times server restart within one day.I can't replicate the error on demand, but I could paste one of the windows server event log here:          Faulting application name: w3wp.exe, version: 7.5.7601.17514, time stamp: 0x4ce7afa2          Faulting module name: isapi_redirect.dll, version: 1.2.32.0, time stamp: 0x4f745a78         &nbsp

Well i know there are similar thread's opened in past but i felt they are pretty old to be opened again.Guys feel free to inbox me in case you have some inputs, i would appreciate it.Thanks in Advance

Hi,My brain is frozen or something because I couldn't think out this issue.  Basically my form input radio name and value are dynamically pulled from a database.  The name of the form is concat with a name and id is from a database.  On the form processing side, how would I get all the dynamic input radio name.  The value of the input will be attach to the name.  Hope that make sense.  form.cfm<cfquery name="get_form_name" datasource="#ds#">     SELECT id, name     FROM records</cfquery><cfoutput><form action="form_process.cfm"><cfloop query="get_form_name"><p>name: <input type="radio" name="test_#get_form_name.id#" value="#get_form_name.name#" /></p></cfloop><input type="submit" value="submit"></form></cfoutput>form_process.cfmsomehow get all the input name from the FORM to set cfparam and value.  Once I have this, i have the form values th

I need a little help, what have I done wrong or not done?Here is the error message that is returned;Connection verification failed for data source: Archuleta_xxxxxx java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connectionany ideas would be appreciated.

I am using CF9 and here is what I get using CFHTTP to Twilio:structCharset[empty string]ErrorDetailI/O Exception: peer not authenticatedFilecontentConnection FailureHeader[empty string]MimetypeUnable to determine MIME type of file.Responseheaderstruct [empty]StatuscodeConnection Failure. Status code unavailable.TextYESSo I went and imported the the certificate into the cacert keystore. Here it is listed:I have restarted the Application Server service and still get the same error. Problem just started in the last week or so and I imported the cert this morning.Am I missing something?

sI have one search result that looks like this:Outlook Out of Office AssistantJul, 28, 2014 - To activate the Out of Office Assistant: On the Tools menu click Out of Office Assistant. In the Out of Office Assistant dialog box select the Send Out of Office auto-replies radio button. If you want to specify a set time and date range select the Only send during this time range check box. Then set the Start time and then set the...When I do this search, I get 10 results back including the one above.<cfsearchname="qTechTips"collection="#collection#"criteria='secondary_id_i:24 out of office'orderby="sort_date_s desc"/>But when I do a phrase search for "Out of Office":<cfsearchname="qTechTips"collection="#collection#"criteria='secondary_id_i:24 "out of office"'orderby="sort_date_s desc"/>or<cfsearchname="qTechTips"collection="#collection#"criteria='secondary_id_i:24 "Out of Office"'orderby="sort_date_s desc"/>I get 0 results. What am I doing wrong? I would like to do a phrase

Help with the new text editor.

Hello!We updated our CF10 installation to Update 15 and now our cfftp tags are throwing this error. I made a one line file with the code below to reproduce the error. Is there a problem with the code, our installation, or is this a bug that should be reported? Thanks for your help.ChrisThe code:<cfftp action="open" connection="My_query" server="xxx" username="xxx" password="xxx" stopOnError = "No">The error:The tag handler ftp does not have a setter for the attribute parserKey specified in the Tag Library Descriptor. The stack trace:coldfusion.jsp.JRunTagLibraryInfo$NoSuchAttributeException: The tag handler ftp does not have a setter for the attribute parserKey specified in the Tag Library Descriptor.    at coldfusion.jsp.JRunTagLibraryInfo.getPropertyType(JRunTagLibraryInfo.java:627)    at coldfusion.jsp.JRunTagLibraryInfo.buildTagInfo(JRunTagLibraryInfo.java:585)    at coldfusion.jsp.JRunTagLibraryInfo.getTag(JRunTagLibraryInfo.java: