RE: [cfaussie] ORMExecuteQuery error on CF10

2014-06-12 Thread Charlie Arehart
sie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Stephen M Sent: Wednesday, June 11, 2014 3:22 AM To: cfaussie@googlegroups.com Subject: [cfaussie] ORMExecuteQuery error on CF10 I get the following error back as an element of the array returned from an ORMExecuteQuery "[u

Re: [cfaussie] ORMExecuteQuery error on CF10

2014-06-11 Thread Dmitry Yakhnov
Hi Stephen, Usually [undefined array element] error is referring to NULL value: 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 (display or dump). And probably CF9 convert is smart enough to conve

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 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? T

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 ar

[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