mark

Recent Blog Comments By mark

• JavaLoader Needs Access To Internal ColdFusion Java Components In ColdFusion 2018

  Posted on Oct 31, 2019 at 8:26 AM

  First quick correction missed a letter (should be UNNAMED not UNAMED) in my original post the line should be --add-exports=java.base/jdk.internal.loader=ALL-UNNAMED This is a different mechanic. Access to internal Coldfusion java components will still not be allowed. I did test this to con... read more »

• JavaLoader Needs Access To Internal ColdFusion Java Components In ColdFusion 2018

  Posted on Oct 17, 2019 at 12:49 PM

  I had a requirement that access to internal coldfusion objects had to be disabled. After a lot of reserach I found a alternative solution but it still require a change in the Coldfusion administrator In the JAVA and JVM setting in the JVM arguments text box add the following --add-exports=... read more »

• The Anatomy Of An INNER JOIN Query In SQL

  Posted on Aug 5, 2013 at 2:12 PM

  @Tom At least in MS SQL Server 2005 (this is what I have to use at work) it gives the exact same execution plan for all 3 methods... read more »

• The Anatomy Of An INNER JOIN Query In SQL

  Posted on Aug 5, 2013 at 1:09 PM

  I would of wrote the query the following way FROM (SELECT * FROM user where id=1)U inner join (select * from account where endedat is null)a on a.userID=u.id inner join (select * from billing_information where isPrimary =1)i on i.userID = u.id Instead of the * I usually specifilly list only the c... read more »

• Change In ColdFusion Date::getTime() Method In ColdFusion 10

  Posted on Oct 1, 2012 at 6:46 PM

  I only have coldfusion 8 and 9 on this computer so cant test at moment but I believe this has more to do with a change on how coldfusion store time then with a change with the gettime() function. What I mean is in coldfusion 9 and earlier the time zone of the data is not part of the data set. The... read more »