Questions

Some documents are unreadable, is with other characters /? @ ?

Hello, all,I am having some issues trying to put together an SQL query of an Oracle 11g database, and I could use some help.Let's say tableA is blog entries; tableC is comments for the blog entries; tableB is the associative table:tableAblogID        blogTitle       blogBody      dateEntered1             This is a test  More text...  2016-05-20 11:11:112             More testing    Still more!   2016-05-19 10:10:103             Third charm!!   Blah, blah.   2016-05-18 09:09:09tableCcommID        userID          userText      dateEntered10    &n

Have query that worked until v2016.  Using order by right(LogNumber,3) DESC get error:Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'right'query:  SELECT LogNumber  FROM tblMain  WHERE (Program = 'Apple')  ORDER BY right(LogNumber,3) DESC

Hi everyone. I was able to get a very simple shopping cart set up and to work with adding a Product to the cart and deleting the Product, but how do I add or display something such as the price of the product too? Here's what I have below on a products.cfm page and a ShoppingCart.cfm page:products.cfm<form action="ShoppingCart.cfm" method="post">Product 1 Description <input type="hidden" name="productID" value="1" /> <input type="hidden" name="productName" value="Socket" /> <input type="submit" value="Add To Cart" /></form><form action="ShoppingCart.cfm" method="post">Product 2 Description <input type="hidden" name="productID" value="2" /> <input type="hidden" name="productName" value="Adapter" /> <input type="submit" value="Add To Cart" /></form>ShoppingCart.cfm<cfif NOT StructKeyExists(session,'ShoppingCart')>  <cfset Session.ShoppingCart = StructNew()>    <cfset Session.ShoppingCart.FirstN

Hello, all,I've been playing around with imageDrawLine(s) and imageDrawText (only just recently discovered them), and I am confused about something that I hope someone can help clarify.If I create a new image using imageNew, I can draw lines and text on it with no problems.However, if I use CFIMAGE or imageNew to create an image from an existing .gif, it will not work.  It does not error - it just leaves a blank white space where the image should be.Is it not possible to add lines or text to existing images??  Here's my code, so far:<cfimage action="read" source="#app_root#img/500x500.gif" name="myImage" /><cfset imageSetAntiAliasing(myImage,'on') /><cfset imageSetDrawingColor(myImage,'black') /><cfset attr = StructNew() /><cfset attr.width = 5 /><cfset attr.endcaps = "round" /><cfset imageSetDrawingStroke(myImage,attr) />   ... set x/y arrays ...<cfset imageDrawLInes(myImage,x,y,true,false) /><cfimage action="write

Hello,I am using CF11 on a Windows2012 server 64bitWhen using cffile with action "write" and using charset="utf-16", it creates a UTF-16BE (Big endian) file.Is there a way to get a UTF-16LE encoded file ?(I have tried charset="utf-16le" but it doesn't work).Regards,Pierre

I am receiving this error in CF Builder. Any ideas let me know.Version: 3.0.0Build: 292922!ENTRY org.eclipse.help.base 4 0 2016-05-17 10:55:06.470!MESSAGE Internal error while reading topic extensions from remote server!STACK 0org.xml.sax.SAXParseException; lineNumber: 50; columnNumber: 29; The entity name must immediately follow the '&' in the entity reference.  at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:257)  at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:348)  at org.eclipse.help.internal.dynamic.DocumentReader.read(DocumentReader.java:56)  at org.eclipse.help.internal.dynamic.DocumentReader.read(DocumentReader.java:44)  at org.eclipse.help.internal.base.remote.RemoteExtensionProvider.getContentExtensions(RemoteExtensionProvider.java:65)  at org.eclipse.help.internal.extension.ContentExtensionManager.loadExtensions(ContentExtensionManager.java:100)  at org.eclipse.

On a Solaris server I am trying to patch a CF11 Update 7 instance to Update 8. Another development group updated all the other instances except the two I work on without talking to me first. On one of my CF instances the update page I see the following error:The web site you are accessing has experienced an unexpected error. Please contact the website administrator.    The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request    The getColdFusionInstances method was not found. Either there are no methods with the specified method name and argument types or the getColdFusionInstances method is overloaded with argument types that ColdFusion cannot decipher reliably. ColdFusion found 0 methods that match the provided arguments. If this is a Java object and you verified that the method exists, use the javacast function to reduce ambiguity.         &

