I'm kinda stuck and can't work until that release is out.  I'm sure you can't tell me the exact date but I really can't lose another couple days.  Is "very soon" in a couple days or do I need to downgrade to continue working? ... View more

Thanks Carl! Have you ever heard when the first update will be released?  Trying to decide if I want to go through the pain of downgrading.  Thanks! ... View more

Carl, thanks for the help, sorry that did not work though.  I've created a test that you can copy and paste into a file to save.  You can run it on Coldfusion 11 and Coldfusion 2016 and get 2 different results.  I'm honestly not sure what is happening, I'd love to hear that it is a simple setting in the admin! Code to Paste into new file: <cfscript>     db = QueryNew("ID,parentID,title,priority", "Integer,Integer,VarChar,Integer");     queryAddRow(db, [         {ID=1, parentID=0, title="Main 1", priority=1},         {ID=2, parentID=1, title="Main 2 - Sub 1", priority=1},         {ID=3, parentID=1, title="Main 2 - Sub 2", priority=2},         {ID=4, parentID=3, title="Main 2 - Sub 2 - Deep 1", priority=1},         {ID=5, parentID=3, title="Main 2 - Sub 2 - Deep 2", priority=2},         {ID=6, parentID=1, title="Main 2 - Sub 3", priority=3},         {ID=7, parentID=0, title="Main 2", priority=2},         {ID=8, parentID=0, title="Main 3", priority=3},         {ID=9, parentID=0, title="Main 4", priority=4},         {ID=10, parentID=0, title="Main 5", priority=5}     ]); </cfscript> <cffunction name="doThis" access="public" returntype="string">     <cfargument name="parent" type="numeric" default="0">     <cfscript>         var LOCAL = {};     </cfscript>     <cfquery name="LOCAL.q" dbtype="query">         SELECT    ID, parentID, title         FROM    db         WHERE    parentID = <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.parent#">         ORDER BY priority;     </cfquery>     <cfsavecontent variable="LOCAL.html">         <cfif LOCAL.q.RecordCount>             <ul>                 <cfoutput query="LOCAL.q">                     <li>                         <span>#LOCAL.q.title#</span>                         #doThis(parent=LOCAL.q.ID)#                     </li>                 </cfoutput>             </ul>         </cfif>     </cfsavecontent>     <cfreturn LOCAL.html> </cffunction> <cfoutput>#doThis()#</cfoutput> In Coldfusion 2016: <ul>     <li>         <span>Main 1</span>         <ul>             <li><span>Main 2 - Sub 1</span></li>             <li>                 <span>Main 2 - Sub 2</span>                 <ul>                     <li><span>Main 2 - Sub 2 - Deep 1</span></li>                     <li><span>Main 2 - Sub 2 - Deep 2</span></li>                 </ul>             </li>         </ul>     </li> </ul> In Coldfusion 11: <ul>     <li>         <span>Main 1</span>         <ul>             <li><span>Main 2 - Sub 1</span></li>             <li>                 <span>Main 2 - Sub 2</span>                 <ul>                     <li><span>Main 2 - Sub 2 - Deep 1</span></li>                     <li><span>Main 2 - Sub 2 - Deep 2</span></li>                 </ul>             </li>             <li><span>Main 2 - Sub 3</span></li>         </ul>     </li>     <li><span>Main 2</span></li>     <li><span>Main 3</span></li>     <li><span>Main 4</span></li>     <li><span>Main 5</span></li> </ul> It appears to me that the LOCAL.q is actually getting overwritten each time, it isn't actually being stored LOCALLY.  I've tried your suggestion with var q as well and it was the same. Thanks!! ... View more

Hey Carl, I'm just used to putting that in there from the old days, I did try to remove it just in case something changed in 2016. 2016 Output: <ul>     <li>         <span>Item 1</span>     </li> </ul> Coldfusion 2011 Output: <ul>     <li>         <span>Item 1</span>     </li>     <li>         <span>Item 2</span>         <ul>             <li>                 <span>Sub 1</span>             </li>             <li>                 <span>Sub 2</span>             </li>         </ul>     </li>     <li>         <span>Item 3</span>     </li>     <li>         <span>Item 4</span>     </li> </ul> ... View more

What's interesting is it seems to run until the query returns no results. ... View more

Interesting. I pasted it in there... Hopefully it stays this time.... <cffunction name="doThis" access="public" returntype="string">     <cfargument name="parent" type="numeric" default="0">     <cfscript>         var LOCAL = {};     </cfscript>     <cfquery name="LOCAL.q">         SELECT    parentID, title         FROM    thetable         WHERE    parentID = <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.parent#">         ORDER BY priority;     </cfquery>     <cfsavecontent variable="LOCAL.html">         <ul>             <cfoutput query="LOCAL.q">                 <li>                     <span>#LOCAL.q.title#</span>                     #doThis(parent=LOCAL.q.sitePageID)#                 </li>             </cfoutput>         </ul>     </cfsavecontent>     <cfreturn LOCAL.html> </cffunction> <cfoutput>#doThis()#</cfoutput> ... View more

