[cfaussie] ORMExecuteQuery error on CF10

2014-06-11 Thread Stephen M
I get the following error back as an element of the array returned from an ORMExecuteQuery [undefined array element] Element 4 is undefined in a Java object of type class coldfusion.runtime.Cast$1. This is on my local dev box which has CF10. But, on production which runs CF9, the same code

Re: [cfaussie] ORMExecuteQuery error on CF10

2014-06-11 Thread Jack Traynor
Hi Steve, I haven't had the chance to use ORM yet so I can't be sure... but this looks very similar to an error I had where a function was returning a Java array object instead of a ColdFustion array object. To fix the problem I was having I declared an new empty array then looped of the java

Re: [cfaussie] ORMExecuteQuery error on CF10

2014-06-11 Thread Stephen M
Nice to hear from you Jack. How's things? Anyway, the thing is that I expect ORM to handle all its own declarations. The array was returned by the ORMexecuteQuery() which is a query on an ORM entity, so why is one element left undefined? And why does the same data and code work fine in CF9?

Re: [cfaussie] ORMExecuteQuery error on CF10

2014-06-11 Thread Jack Traynor
Things are good Steve. Hope you are well. Feel free to flick me an email outside of cfaussie if you want to chat. :) I see now, I think I misunderstood the problem due to my lack of ORM knowledge. Sorry I couldn't be of more help. Good luck figuring it out, hopefully someone else of CFAussie has

Re: [cfaussie] ORMExecuteQuery error on CF10

2014-06-11 Thread Dmitry Yakhnov
Hi Stephen, Usually [undefined array element] error is referring to NULL value: cfset a = [1, 2, 3, javaCast(null, true), 5] / cfdump var=#a# abort I am not an expert on ORM, but probably CF is expecting small_int while database has null value, so CF holds null until you want to use it