Or an easier way to explain it is that CF doesn't convert NULLs to empty strings until it outputs them or uses them in an operation.
Ade -----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 29 December 2005 04:21 To: CF-Talk Subject: Re: How to test for null in a query object 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:227849 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
