Hi
I'm experiencing some kind of issue. I wanted to upgrade our servers to coldfusion 11. Before process i upgraded one of our servers (good move) and what i have noticed (exept authentication issues)
when i execute query:
sort = createObject("java", "java.util.LinkedHashMap").init();
sort['FIELD6'] = -1;
sort['FIELD5'] = -1;
DBcol1.query()
.$eq("FIELD1",0).$eq("FIELD2",false).$ne("FIELD3",true)
.$eq("FIELD4",true).$GT("FIELD5",5)
.find(sort=sort,limit=7);
i get query
{ "FIELD1
" : 0 , "FIELD2
" : false , "FIELD3
" : { "$ne" : "true"} , "FIELD4
" : true , "FIELD5
" : { "$gt" : "5"}}
and it should be
{ "FIELD1
" : 0 , "FIELD2
" : false , "FIELD3
" : { "$ne" : true} , "FIELD4
" : true , "FIELD5
" : { "$gt" : 5}}
Everywhere exept $eq it casts all types to string. i could JavaCast all Booleans, Integers and so on, but it would take ages in my project. Any idea what I'm doing wrong or there is some kind of bug with cf11 and cfmongodb. I need to underline that this code works perfectly in CF9 & CF10.
Have issue also with inserts. most of the values are casted to strings (not all of them). Don't have any simple example right now.
Regards
Michal