array.cfc validate issue when editing user groups

Description

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>

Environment

shared hosting, mysql 5

Activity

Frederic Altorfer February 2, 2011 at 11:17 PM

Could only find it in join.cfc. Fixed it there.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created December 28, 2009 at 6:43 PM
Updated February 2, 2011 at 11:17 PM
Resolved February 2, 2011 at 11:17 PM