There seems to be a potential bug in ColdFusion 2021 Query of Queries.
Today I ran into this error:
Index 5 out of bounds for length 5 null
The index bounds will change based on the number of columns in the query as explained below.
This error was being thrown in a very basic QoQ:
<cfquery name="qUser" dbtype="query"> SELECT * FROM qUsers WHERE User_ID = <cfqueryparam value="#user_id#" cfsqltype="cf_sql_numeric"> </cfquery>
While Investigating the source for the original qUsers
query I noticed two columns with the same name:
Looking a little deeper I found that the original qUsers
query was being ordered via a QoQ prior to the QoQ throwing the error:
<cfquery name="qUsers" dbtype="query"> SELECT * FROM qUsers ORDER BY payroll_name </cfquery>
So essentially a query of a query of a query.
The problem appears to be that ColdFusion is case-sensitive and for some reason adds the ORDER BY
column to the query resulting in a query that has two columns with the same name.
The solution was to change the ordering QoQ to match the case of the original qUsers
query:
<cfquery name="qUsers" dbtype="query"> SELECT * FROM qUsers ORDER BY PAYROLL_NAME </cfquery>
I recently installed Nodeclipse for developing Node.js. Nice little editor with some code hinting and quick Node run command.
Due to my development requirements (and laziness) I wanted to work with the remote JS files using FTP. Nodeclipse does not support FTP out of the box. Enter “Remote System Explorer” for Eclipse.
The plugin installed easily. I entered my connection details. The console started showing my connection status and directory listings. However, attempting to explore the FTP site resulted in a generic “file system input or output error” and/or “java.net.SocketException”.
After some searching I found that the issue actually lies with the underlying Java VM used by Eclipse (Nodeclipse). I’d upgraded to JRE7 and there seems to be a bug in this release that causes an incompatibility with Eclipse.
I changed my shortcut to force Nodeclipse to use an install of JRE6 BIN folder.
eclipse.exe -vm "C:\Program Files\Java\jre6\bin"
NOTE: Ensure you are using the appropriate architecture (32-bit OR 64-bit) when matching JRE6 to Eclipse
Went digging around for ways to view the active connections in Microsoft SQL 2008. To my surprise Microsoft moved the Activity Monitor. Apparently they did this way back in SQL 2005. I skipped 2005 so I missed that. To view the open connection:
Simple as that!
An information technology professional with twenty three years experience in systems administration, computer programming, requirements gathering, customer service, and technical support.