Truncating Numbers in Coldfusion

To trunc numbers without rounding in coldfusion simply use:

fix(myNumber)

ex: <cfoutput>#fix(34.731)#</cfoutput>
Result: 34

Comments

Error: Write to Disk Access Denied - Troubleshooting - BitTorrent

I have downloaded Bit Torrent software and when trying to download I got an error after few seconds saying:

Error: Write to Disk Access Denied
Solving this problem is so simple:
Shut down BitTorrent program.
Go to Start and in the small search box on top of windows start button start typing Bittorrent and the program will show, right click with the mouse on the icon and Run as Administrator.
All ur problems are sorted out now and you can enjoy downloading...
Good Luck.

Importing SSL certs to Coldfusion Railo OR Lucee keystore

If you are having the below error:
Railo 3.3.4.003 Error (javax.net.ssl.SSLHandshakeException)Messagesun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested targetCausejavax.net.ssl.SSLHandshakeException

This means you are trying to invoke an https webservice. to invoke an SSL webserver you need to import the certificate into Railo by using keytool command. Below are the steps on how to do this:

1- use fire fox to open the webservice and click on the padlock as shown on the below image:

2-Click on more information as below:
3- Click on View Certificate as below:
4-Click on details as below:
5- Now export the certificate and save it to your computer with .cer extension.

6- Search in railo folder for the keytool command location, in my case it was under railo\jdk\bin

7- Search in railo folder for the cacerts location, in my case it was under railo\lib\railo-s…

Insert Date in dd/mm/yyyy Format in Postgres

The default postgres date format is yyyy-mm-dd in case you want to insert date in the format dd/mm/yyyy you need to set the datestyle at the beginning of your insert or update query as the below:

setDateStyle='ISO, DMY';

Mustafa Abusalah Blog

Search This Blog