On Thu, 15 Oct 2009 13:15:01 -0700 (PDT), Sumit Verma <[email protected]> wrote: > When using this with ORM in CF9, unless you have default values > defined for the item, method returns null, in which case "value" > becomes undefined. IMHO, CF should not wipe out the variables but let > the value be "undefined", but CF doesn't really have a concept of > "null" or "undefined".
I have a feeling we're going to run into a few issues here and there like this based on the completely idiotic way CF treats nulls, and unfortunately this "behavior" (bug, really) has been cemented into the ORM functionality. When something is null the variable shouldn't disappear. That's a completely stupid way of handling things. But, here we are. :-) Just so everyone's aware of the issue, it's a bit hairier than you outline with your solution (but thanks for proposing a solution--much appreciated!). CF 8 and CF 7, which we're still supporting with Mach-II 1.8, don't have IsNull(). OpenBD has IsNull(), and has had it for a long time, but it behaves "differently" (ahem, correctly) as compared to CF 9. The compatibility issue between CF and OpenBD (not sure what Railo does; I suspect they implemented the CF bug for the sake of compatibility) is that null values don't become undefined in OpenBD like they do in CF. So unfortunately we may have to do a bit of engine-specific checking in this particular case, but we'll have to dig into that further. Thanks for the heads up on this. Hopefully we don't run into too many more issues like this, but we'll see now that CF 9 is out in the wild. -- Matthew Woodward [email protected] http://mpwoodward.posterous.com identi.ca/Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to Mach-II for CFML list. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/mach-ii-for-coldfusion?hl=en SVN: http://greatbiztoolsllc.svn.cvsdude.com/mach-ii/ Wiki / Documentation / Tickets: http://greatbiztoolsllc.trac.cvsdude.com/mach-ii/ -~----------~----~----~----~------~----~------~--~---
