To use HTTPS with the cfhttp tag, you might need to manually import the certificate for each web server into the keystore for the JRE that ColdFusion uses.
–Adobe

Here is how to do that:
1. Load the HTTPS url in your browser and export the certificate as a .cer file (see link above for more details)

2. Copy the .cer file on the CF server

3. Locate the path of ‘Java Home’ in CF Admin. It should be something like /usr/java/jre1.7.0_51, usually with a symlink to /usr/java/default.
The keystore location should be {Java Home}/lib/security/cacerts and it’s password protected.

4. Import the .cer file into the keystore:

#/usr/java/default/bin/keytool -import -keystore 
/usr/java/default/lib/security/cacerts -alias thomas 
-file thomas.cer -storepass changeit

5. Check that the certificate was installed:

#/usr/java/default/bin/keytool -list -keystore 
/usr/java/default/lib/security/cacerts -storepass changeit -alias thomas 
# thomas, Feb 6, 2015, trustedCertEntry, Certificate fingerprint (SHA1): XX:XX:XX:XX:XX:XX:XX:XX:XX:XX:XX:XX:XX

6. Restart ColdFusion server

See also this and that.

Because the Notice of Competition and the official comments on the blog are not very clear, here is a visual representation of the competition steps:

Made with SchemeIt

Talent screener works in 2 stages:
– first a score is calculated based solely on the yes/no answers
– second a score is calculated based on weighted average (each criteria has a number of points assigned).
Like that (note – the talent screener questions below refer to an old competition):

There, I fixed it.

Problem: Oracle error maximum number of expressions in a list is 1000
Solution:

-- Instead of
select * from foo where id in (List)
-- use
select * from foo where id in (Sub-query)

link