lines 419-426 in array.cfc cause an error in mysql with incorrect data type comparrisons (double on one side and string on another). The double is because of "1.00" as the seq. Adding quotes around that fixes the problem:
OLD:
<cfquery dbtype="query" name="qCurrentArrayItem"> SELECT * FROM qArrayRecords WHERE data = '#listFirst(i,":")#' <cfif listLast(i,":") NEQ listFirst(i,":")><!--- SEQ PASSED IN ---> AND seq = #listLast(i,":")# </cfif> </cfquery>
NEW:
<cfquery dbtype="query" name="qCurrentArrayItem"> SELECT * FROM qArrayRecords WHERE data = '#listFirst(i,":")#' <cfif listLast(i,":") NEQ listFirst(i,":")><!--- SEQ PASSED IN ---> AND seq = '#listLast(i,":")#' </cfif> </cfquery>
lines 419-426 in array.cfc cause an error in mysql with incorrect data type comparrisons (double on one side and string on another). The double is because of "1.00" as the seq. Adding quotes around that fixes the problem:
OLD:
<cfquery dbtype="query" name="qCurrentArrayItem">
SELECT *
FROM qArrayRecords
WHERE data = '#listFirst(i,":")#'
<cfif listLast(i,":") NEQ listFirst(i,":")><!--- SEQ PASSED IN --->
AND seq = #listLast(i,":")#
</cfif>
</cfquery>
NEW:
<cfquery dbtype="query" name="qCurrentArrayItem">
SELECT *
FROM qArrayRecords
WHERE data = '#listFirst(i,":")#'
<cfif listLast(i,":") NEQ listFirst(i,":")><!--- SEQ PASSED IN --->
AND seq = '#listLast(i,":")#'
</cfif>
</cfquery>