While you're right that CF doesn't understand NULLs, Java RecordSet objects (or RowSet objects) do, and that's what backs a CF query object. So the data's there, just CF can't access it. QofQ's are the exception, because they operate on the backing object directly, not via the CFML API, and so can figure out what's NULL and what's not.
Easiest solution, if you ask me, is still to just ensure you're selecting at least one numeric column, and check that for the empty string, since that'll definitely mean NULL. cheers, barneyb On 12/28/05, Claude Schneegans <[EMAIL PROTECTED]> wrote: > >>A QoQ with an IS NULL condition correctly returns rows with a null in > the column in CF 6.1 > > Hmmm, since AFAIK CF doesn't know the difference between a NULL and an > empty column in a query, > I'm not sure if it "correctly returns rows with a null in the column" > or if it "uncorrectly returns rows with an empty sting in the column" ;-/ > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227839 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
