ColdFusion

Hi,I installed Hotfix 005  to my CF11 Installation .After that I get the error:Element STATUSCODE is undefined in CFSTOREDPROCwhen executing stored proceduresExample:<cfstoredproc procedure="is_authorized" datasource="test" returncode="YES">    <cfprocparam type="in" cfsqltype="cf_sql_varchar"  value="#username#" >    <cfprocparam type="in" cfsqltype="cf_sql_varchar"  value="CUST_W" ></cfstoredproc><cfoutput>#cfstoredproc.StatusCode#</cfoutput>In the earlier Release everything was okay.Any ideas?Thanks Claudia

I have a dynamic site.When I insert an integer (a whole number) in a raw materials purchase table, I get the following message:Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot insert explicit value for identity column in table 'tblRawMatlPurch' when IDENTITY_INSERT is set to OFF.            When I change to or insert a numeric, decimal, or money value, I get the following message:Raw Materials DecisionCompany:  GrandeYou have NOT successfully submitted the Raw Materials Decision formPlease note that the purchase amount must be a whole number, please do not enter a decimal for this number.Return to correctI have two programs: one is in the secure section, and the name is secure/raw_materials_decision_action, indicating that the raw material purchase variable (rawMat) is a money variable. Giving this information I set it in SQL as a money variable. Here is the file: <!---  get Company

While testing clustering, I realized that each ColdFusion instance will write CFIMAGE temporary files to its own ./tmpCache/\CFFileServlet path. The issue is that CFFILESERVLET gets a mapping (alias, virtual directory) in the webserver to one folder. If I have two ColdFusion instances setup on a cluster, within the same server, the image is generated and stored in one of the two instance installation folders. There is a 50/50 chance that the file is stored in the folder that isn't mapped in the web server configuration.Is there a "proper" way to handle this, when using two ColdFusion instances installed on the same physical server?

We are running Coldfusion in production and I am setting up a developer edition for local development.  When I enter http://someServer.com/ml.cfm?aID=378 it works just fine.  When authenticate and start passing session CFID & CFToken (http://someServer.com/ml.cfm?aID=378&CFID=12345&CFTOKEN=54321), I receive the 403 error page.  Is there something in Coldfusion that is throwing the error?

Would like the know if anybody has done authentication with ADFS 2.0. Need pointers on how to go about.Basically, when user arrives to my site, if the token is not present, direct him/her to ADFS login page and get the SAML token, then decipher the SAML token to extract the username.

