Query Of Queries runtime error.

[Robert Rawlins]

Hell Guys,

I'm getting the following exception when calling addRelationship() name on an object that has a many-to-many with another.

Comparison exception while executing =.
Unsupported Type Comparison Exception: The = operator does not support comparison between the following types:
Left hand side expression type = "STRING".
Right hand side expression type = "DOUBLE".

It seems to be part of the bean population process that's upsetting things, but I can't fathom why.

Has anyone else has similar issues before? I can give more details on the relationships and full stack trace if that's of help.

Thanks.

Robert

[Robert Rawlins]

I appear to have solved this issue.

It looks to be something to do with me using type="numeric" in transfer, but actually having the column datatype as varchar.

It appears that CF has some clever auto data-type recognition stuff going on behind of QofQ's and this was confusing it.

Robert