Obidos Technologies Knowledge Base

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

Optimize Oracle Database

Posted on June 3, 2017
/Under Database, Oracle
/With 0 Comments

Overtime, the Oracle DB will become sluggish with the insert/update/deletes. So we need to optimize the DB so that the queries are faster. To optimize a single table, use the following command: exec DBMS_STATS.GATHER_TABLE_STATS (ownname => ‘&schema’ , tabname => ‘&tabname’, cascade => true); To optimize a single schema and...Read more

How to clone a GIT repository into a non-empty directory.

Posted on April 29, 2017
/Under GIT, Lucee, Release, Repository, Server, Technology
/With 0 Comments

If you need to clone a GIT repository into an existing directory with files, use the following commands in command prompt in order. After this, you can easily use your favorite GUI tool like TortoiseGIT or command line to sync files.Read more

$Hide the fractional part in a decimal number if it is .00, in PHP$

Hide the fractional part in a decimal number if it is .00, in PHP

Posted on April 21, 2017
/Under Apache, Internet, PHP, Server, Technology, Tomcat
/With 0 Comments

When displaying decimal numbers, it will show both the Integer and Fractional part even if the fractional part is 00. Like below: 2.35 3.50 2.00 If we need to hide the fractional part when it is 0, just add the number with 0 as below: <?php echo $amount + 0; ?>...Read more

FIXED Setting you Railo / Lucee server to use TLS 1.2 by setting to use Java 1.8 instead of Java 1.7.

Posted on February 28, 2017
/Under Apache, Integration, Internet, Lucee, Railo, Release, Server, Technology, Tomcat, Windows
/With 0 Comments

TLS 1.0 support is being dropped by more and more platforms. If you are using your Railo / Lucee server to communicate with the service that have dropped the support using TLS 1.0, the request will not be honored. Here are the steps to have your Railo/Lucee server to use...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

Backup Third Party Drivers in Windows 10

Posted on February 8, 2017
/Under Server, Windows
/With 0 Comments

To back up your current collection of drivers, open File Explorer and go to C:\Windows\System32\DriverStore. Copy the FileRepository subfolder to a backup location. Reference: http://www.zdnet.com/article/windows-10-tip-back-up-your-third-party-hardware-drivers/Read more

Basic requirements to create and run a Node JS app

Posted on February 7, 2017
/Under Internet, JSON, Node.JS, Server
/With 0 Comments

To create a Node.js app that acts as a back end for an Angular JS app, these are the minimum required modules.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

← Newer Posts

Older Posts →