The official community for ColdFusion.
Actividad reciente
declare@orderKey intINSERT#request.sqlObjectPrefix#tblOrders (tblPeopleFK,shippingMethod,shippingCost,insurancecost,shippingtotal,shippingWeight,itemSubtotal,tax,totalBeforeTax,total,orderStatus,payment_method ,cfuserid)SELECT<cfqueryparam value="#val(arguments.app_user_id)#" cfsqltype="CF_SQL_INTEGER">,oib.shippingMethod,oib.shippingCost,oib.insuranceamount,( oib.shippingCost + oib.insuranceamount ),oib.shippingWeight,<cfqueryparam value="#val(arguments.item_subtotal)#" cfsqltype="CF_SQL_MONEY">,<cfqueryparam value="#val(arguments.tax)#" cfsqltype="CF_SQL_MONEY">,<cfqueryparam value="#val(arguments.total_before_tax)#" cfsqltype="CF_SQL_MONEY">,<cfqueryparam value="#val(arguments.total_total)#" cfsqltype="CF_SQL_MONEY">,<cfqueryparam value="1" cfsqltype="CF_SQL_INTEGER">,<cfqueryparam value="#arguments.payment_m
We want to move from Coldfusion 9 to Coldfusion 11.Is there a way to copy all setiings from CF9 to CF11?I tried it with a Coldfusion Archive, create in CF9 and deploy it in CF11.The problem was that there were no settings imported, for example the Data Sources were not imported.Is there another way?
Coldfusion 10 Update 13Windows Server Datacenter 2008 SP2IIS7We're having periodic issues where our Coldfusion service seems to recycle or restart, and the user will receive a 503 Error Code back from IIS.At the time of the error, our coldfusion-out.log shows the service starting: Sep 9, 2014 12:46:55 PM Information [pool-2-thread-1] - Starting logging... Sep 9, 2014 12:46:55 PM Information [pool-2-thread-1] - Starting license... Sep 9, 2014 12:46:57 PM Information [pool-2-thread-1] - Standard Edition enabled Sep 9, 2014 12:46:57 PM Information [pool-2-thread-1] - Starting crypto... Sep 9, 2014 12:46:57 PM Information [pool-2-thread-1] - Starting security... Sep 9, 2014 12:46:59 PM Information [pool-2-thread-1] - Starting scheduler... Sep 9, 2014 12:46:59 PM Information [pool-2-thread-1] - Starting WatchService... Sep 9, 2014 12:46:59 PM Information [pool-2-thread-1] - Starting debugging... Sep 9, 2014 12:46:59 PM Information [pool-2-thread-1] - Starting sql... Sep 9, 2014 12:47:00 PM
when i try to create Apptacular generation with Mssql 2008 and msAccess : on CfBuilder2.0.1An Error has occured.Message:Element IDENTITY.IDENTITY is undefined in a CFML structure referenced as part of an expression.Details:this issue written on Github by the apptacular app creator, and has some solutions(not clearly described as solution) and app writers solution didnt worked for me...I need correct solution, if its possible by correct files?(2 years ago this product was same condition and purchased it 2013 february, its has still same error...)???
I want to install trial version of CF11. I want to know if I will need to reinstall it if I decide to go and buy licence later. Or I can just enter licence and continue using existing trial version already installed and set up.
I insert my data into mysql db with this code: <cfprocessingdirective pageEncoding="utf-8"> <cfset setEncoding("URL", "utf-8")><cfset setEncoding("Form", "utf-8")> <cfcontent type="text/html; charset=utf-8"><!DOCTYPE html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title></title></head><body> <cfparam name="postTextBox" default="" type="String"><cfoutput> <form action="index.cfm" method="POST" name="form"> <input name="postTextBox" type="text"/> <input name="" type="submit" value="Submit" /> </form></cfoutput> <cfquery name="myQuery" datasource="hello"> insert into ad (name) values(N<cfqueryparam value=#postTextBox# cfsqltype="cf_sql_varchar">)</cfquery></body> </html> The problem is when I insert arabic or persian characters that's store in database something like "????
I'm using cfftp to download files which I parse, then I need to delete the file from the server. (coldfusion 11 - development)I can list, and download the files fine, but am butting my head into a problem that I can't seem to resolve.USING THE SAME PATH AND FILE NAME that allowed me to 'get' the file - When I try to remove the file - I get this error.Error: 550 file: No such file or directory .(again - the path and file name I provide are identical to the path/filename - if this is a permission problem, I can delete files thru Filezilla, using the same credentials - with no problem)Here is the call to remove - <cfftp action="remove" connection="myConnection1" passive="true" timeout="360" remotefile=
I have a pretty generic SAML assertion that I need to encrypt so I can pass it as a URL variable. The problem is when I use the toBase64 tag it adds the <?xml version="1.0" encoding="UTF-8"?> line to the top of the encrypted string. This is what my code looks like:<CFSET MyDate = DateFormat(Now(), "yyyy-mm-dd") & 'T' & TimeFormat(Now(), "HH:nn:ss") & '.343Z'><cfxml variable="samlAssertionXML"> <samlp:AuthnRequest IssueInstant="#MyDate#" ID="_kdls_testing_application_for_single_sign_on" Version="2.0" xmlns:samlp="urn:oasis:names:tc:SAML:2.0:protocol"> <saml:Issuer xmlns:saml="urn:oasis:names:tc:SAML:2.0:assertion">https://localhost/sde</saml:Issuer> <samlp:NameIDPolicy AllowCreate="true"/> </samlp:AuthnRequest></cfxml><CFSET MySML = toBase64(toString(samlAssertionXML))>When I decrypt the variable MySML using an online debugger this is what I get:<?xml version="1.0"
I'm running into issues connecting to a server running Windows 2012 and IIS 8 via https when SNI is enabled in the site's binding. It turns out there is a bug in the HTTPClient library Bug#3598342 - CFHTTP does not work with SNI enabled SSL which is supposed to be fixed in builds 288845, 288846 and 290605.So my issue is I have the latest update 13 installed but only have build 287689. Is there any way to update to the latest build or do I have to wait for the next update? If there's going to be a next update that is.Thanks,Richard
I built my image paths and did a cfdump to check what is being produced: <!--- Build image paths ---> <cfset image_src="../images/f#movie.FilmID#.jpg"> <cfset image_path=ExpandPath(image_src)> <cfdump var="#image_src#"><br> <cfdump var="#image_path#"> I get the following when I run the page: ../images/f5.jpg C:\ColdFusion11\cfusion\wwwroot\workspace\OWS\images\f5.jpg When I right-click on the image place holder and copy the image URL into a browserr address bar, what is being passed is:http://127.0.0.1:8500/workspace/OWS/10/%E2%80%9D../images/f5.jpg%E2%80%9Dso, it is not taking out the ".. and " from around the image location of the following line as it expands the URL:<cfset image_src="../images/f#movie.filmid#.jpg">On another page I deleted the double-quotes and then put them back in and that worked. For some reason it didn't like the double-quotes that were there and didn't recognize the code correctly until I replaced them. I can't ge
Coldfusion Version 10I am struggling with <cfdocument> PDF formatting. On the TEXT Input screen the user puts incohort for Clergy Leadership that meets approximately every quarter. In addition I have completed the require Ethics II training and other CEU offerings at the District level.Statistics From September 2013– August 2014• Total Visitations 300• Home/ Personal 486• Hospital 28• Major/ Minor Surgery 6• Funeral Visitation Days&
Hi All,Normally if a request is going to a CF server then the server wil generate two tokens CFID (say 100) and CFTOKEN (say 200) and this save as session cookies in broweser. This mechanism is for maintaining a session. And now if the session got expired , say after 20 mints , then the server will generate new tokens(say 300 and 400). This is how a CF session management is working , if I am not wrong.I think in most of the cases we are not using the generated token(CFID and CFTOKEN) in our cfm or cfc code , atleast I didnt use. So my question is what is the real use of CFID and CFTOKEN untill and unless we are using those tokens while coding??. These questions arised in my mind when I was fixing some vulnerability issues as part of PCI scan where I had to secure session cookies. So I was thinking like was it really necessary to secure those session cookies as we are not using those cookies anywhere in our application rather those cookies are just used for session management.Or what an
Hi any one help me - How to redirect on htttp to https with www redirect of coldfusion mx7?
Issue DescriptionSimply put when we make a request to any .cfm page with content-type of application/json and json in the request body the cfml will run (tested with cflog) but the browser/testing tool will indefinitely hang. If you leave the request body empty though the request will work normally.SetupWindows Server 2008R2 - IIS 7.5Coldfusion 11 (still no patches!)Postman/Fiddler for testingDebuggingSo I know that the request makes it to coldfusion by using cflog.I then put the isapi_redirect connector into debug mode to see if anything useful appeared in the logs (will add below) and when the request gets through to coldfusion it looks like the html for the page is returned, but for some reason it looks like its looking up the index.cfm and index.html (which is odd) and there is also a difference the the last few lines of the two requests - i dont really know enough at this level to make heads or tails of it.On the IIS side of things if you look at the worker processes for the conne
I hope someone here can help me with the following problem, cause I haven't been able to find the cause of the problem. When I try to access my website I get the following error:Yesterday everything was working fine. I haven't changed anything to the site. My provider says the problem is with my code, but on my laptop with the same coldfusion version (10) everything works fine.- could it be fusebox 4? (Yes, I know ... I am in the proces of converting my application to coldbox)- Has anybody experienced yhis problem to?- any solutions? I haven't been able to find anything in de forum or on google.Thank
is it possible to do a http post to a directory if there's index.cfm inside it?For example:directory/file = /api/update/index.cfm<form method="post" action="/api/update"></form>
I need to know if the user has cookies enabled when he logs into my website so I can tell him/her to enable them. If they are not enabled, the SessionID will be lost and session vars will not work.
I have an SQL table that I store OrderID, ItemID, Qty. There are 15 possible ItemID's (will never be more). I need to output the order into a single table row that shows the orderID and the qty for each item.For example:<cfquery name="orders" datasource="xyz"Select *From solditemsWhere orderid = 'Order1"</query>Would return something like:Order1, Item3, 6Order1, Item4, 7Order1, Item18, 10The table needs to look like:<tr><td>#orderID#</td><td>#item1qty#</td><td>#item2qty#</td><td>#item3qty#</td><td>#item4qty#</td><td>#item5qty#</td><td>#item6qty#</td><td>#item7qty#</td><td>#item8qty#</td><td>#item9qty#</td><td>#item10qty#</td><td>#item11qty#</td><td>#item12qty#</td><td>#item13qty#</td><td>#item14qty#</td><td>#item15qty#</td></tr>I'm at a loss trying to figure out ho
Hi,Run CF9 on Windows 2008 R2 Server.I have a cfm page with multiple dropdowns (some are cfselect) and dynamically generated lists of checkboxes interdependent on each other. I am using JQuery to submit data to cfc functions and to display data.It was all working fine until we added new company with large number of records. This translated into large URL query string with a lot of parameters submitted for processing. That's when we started to have problems. I noticed when trying to directly submitting URL, if the total number of characters in URL is more than 2114 I get an error status code 302 Redirect and nothing is displayed. I tried to play with postParametersLimit and postSizeLimit increasing to 1000.0 in neo-runtime.xml and restarting server but, this did not help.Below is jquery function:function populateBills(){ var plID; if ($('#planenrolldate_id').val() == undefined) plID = $('input[name=planenrolldate_id]').val();&
I am using CFOBJECT to call a .NET dll and the server responds with "DotNet side does not seem to be running". I am using CF 9.0.1. .NET is installed and running as a service. I saw on a forum concerning this exact issue that I need to uninstall my current .NET service, then re install it. However, I cannot find the installer for CF 9's version of the .NET integration service. I do see .NET integration installers for CF10 and 11, but not 9.Where can I download the CF9 version of the .NET integration service installer?thank you
Repost, really need help. I have 3 cfchartseries within my cfchart. I want to display the values for one of the cfchartseries only, so I use dataLabelStyle="value", which works.However,the other two cfchartseries also have their values displayed even though I do not have dataLabelStyle in them. I only want one of the cfchartseries to display the values. What am I doing wrong, or what is going on here, can somebody please explain this to me ? Does dataLabelStyle even work ?
I am using coldfusion with spreadsheet, is there any function or any way to duplicate/clone/copy an existing sheet (act like template) in a workbook, and use it as a template for a new sheet in another workbook?
I want to set a variable to <cfset inputstring = "<img src="../../../server/win/form/stamp/string_1" />"/>but i keep getting error: Invalid CFML construct found on line 184 at column 32. ColdFusion was looking at the following text: . I have try it different ways , what i'm i doing wrong?
Hi,I'd like to start by saying I didn't have this issue on CF9 Standard but recently updated to CF10 and now have the issue.I have a site and several sub domains running on IIS and CF10. They are all set up as separate sites but share a wildcard SSL certificate for *.domain.comwww.domain.comforums.domain.comcommunity.domain.cometc.I'm doing cfhttp calls between the sites. They work fine over http but over https, I get the all too common 'I/O Exception: peer not authenticated' error.Charset [empty string]ErrorDetail I/O Exception: peer not authenticatedFilecontent Connection FailureHeader [empty string]Mimetype Unable to determine MIME type of file.Responseheader struct [empty]Statuscode Connection Failure. Status code unavailable.Text YESSo I figured I needed to install the SSL certificate. I've installed the certificate in the correct key store and verified it's there using keytool -list and restarted. I even tried unin
I have to admit that I am greatly disappointed with CFB 3. The loss of something as simple as FTP synchronization is ridiculous. The time I have spent trying to find a work around has been fruitless. The eclipse RES plugin has a bug, so it doesn't work. Installing the Aptana plugin is somewhat functional but you are constantly jumping between views to code. The built in "import/export" feature is a sad excuse for FTP synchronization and generally doesn't work. Code hinting is hit and miss, loss of word warp and the list goes on. Further more, the interface is not intuitive and help documentation is spotty and less then helpful.I've installed CFB 3 as an eclipse plugin (which runs faster and smoother) as well as stand alone. Both being a vast disappointment. To further my disappointment, it's quite apparent that no one from the CFB team monitors or responds to any posts on this forum.
Remix with Firefly Community Gallery
Thousands of free creations to fall in love with and remix in Firefly.
¿Ya tiene cuenta? Iniciar sesión
¿Aún no tienes una cuenta? Crea una cuenta
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.