You're right. There is no reason it shouldn't work so I went through everything again. I had an instance where I passed an empty string to cflocation for the url.  When developing in Firefox on Apache the empty string just redirected to the root. With Firefox on IIS and any other browser it showed a blank white page. Thanks for your willingness to help, sorry it was a user error! ... View more

I just noticed that it does not work on Chrome locally either so it isn't a apache/iis issue.  When I'm looking at the raw Response Header the "location" field is blank in Chrome (not in Firefox).  Thanks ... View more

Thanks for the response!  I've checked all the rules and files. All is good. It looks to me that everything is working but the cflocation.  If I manually go to the page the cflocation was being redirected to all of the code executed before the cflocation has been executed (logging the user in). It's just the cflocation not working. An other thoughts?  Thanks again! ... View more

Using this example CF10 /application.cfc - with onMissingTemplate /doesnoteexist.cfm - Fires onMissingTemplate /nofolderhere/doesnoteexist.cfm - DOES NOT fire onMissingTemplate If I create the directory "nofolderhere" (but not doesnoteexist.cfm) it does work.  It's just having trouble with the the missing templates inside the missing directories. I believe this is an issue with apache as I uploaded to my server which runs IIS and it is working as long as I have the "jakarta" virtual directory added. Thanks for any help! ... View more

You're correct, I did miss some details. I'm on a new windows computer that is running Apache with CF10.  My old windows computer was Apache with CF9.  I copied the http.conf and vhost.conf files from the old computer and put them on the new computer so I assumed all the settings would be the same. I've looked through all my settings and I cannot find any mod-rewrites or settings that would allow onMissingTemplate to work inside the same folder but not in missing sub-directories. Thanks for any tips you might have! ... View more

Hey Adam, no need to appologize at all.  I was really hoping you had a solution with that link!! Please don't feel like you have to spend too much time on it, I know I've spent tons of hours on this over the years. Solution that DID work: Created a word document and saved it as an HTML file (these files have all the Microsoft tags in them allowing me to set how the file will open in word as well as enable Trach Changes.  Its not just a simply HTML file) Use CF to to replace text and create new HTML files Start Word as a COM object using CF Open the Word file using CF Save as a DOC file using CF (It must be a REAL doc file, not just a file with a doc extension) Close Word This solution worked until I had to move the site to a 64bit server.  It did not like to open Word after the move.  I also understand that Word isn't necessarily made to be run on a server and I don't want to install it anymore and rely on it so I'm moving past this as a solution. Solution I want to work: Create the HTML files like I have before Use OpenOffice or POI to convert to an actual Word file I've had problems with this.  OpenOffice doesn't open the HTML files in Writer.  It opens in Writer/Web and doesn't have the ability to save as a doc, only as other HTML files.  I tried to use POI but I can't seem to get it to simply open a file and save it.  It would be way to difficult and I have to much formatting to create it on the fly, I also need Track Changes enabled when the file is open. Anyway, that's where I am. I think a company called Aspose has a product called "Aspose.Words for Java" which may work BUT it costs more than the projects budget will allow and its a yearly cost not just a one time up front cost. Thanks for taking a look. I may need to break my overall process to create the files, have the user download a zip file of the 100 HTML files and then have them manually open and save them as doc files and then upload a new zip file.  I could then continue the processes my files go through. Thanks! ... View more

Unfortuately I think I'm going to have to connect to OpenOffice with CreateObject or something but I can't get it to connect.  You can see in the link you sent that the built in tags do not support HTML to DOC.  The link also says "POI libraries support conversion of all office files except Word documents". So I can't use anything built in.... ... View more

I hope I don't have to do that as I'd have to switch 100 cfupdates and cfinserts. I'm on shared hosting so I have to use mySQL 4 since that is all they offer at this time. I've sent the following link to my host with no response, I'm hoping it will fix it. I read in a post that it does. http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18952 Its a hotfix for cfupdate and cfinsert. Thanks ... View more

Its only happening with columns that are "longtext" it does not happen for columns with the data type varchar. I've run some tests and I am 100% positive that the extra characters are being added by mySQL. ... View more

Navicat is a Graphical User Interface for mySQL so you don't have to use the command line to make changes to your database. It's similar to Access where you can create Tables or Queries. In Access if I create a Table or a Query i can access it with CFQUERY In mySQL if I create a Table I can access it with CFQUERY but if I create a saved query in mySQL I cannot access it with CFQUERY. Thanks for trying to help. ... View more

I'm using the mySQL GUI Navcat. There is an area to add a Query or a Stored Procedure. I'm am chosing Query and entering the following information. SELECT DISTINCT Year(`event`.`startDate`) AS eventYear FROM `event` ORDER BY eventYear asc; If I preview the query it shows me a set of tablular data with the values 2000,2001,2002,2005 I want to cfquery this query but it says the "Table" is not found. Thanks for being patient. ... View more

i shouldn't have called it mytable.... more like myquery. Its not a table... I created a query in mySQL which has all Distinct Years from my Event Table. I'd like to select that query and output the information like i would with a table. I'm new to mySQL... in Access you just ran CFQUERY like you would for a table. But with mySQL it does not work for me. Thanks in advance. ... View more