ColdFusion

Hi. Does anyone know how to use javascript? I have a numeric field in my SQL table called Eng_Hrs. All I want to do is to make sure a number goes into this field instead of some text. It can have up to 2 decimal points. I've tried adding validate="float"  and adding validate="numeric", but that doesn't seem to work. I would rather do javascript anyway if I could since it would pop up a window that tells the user to enter a valid number into this field, and the form would not submit until this was entered correctly. I do have some javascript I used on a currency field somewhere else, but this field is just a number and can have 2 decimal points. I'm just not sure what I'm missing and why it's not working. Here's the javascript I have: <SCRIPT LANGUAGE="JavaScript"><!-- Original:  Wayne Nolting (w.nolting@home.com) --><!-- This script and many more are available free online at --><!-- Beginfunction verify() {var PartNum=document.AddECNumber.Part_Number.valu

Hey Guys,Have anyone integrated CF application with Telerik RadGrid (aks ASP.NET AJAX Grid) on the server side?Cheers.Boris Petukhov

I first started using CF 11 with version 11.0.0 and it worked like a charm.   Once the server was up the datasources (pointing to an Oracle DB using Macromedia/JDBC driver) worked fine.    But then I updated to the 11.0.3 version which 'fixed' the dbVarName on the cfprocparam tag.   Ever since that update my three servers are having a tough time keeping these datasources active.   It appear that they go inactive when the server is not busy like over the weekend or in the early morning hours when usage is down.    And when they are accessed after that point requests will time out when trying to establish a connection for several minutes until things get going again.  From that point on they work great.    Very odd...   To get around this issue I created a small page that runs a simple query against each of my three datasources that are used heavily.  I am running this page continuously with a

Like many people I'm sure, I use both Dreamweaver and CF Builder.  I know this is going to sound pretty lame, but when I switch from one to the other, it takes me a while to get my bearings straight because the syntax coloring is different.  I know you can change it, but with names for things like "Literal Cdata text" it's tough to figure out what controls what.I noticed you can import a color scheme, so I was wondering if anyone had a scheme that duplicated the coloring used by Dreamweaver.Thanks!

Hi, our IIS Redirects are not working with CF11.  IIS 8.5 (on Win2012) redirects work fine only if there are no ColdFusion files specified in the URL. The redirects are specified to redirect to a specific URL, to redirect to the exact destination, and to send an HTTP Response code of 301 Permanent Redirect.However, with a .cfm file on the URL, the response is "The page cannot be displayed because an internal server error has occurred." The HTTP Response Code is 500 Internal Server Error. The web logs shows it as a 404.0 File Not Found error.If we add the 'missing' .cfm file, the .cfm file gets processed ... thus, there is no redirect. It seems that the Connector is taking over before IIS can respond and process the Redirect. Any ideas?thanks,Chris

Hello, all,I'm trying to open PDF files from a URL link - open in READER, not the browser - and have Reader highlight keyword searches, and set the zoom to 100.The PDFs are in many folders, but I'm currently using CFFILE to do a 'readBinary' of the PDF, then use CFHEADER and CFCONTENT to give the user the option to open in Reader. <cffile action="readBinary" file=" { filename is in a url parameter } " variable="variables.thisPDF" /> <cfheader name="content-disposition" value="attachment; filename=fakePDFname.pdf##search=#url.parameter#&zoom=100" /> <cfcontent type="application/pdf" variable="#variables.thisPDF#" reset="yes" /> The parameters appear as part of the filename, not as parameters, and I get an error message that there are no programs on my computer that will open "fakePDFname_pdf_search=hazmat&zoom=100".How can I get keywords to be highlighted within the PDF?Much appreciated,^_^

We're looking to deploy a server on AWS / Coldfusion 11 Enterprise ( LINUX ) and I'd really appreciate some advice from someone who knows this area.About the server:Only handles coldfusion CFCs  NO DATABASE ( this will be on another Amazon RDS server )Mainly handles Flash-remoting requests from AIR Apps - typically it receives request, hits database, returns datalow bandwidth - the site only hosts one swf and some cfcsThere are 3 options in our budget:M3 LARGE  C3 LARGER3 LARGE

When I try to download CF11DE on the Adobe site, that Akamai download manager thing stalls and says Access denied (Windows, on Chrome and Firefox), so despite trying over the last couple days and I still can't download it.  Is there any way to get a direct link rather than having to use the silly, unnecessarily complicated way?

Hello all,I'm new to VB .Net as well as coldfusion flatforms.I've got an issue while running vb .net dlls from coldfusion ui side.I'm trying to call vb .net dlls from coldfusion ui. i'm able to create cfobject. but functions having reference type parameters are unable to dump or unable to call from coldfusion.  Public Function InitDB(ByRef ConnectionType As String, ByRef In_Ansrefid As Integer, ByRef TestFlag As Boolean) As Short functions having ByRef are not identifing by coldfusionCould please suggest me why reference type parameter functions are not identifying by coldfusion?if possible could please suggest me any documentation which describes how to call vb .net dlls from coldfusion ui part.

HiWe are trying to work with a 3rd party server product that has a REST API so we are using cfhttp to interact with it.  We want to implement two-way SSL for the calls so that it is only our app that is able to make calls to the REST API.  So we put a password protected .p12 cert into C:\ColdFusion9\runtime\jre\lib\security and from the same location import the p12 into the keystore via the command:..\..\bin\keytool -importkeystore -srckeystore CAAT_Client.p12 -destkeystore cacerts.jks -srcstoretype pkcs12 -deststoretype JKS -alias contentanlystclient -destalias CAAT_ClientP12 -deststorepass changeit -destkeypass changeitThe process asks for the password for the cert and then seems to import it.  I say seems because it is not in the list when I do:..\..\bin\keytool -storepass changeit -list -keystore cacertsHowever, if I try to reimport the cert it says: Existing entry alias contentanlystclient exists, overwrite? [no]: It seems that maybe the -list command only lists .ce

Hi,I am just starting our with Coldfusion Builder and I am baffled by an error I can't seem to resolve.Using localhost and coldfusion Builder default root: C:\Users\hp\ColdFusion Builder 3 workspace\MISTweb, whenI attempt

I have to create several reports who's data will be displayed like this:TYPE# COMPLETEDTURN TIMEMulti-Family (MF)Multi – Family FHASingle Family (SF)Single Family FHACondoLandTotal/Average:Total: Average:It seems I would need to query separately for each "TYPE"? Everything I tried outputs Cartesian products -The action page from the date search (BUSINESS DAYS ELAPSED) form:<cfset Session.StartDate = "#CreateODBCDate(FORM.StartDate)#"><cfset Session.EndDate = "#CreateODBCDate(FORM.EndDate)#"><cfscript>function businessDaysBetween(date1,date2) { var numberOfDays = 0;while (date1 LT date2) {date1 = dateAdd("d",1,date1); if(dayOfWeek(date1) GTE 2 AND dayOfWeek(date1) LTE 6) numberOfDays = incrementValue(numberOfDays); }return numberOfDays;}</cfscript>HOME SALES (order_type_ID = 1):<cfquery name="client_report_sales" datasource="#Request.BaseDSN#">SELECT order_ID, order_property_type_ID, order_order_type_ID, order_status_ID, order_create_date, order_inspection

Hi,I am in the process of converting the pages from a cflayout (tab format) into individual pages because the the pages in the tab format work with some users IE 8, 9 and 11 browsers and does not work with other users IE 8, 9, 11 browsers.In the tab format, when the Update Calculation link is selected, the page would take the values entered in the Number of One Way Trip/Day and Day/Year and calculate the value for the Total calculated units box. (Per the image)When creating the individual page, is there a way to have the page refresh, keeping the value entered in the Number of One Way Trip/Day and Day/Year, when the link is selected to have the calculated value placed in the Total calculated units box?Thanks,Mike

Hello all,I'm new to VB .Net as well as coldfusion flatforms.I've got an issue while running vb .net dlls from coldfusion ui side.I'm trying to call vb .net dlls from coldfusion ui. i'm able to create cfobject. but functions having reference type parameters are unable to dump or unable to call from coldfusion.  Public Function InitDB(ByRef ConnectionType As String, ByRef In_Ansrefid As Integer, ByRef TestFlag As Boolean) As Short functions having ByRef are not identifing by coldfusionCould please suggest me why reference type parameter functions are not identifying by coldfusion?if possible could please suggest me any documentation which describes how to call vb .net dlls from coldfusion ui part.

I am running CF 8, J2EE and need to modify the JVM settings. After doing some research, it seems like you can do this through CF Admin if you are NOT using J2EE - otherwise it's a lot more complicated. Can anyone confirm if that's the case (I don't see any JVM options in our CF Admin instance right now), and if so, what the best way to go about making changes would be? Thank you!

I have installed installed CF10 on Windows2012R2 under a trial license and now wish to apply the license code I have been supplied with. When applied it errors with "the serial number you have applied is invalid". The text with the license says this applies to CF11 but I was told that this will still work for CF10. What is the workaround for this?

I'm working with a database that stores links to various pieces of government regulation.  Each regulation has a discipline, subdiscipline, regulation type, and responsible office.  Each one also has a list of assigned keywords.Previously, we were just using an HTML form to do a <cfquery> to search these items.  At one point, someone tied our Google appliance into the keyword search to improve results, but now we're dumping the appliance due to cost issues.  I've been asked to come up with a replacement for the appliance, so my first thought was Solr.I've created a collection, then used cfindex to index it.  If I use cfsearch to pull keyword results, it works quite well.  Here's my cfindex tag:<cfindex     collection="docsearch"     action="update"     type="custom"     category="category_name"     body="keyword"    custom1="discipline"    cust

CF11, getting every 5 min message: [ajp-bio-8014-exec-423] - An error occurred while fetching element from authcache in the coldfusion-out.logWhat is the reason of the message?

Hi we are in the process of migrating from CF6.1 + oracle 8i to coldfusion 8 + oracle 10g and I keep having this error in the log files:"Element NATIVEERRORCODE is undefined in CFCATCH." I think the error is happening somewhere in this codes: <cfcatch type="any"> <cfset ok = false> <cfif request.debug> <cfoutput> #cfcatch.message#<br><br>#cfcatch.detail# </cfoutput> </cfif> <cfset validPageRequest = true> <cfinclude template="../../o_generic/cfm/cf_log_err.cfm"> </cfcatch> Any ideas?? Thanks in advance

I have a form that collects the personal info then it loops through items so the user can add a row of addition items. ​Upon submitting my form,the personal data is inserted into a mySQL table, it then inserts the items into the items table by a cfloop. It works great but my clients now wants me to incorporate a popup window upon submitting the form. The popup will ask if they "Are sure your order is complete." If yes, then the form is submitted. How can I get the popup window to send the data to the appropriate tables?Below is the cfloop I am using:<cfloop from="1" to="#getnumba#" index="idx">            <!--- At first, it displays the original one row form --->            <!--- User enters the data and hits "Add Another" --->            <!--- The page reloads with the data already entered and creates

Hi All,How can I define a function that call a Oracle sp but right away return something?The sp is a long process, I can check if the process finish later with another function.<cffunction name="callFunctionCC" access="remote" output="false" returnformat="any">     <cfargument name="myID" type="numeric" required="true">     <cfset var myResult = "The process start" />     <cfset var qryData = "" />     <cfstoredproc procedure="TT.CALCS.getLongProcess" datasource="#application.str_dsn#">         <cfprocparam value="#arguments.myID#" cfsqltype="cf_SQL_NUMERIC">         <cfprocresult name="qryData">     </cfstoredproc>     <cfreturn myResult/></cffunction>Thanks,

I am attempting to implement a REST endpoint that accepts a multi-part form request that includes form data as well as a file upload. Is that even possible? Is it possible to just accept a file upload and nothing else (e.g. specify a unique ID in the URL and POST/PUT data in the request body)? I've tried numerous things and have been unable to successfully implement a REST endpoint that accepts a file upload...Specify a CFARGUMENT type="binary" to the CFFUNCTION that is the REST endpoint definition. This results in a CF REST API compile error.Submit a multipart/form-data POST/PUT request and use CFFILE to handle the file upload in the body of the CFFUNCTION. This causes the CF REST framework to not see any of the form-field parameters that are required by CFARGUMENT tags.Uploading the file to a separate endpoint that expects only the file and setting the HTTP content-type header to the file's MIME type. The CF REST framework rejects this because it wants a specific content-type (presum

I'm consulting for a company, and their server is being used by intruders to send spam email. It is Windows 2008 x64 with IIS, CF9, and SQL Server. The CF server is running their home grown web site, and my suspicion is that there is an unsecured .cfm file that allows all cfmail parameters to be provided via form variables, or else the intruders got their own .cfm file somewhere that's doing it. The files showing up in spool and undelivr all appear to be formatted in such a way that they look just like legitimate emails I compared, so that's another reason I think it's a rogue .cfm file. I have mail logged turned all the way up to debug, but it still doesn't show where the email "came from". I found other evidence of exploit severe enough that I have informed the customer that their server needs to be completely flattened and reinstalled before it cant be trusted again. I'm going on site in 3 weeks to do this rebuilt, but in the meantime, I am continuing to see evidence that spam email

Hello,I tried to add this as a bug to the Coldfusion Bug tracker (https://bugbase.adobe.com/) but ironically, I get a default Coldfusion error page when I log in.I believe there is a serious bug with the for-in construct when used in a particular fashion. In particular, if the "in" expression is a function call, it appears that the function is invoked multiple times (to be precise, it always appears to be 5 times).Clearly there are many situations where this could have serious consequences, not least if the function does any serious work.Key points:Tested on Coldfusion 10 update 16Using a for-in construct where the "in" expression invokes a function results in that function being invoked multiple times.It doesn't seem to matter what the function returns (e.g. struct, array, potentially other iterables)Workaround:Assign the result of the function call to a local variable outside the for-in constructSeverity:This a serious issue as,It is easy to cause using a common idiomIt is completed

I'm trying to create a check to distinguish between someone requesting the default page vs. explicitly requesting the default page. I'm running CF11 under IIS. My site has a default document of index.cfm. I need to determine if the user requested http://my.domain.com/ vs. http://my.domain.com/index.cfmI cannot find any difference in the CGI scope between the two calls and I've also looked at the contents of getHttpRequestData() to no avail.