I'm working on proof of concept of making my app more scaleable and reducing the support footprint on OS patching.I'm trying to take a CF11 Enterprise generated WAR file, and deploy it onto an Azure Tomcat 7 web app. I've never deployed CF apps on J2EE before, so I'm not sure if my problems are user error, or attempting the impossible.I can fire up Azure, deploy a Tomcat 7 server, and put a (non CF) war up in the webapp folder, and watch it deploy and become usable.  But when put the CF war up, it explodes the directory out properly, but then refuses to run the web app.So I installed a local x64 copy of Tomcat 7.0.50 (same version as Azure) and tried the same thing. Locally, the sample WAR files worked fine (non CF), but when I tried a war produced by the Administrator on CF11 - the one page index.cfm (with only a cfdump in it) fails.Near as I can tell, it has to do with the web.xml generated by CF 11 Package and Deploy wizard. This is the most relevant error in my stderr log. It

Unable to debug coldfusion cfml. I have done the following setting.Allow Line Debugging is enabled.Debugger Port: 7777-DDEBUGGER_SERVER_PORT=7777.Test debugger fails.

Ok, so I've got a strange problem that I've been beating my head against for over a week now.  I'm holding out a little hope that maybe someone here has seen something like this and has a solution or at least can point me in a direction to make some sense of it.We are running an enterprise application on CF9 currently.  Recently we made a large update with some advancements and in part of the advancements I'm using some request scoped variables.Said request variable is a structure that is set in Application.cfc OnRequestStart.  Randomly since the changes have been put on our production servers we get an error email (we have an error handler defined to capture and email errors when they occur), stating that key.subkey is undefined in request scoped variable.  What makes this so bizarre is in the email from the error handler (that is processed in the same request) shows the key.subkey existing in the request scoped variable in a <cfdump var="#request#"> in the e

Hi. I am trying to understand how to use a very simple shopping cart in Cold Fusion, but am having a hard time. I've tried looking at information on web sites, but they all use a script like this below that fills in the info. into a cart. <cfscript> CartItems=4; Cart = ArrayNew(1); for ( i=1; i LE cartItems; i=i+1) {      Cart=StructNew();     Cart.ID=i;     Cart.Name="Product " & i;     Cart.SKU=i*100+(2*i*10)+(3*i);     Cart.Qty=3*i-2; } </cfscript>I would rather use my own form that outputs info. into a table to display to the user and this table could be used as a shopping cart. I've created this very simple form below. Can someone please show me an example of how to make this form into a shopping cart so I can add, update, and delete the items in it? Thank you.Andy

I'm following the lockdown guide here:http://wwwimages.adobe.com/content/dam/acom/en/products/coldfusion/pdfs/coldfusion-2016-lockdown-guide.pdfThe guide suggests moving the /cf_scripts/scripts directory, so I did.The guide also suggests using only the built-in web server for accessing ColdFusion Administrator, so that's how I have it set up.The guide also states that you should create an alias for the moved directory in the built-in web server.  See page 58 of the PDF. If you plan on using the built-in web server to access ColdFusion administrator you may need to create an alias for /cf_scripts/scripts if you changed the Default Script Src setting in ColdFusion administrator. To Create a new Alias for /cf_scripts/scripts in the built-in web server If you plan to use the built-in web server for accessing ColdFusion administrator then you must also add an alias by adding a Context tag inside the Host tag of server.xml located: /opt/cf11/cfusion/runtime/conf/server.xml <Context

Yesterday morning I updated CF11 to update8, on a windows 2012, iis 8 box.As I was reviewing one of my application logs, I noticed that from the time the server updated and forward that one of my values went blank.CGI.http_URL was tracked on session start as part of my marketing logs.  It is no longer tracking as of Update 8.  I have tried to rollback to update 7 but that did not resolve my issue.Upon googling, I see that this use to be an issue that was fixed and appears to have returned with the new Update.Bug#3758070 - CGI.HTTP_URL Missing when using IIS Obviously there must be something else that the CFAdmin rollback feature didn't roll back.Is there anything that can be manually updated until its fixed again?Steve

I'm having a great deal of trouble trying to implement a SOAP call to CyberSource, and I'd appreciate any help that anyone can provide.The environment: ColdFusion 11 on Windows 2012 Server, 64-bit.The SOAP packet (personal info redacted) is as follows; it's basically the CyberSource sample provided in their documentation:<?xml version="1.0" encoding="utf-8"?><soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"     xsi:schemaLocation="http://schemas.xmlsoap.org/soap/envelope/"     xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">    <soapenv:Header>    <wsse:Security soapenv:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">    <wsse:UsernameToken>    <wsse:Username>XXXXXXX</wsse:Username>    <wsse:Password Type="http://docs.oasis-open.org