Hello,I am using jQuery AJAX to call a function from a .cfc page. As of now, I am just using console.log(result) to see what response I get. And what I got is the content of the coldfusion component page. And if I type the url on the browser I get the same...This is my code to make the call using AJAXindex.cfmjQuery.ajax({    url: 'sch_acc_maint_func.cfc',    type: 'POST',    data: {method: 'student_info', accnumber: accnumber, dsrc: dsrc}, //variables are defined , but I have not posted the code...    success: function(student){          console.log(student);      }});The contents for sch_acc_maint_func.cfc, can be seen on the picture.I am running Coldfusion 9 on a unix server.Has anybody experienced this situation? Any advise will be really appreciated.

I have set up a purchase order system using dreamweaver and my own PC as a test server.  The system works great.  When i transfer it to the webHosing service, I get an error as indicated in the subject line of this post.  I am running CF8 on my test server and the web host is using CF9.  The server error log shows ""Error","jrpp-33671","05/04/15","06:18:52","Name","'' The specific sequence of files included or processed is: D:\home\batt26.com\wwwroot\sch\POinsert.cfm, line: 64 "  at cfPOinsert2ecfm1666762724.runPage(D:\home\batt26.com\wwwroot\sch\POinsert.cfm:64)As far as i can find from extensive googling (is that a word) it is likely a database problem.  I am using Microsoft access.  What is strange is that it runs line 64 and completes the data insert before it throws this error.Below is my code, i have underlined the line in question:<cfparam name="FORM.vend_nme" default="1"><cfparam name="FORM.job_nme" default="1"><cfparam name="FO

When searching "open documents" for some string of text why does it open a second instance of the file when selecting from the results under the search tab?

I've been on a mission to optimize things in our web template, and I've been using a lot of query caching with fantastic results.One place I think can be improved is variable assignment.  We assign several variables that use CGI.SCRIPT_NAME, and I'm not sure how resource intensive that is.  I'm wondering if I can use cfcache to server-cache these variables to keep them from having to be set on each page request, but the documentation on that tag isn't great.Does anyone here have any insight or guidance?Thanks!

Have ColdFusion 11 installed, I have created a hello web service and I am trying to call it.  Each time I try to call the web service I get an error 401 Unauthorized.  I am not sure if I need to configure something more on the ColdFusion server, IIS or something else.<cfcomponent displayname="Hello"> <cffunction name="helloWorld" returntype="string" access="remote">     <cfreturn "Hello World!">    </cffunction></cfcomponent><cfinvoke   webservice="http://MyServer/Hello.cfc?wsdl"   method="helloWorld"   returnvariable="ws" refreshwsdl="yes"></cfinvoke><cfdump var="#ws#">

I am consuming a web service in ColdFusion what was written in .NET.  Some methods of the web service work fine, but some we get the below error.  We have identified the issue is the name of one of the properties in the web service appears to be the issue.  The property name is ID.  This is a very common property name so I would think someone has run across this before.  It appears that maybe ID is a default property for Axis?  I can dump the method that works and I see there is a getID() method with a return type of org.apache.axis.types.Id.If we change the name of the property to something other than ID it works, but this will cause us to refactor a lot of code.Here is the error I get when I try to call GetRoles method, which contains an ID property:Cannot perform web service invocation GetRoles. The fault returned when invoking the web service operation is:AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode:

Every time I enter data, I get this error report:Invalid data '' for CFSQLTYPE CF_SQL_INTEGERIt might be related to this problem:<cfloop collection="#cities#" item="cityID">  products["#cityID#"] = [<cfset first = true><cfloop collection="#cities[cityID].products#" item="productID"><cfif first><cfset first = false><cfelse>,</cfif>{value:"#productID#", text:"#cities[cityID].products[productID]#"}</cfloop>];  </cfloop>There is a syntax error I cannot find in the line starting with product[Can anyone help?Thanks,

Hello Guys, i am using a cfquery and am trying to return results based on date. the idea is to return entries that are less than or equal to date but am not getting any results but when i change to greater than or equal to i get the all results in databse which is wrong. Below is my code. is there something am doing wrong? Please help.<cffunction name="getBal" access="remote"> <cfargument name="ID_biodata" type="string" required="true">        <cfargument name="quater" type="string" required="true"/>        <cfargument name="datePaid" type="date" required="true"/>                <cfquery name="qBal" datasource="bond100"> SELECT ID_biodata, quater, datePaid, amountPaid, manFees FROM collections WHERE datePaid <= <cfqueryparam cfsqltype="cf_sql_timestamp" value="#parseDateTime(arguments.datePaid)#">  

I am trying to simply open a connection output if it succeeded and close the connection. The page I have works fine in CF9 but in CF10 hitting the same server with the same credentials stalls the page out. It doesn't error out or timeout it just sits there forever loading the page and never finishes connecting.I have tried an sftp client other than coldfusion from the same server with the same credentials and it works fine. When I look at the SFTP logs it shows that coldfusion connected but it is not authenticating and completing the connection.Did something change with CFFTP in Coldfusion 10 that I missed? Any thoughts or suggestions to get this working?Here is what the page has on it.<cfftp action = "open"server = "server" stoponerror="yes"username = "user"password = "pass"connection = "sftptest"secure = "yes"> <cfoutput> Connection Open :#cfftp.succeeded# </cfoutput>         <cfftp connection = "sftptest"   

BonjourJe tente de réinstaller application manager car il semble y avoir un problème.  À chaque fois j'obtiens le message Le programme d'installation n'a pas pu s'initiliser.Peut-on faire quelqueq chose

Hi All,I use this technique for QoQ when I have a commond key: How to do an OUTER JOIN in Query of Queries | BealeARTS Now, I have data from two different table but the join is based on multiple fields as: select * from tableA, tableB where tableA.field1 = tableB.field1 and tableA.field2 = tableB.field2 and tableA.field3 = tableB.field3 How can I do the other join in this case?Thanks in advanced.

I created a login form (see below).If I use the regular HTML form and form fields for the username, password and submit button I don't get any problem viewing my formBut if I use cfform and cfinput form fields I get this error. Here is my cfform codes: cfform name="login" action="/login/checkLogin.cfm" method="post">  cfinput type="text" name="username" size="25" required="Yes" message="Please enter your username">  cfinput type="password" name="password" size="25" required="Yes" message="Please enter you password">   cfinput type="submit" value="Sign In">/cfform>When I launch this page I get this error and I don't understand what this means and what am I supposed to do, please help! Total Time Avg Time Count Template1 ms 1 ms 1 /opt/coldfusion10/cfusion/wwwroot/CFIDE/administrator/templates/secure_profile_error.cfm0 ms 0 ms 1 top level /home/space/users/www/webdocsec/login/login.cfm19 ms   STARTUP, PARSING, COMPILING, LOADING, & SHUTDOW

Hi all,Trying to configure CF10 in windows 2008 R2 server and flash remoting. I am getting this error when i am checking the gateway:https://127.0.0.1/flex2gateway/cfamfsecuremessage javax.servlet.ServletException: flex.messaging.config.ConfigurationException: Please specify a valid 'services.configuration.file' in web.xml. You specified '/WEB-INF/flex/services-config.xml'. This is not a valid file system path reachable via the app server and is also not a path to a resource in your J2EE application archive.I cannot map my cfc files correct.I check all from this link:http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WSc3ff6d0ea77859461172e0811cbec11257-7ffd.htmlAnyone have an idea about this error?Please help.Thanks in advanced.

I have two dropdowns, one for category and the other for sub category. The category dropdown is loaded automatically and the sub category dropdown should be loaded based on what is chosen on the category dropdown. All data is coming from a database table, one is category and the other one is sub category. I am using oracle database. Thanks in advanced.

HiI have a client that needs to collect data from a standard HTML form, stuff the data in a database and then query and format the data for printing.The printed result has some fairly stringent requirements which I can likely do with CSS (such as field widths, line breaks, etc.).My question is, has anyone identified a good way to do this? How does the CF world handle printing dynamic data into a pre-formatted form? Thanks in advance,Rich

Hi... can't seem to get the site wide error handler to work on my new CF11 server....I built a simple error handler cfm page and put it into my CF server root (not the site root) and created a test.cfm with an intentional CF error (a cfinclude tag that points to a missing file) that I put into my site root.In CF admin I pointed the Site wide error handler to my error handler page and clicked submit, and CF admin came back with a confirmation message saying all is well.Any Coldfusion errors are still being handled by the default template and not my custom error page. Does anyone know anything else I could try?Thanks in advance,Rich

Hello,  I am looking into a concurrent requests issue that has just recently come to my attention with ColdFusion 9. It appears that ColdFusion can only process 12 requests at the same time using windows launched from one browser (IE 11) from one client computer. I launch 30 instances of a page that writes a file then sleeps for 30 seconds. I notice that 12 files are written at once, then more come in waves after the sleeps are complete. This is with ColdFusion 9 set to run a max of 50 requests, no limits on requests for IIS, and no limits on requests for the browser. After some searching, I read that request queuing can be caused by memory management or the aforementioned setting. With this, I have a few questions:  Is this a known limitation on ColdFusion? If so:Is memory or processor power the limiter?Are there any other ColdFusion or IIS settings that be tweaked to increase the number of requests?Is there a “per client” limiter in place?Would using ColdFusion 11 remedy th

I am getting the error below when trying to create an object in CF 11 using cfscript. In the CF Admin Java VM settings are the default setting. I have placed xmlsec-1.5.8.jar file under \cfusion\lib and cfusion\wwwroot\WEB-INF\lib I have also restarted the CF service.java.lang.NoClassDefFoundError: Could not initialize class org.apache.xml.security.signature.XMLSignaturesun.misc.Unsafe.ensureClassInitialized(Native Method) at sun.reflect.UnsafeFieldAccessorFactory.newFieldAccessor(UnsafeFieldAccessorFactory.java:43) at sun.reflect.ReflectionFactory.newFieldAccessor(ReflectionFactory.java:142) at java.lang.reflect.Field.acquireFieldAccessor(Field.java:1082) at java.lang.reflect.Field.getFieldAccessor(Field.java:1063) at java.lang.reflect.Field.get(Field.java:387) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav

I am using the CF10 Report Builder.I need to convert a 6 character string and compare it to a 20 character string.Input = 201516 needs to be converted to 201508 and 201601. I am trying to handle the conversion in my query and not pass any records that I do not want to count to my report. IF the is a better way I am open to suggestions. Here is the code in my query that gives me a "Conversion failed when converting the varchar value 'E' to data type int'WHERE name.soc_sec = transact.soc_sec          AND name.soc_sec = prospect.soc_sec         AND name.soc_sec = approg.soc_sec         AND name.soc_sec = nmcrs.soc_sec         AND name.soc_sec = transact.soc_sec         AND transact.accept <> 'v'          AND transact.tcodes = 'AW'   &nbs

Hello,I am trying to re-index my cold fusion collection from verity to solr. But I am getting following error while re-indexing. It will let me continue if I wait for some minutes or after restart the solr service.Please see the error below :==============================================Error_opening_new_searcher_exceeded_limit_of_maxWarmingSearchers4_try_again_later Error_opening_new_searcher_exceeded_limit_of_maxWarmingSearchers4_try_again_later request: http://localhost:8983/solr/adsausagesite/update?commit=true&waitFlush=false&waitSearcher=false&wt=javabin&version=1==============================================Do anybody have a solution against this error ? My coldfuison version if 9.Thank you.