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

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

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
Backup Third Party Drivers in Windows 10

Backup Third Party Drivers in Windows 10

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
*SOLVED* QuickBooks Integration Error – EDGE-CR-ERR-8090 – Auth ID does not exist

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

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

Mysql join and sum is doubling result

The way to get around this is to create inline views of your aggregates and join on the those results. SELECT R.title_id, R.revenue, R.cost, F.interest FROM (SELECT title_id, Sum(revenue) revenue, Sum(cost) cost FROM revenue GROUP BY revenue.title_id) r LEFT JOIN (SELECT title_id, Sum(interest) interest FROM fund GROUP BY title_id) f...Read more