Re: Reactor For CF abstractGateway issue

[Mark Mazelin]

Sean Corfield wrote: On 2/5/06, Mark Mazelin <[EMAIL PROTECTED]> wrote: <cfif arguments.Query.getField(whereNode.object, whereNode.field).length GT 0> allowed me to get around the issue for now, but didn't really solve the problem. Now what is bizzare is that I use the "isEqual()" in the same function and have never seen this issue even though the abstractGateway uses the same logic on line 107. Any idea why the ".length" would return multiple values like this, causing this error? What type of field caused the problem? Is it a numeric field with a precision? What DB are you using? -- Sean A Corfield -- http://corfield.org/ Got frameworks? "If you're not annoying somebody, you're not really alive." -- Margaret Atwood Details, details ;-) I'm running mysql 4.1.16. The field is a decimal with a "Length" of 10 and "Decimals" of zero. Great question--this would be the "10,0" that I'm seeing in the error. With this clue, I changed the field to a "bitint" (since I don't really need the decimals) and wala it fixed it! >From the mytableMetadata.cfc file: BEFORE:         <cfset variables.metadata.fields[5]["cfSqlType"] = "cf_sql_decimal" />         <cfset variables.metadata.fields[5]["length"] = "10,0" /> AFTER:         <cfset variables.metadata.fields[5]["cfSqlType"] = "cf_sql_bigint" />         <cfset variables.metadata.fields[5]["length"] = "20" /> So for now, I think I can live with the bigint field type, but this should be marked as a bug Doug. Thanks, Mark