Bonjour,J'aimerai prendre un livre en PDF pour le découper en chapitres en cfm.J'aimerai me servir du style de word : Titre1 = titre du livre ; Titre 2 = chapitre ; ...Merci pour votre aideHello,I would like to take a book to PDF to split it into chapters cfm.I would like to serve me the word style: Heading 1 = title of the book; Heading 2 = Chapter 2; ...Thanks for your help

I am still using CF8 and love it, but here's my question.Can someone show me an example of cfimagedrawlinesthat draws a left sloping rectangle?Terry

First off is connecting to Exchange 2013 supported by either ColdFusion 11 or ColdFusion 2016?  If so what are the steps to getting cfexchangeconnection to actually connect?  Our current setup is CF11 and Exchange 2010, and everything is working as expected.  I can connect, fetch calendar events, read email, move email to other folders, etc. I know there are some special settings on Exchange and IIS and OWA to be set, but what are they specifically?  Is there some sample code of how to get cfexchangeconnection going?  What's with the form based authentication?  What's the default URL for form based authentication on OWA for Exchange 2013?  Help!

I am using the ColdFusion Administrator to download and install the hotfix.I am using the built-in server for ColdFusion Administrator (not IIS).It fails every time, just as it does in CF 10 and CF 11.I have installed ColdFusion 2016 using their best practices / lockdown guide.ColdFusion 2016 is installed into a dedicated partition and the account the service runs as has full permissions on that entire partition.The Summary says it's Unsuccessful, with 6 NonFatalErrors and 6 FatalErrors.I get 6 copies of:Moving files failed:: Failed to back up the previous hotfix files. Retry installation after ensuring that the server is not running or files are not locked by the server.I get 6 copies of:Failed to delete directory: Ensure that the server is not running or files are not locked by the server.I get 6 FATAL ERRORs involving different files.  Here's an example:Moving files failed:                 &nbs

Anyone know how I would resolve this error?

Hi There Have loaded CF 2016 server on a test PC to test the impactof upgrading of our website from CF10, however when defining an ORACLE 11.gdata source am getting this error. Works fine with CF10. Connection verification failed for data source: cls4java.sql.SQLException: [Oracle JDBCDriver][Oracle]ORA-01882: timezone region not found The root cause was that: java.sql.SQLException:[Macromedia][Oracle JDBC Driver][Oracle]ORA-01882: timezone region not found  Any advice on fixing it?

When is the CF2016 Hotfix 1 being released?  I'm blocked on my upgrade project due to this bug: Bug#4126398 - SQL comments inside CFQuery are not ignored

When I select new launch configuration, I get the following error.An error has occurred. See error log for more details.Path for project must have only one segment.!ENTRY org.eclipse.jface 4 2 2016-05-10 11:24:33.317!MESSAGE Problems occurred when invoking code from plug-in: "org.eclipse.jface".!STACK 0java.lang.IllegalArgumentException: Path for project must have only one segment.  at org.eclipse.core.runtime.Assert.isLegal(Assert.java:63)  at org.eclipse.core.internal.resources.WorkspaceRoot.getProject(WorkspaceRoot.java:184)  at com.adobe.ide.coldfusion.common.projectResources.CFProjectResourceProvider.getProject(CFProjectResourceProvider.java:136)  at com.adobe.ide.coldfusion.debug.ui.CFLauncherMainTab.performApply(CFLauncherMainTab.java:239)  at org.eclipse.debug.internal.ui.launchConfigurations.LaunchConfigurationTabGroupViewer.refresh(LaunchConfigurationTabGroupViewer.java:446)  at org.eclipse.debug.internal.ui.launchConfigurations.LaunchConfigurati

Hi All,I want installer for ColdFusion 11 developer edition 64 bit. As usual I went to Adobe - ColdFusion Support Center : More Downloads , but it seems only ColdFusion (2016 release) - Developer Edition (Free) installer is there and for other version the add-on instillers are there.So, where I can get it?Thanks in advance.

I have been tasked with upgrading our web servers from Windows Server 2008 to 2012. As we are not upgrading our ColdFusion version, is it possible to use the same licenses on the new servers? If so, would we be able to have 2 instances of the license operating for a month long period in order to migrate? We have 4 servers in total, 2 running CF11 Enterprise (production), and 2 running CF11 standard (test).