ColdFusion | Obidos Technologies Knowledge Base

Lock down Lucee Admin to localhost with IIS

Posted on February 19, 2018
/Under Apache, ColdFusion, Lucee, Railo, Server, Tomcat
/With 0 Comments

Lucee Admin can be locked to be accessed only from the localhost with IIS. For this, you need to have Remote Access to the server. Go to IIS admin (inetmgr). Navigate to a particular domain. Go into the /WEB-INF/ directory. Select the /lucee/ directory. Click the “Add Allow Entry” option...Read more

Join separate Date and Time fields to one field in MS SQL Server

Posted on July 31, 2017
/Under ColdFusion, Database, Lucee, PHP, Railo, Server, SQL Server
/With 0 Comments

When you have date and time separate in two fields, it becomes difficult to have date operation like add in them. To have a correct solution, we need to join these two fields and create a new DateTime value on which we can operate on. Use the following code in...Read more

Accurate way to round decimals in JavaScript

Posted on February 27, 2017
/Under ColdFusion, Internet, JavaScript, JSON, Node.JS, PHP, Technology
/With 0 Comments

The rounding problem can be avoided by using numbers represented in exponential notation: Number(Math.round(1.005+'e2')+'e-2'); // 1.01 Source: http://www.jacklmoore.com/notes/rounding-in-javascript/Read more

SOLVED Submitting Form with more than 100 fields shows blank page in ColdFusion9, 10

Posted on October 19, 2016
/Under ColdFusion, Internet, Server, Technology
/With 0 Comments

ColdFusion 9 & 10 by default have a setting to allow maximum 100 fields to be submitted. If the number exceeds you will simply get a blank page with no error information. To fix this, you need to change a setting in Adobe CF 9 and 10. ColdFusion 9 Go...Read more

SOLVED QuickBooks Integration Error – EDGE-CR-ERR-8090 – Auth ID does not exist

Posted on October 14, 2016
/Under ColdFusion, Integration, JSON, MySQL, PHP, QuickBooks, Server, Technology
/With 0 Comments

Integration with QuickBooks is easy if you know the OAuth flow. QuickBooks uses the OAuth 1.0 specification. They provide libraries for PHP, Java and other popular languages. For ColdFusion/Railo, you can use the OAuth implementation from http://oauth.riaforge.org/. Usually the error messages from QB are self-explanatory and are mostly related with Signature...Read more

How to Store and Retrieve FORM variables or Objects to DB using Railo/ColdFusion

Posted on September 28, 2016
/Under ColdFusion, Database, JSON, Technology
/With 0 Comments

If we need to store all the URL variables to the DB, say, for tracking the user, it is easy. We can use a varchar field to store this information and retrieve later. But when it comes to FORM variables or Objects, the RDBMS does not support storing them. The...Read more

SOLVED Adobe ColdFusion Scheduled Task and PDF fail/error/not running – June 2016

Posted on August 18, 2016
/Under ColdFusion, Server
/With 0 Comments

The Adobe ColdFusion servers on Windows Servers and having SSL could develop and issue with Scheduled Tasks not able to run after June 2016. We have experienced this issue with one of our servers. The only information we receive when saving the output of a scheduled task to a file...Read more