Richard White wrote: > yes i have dumped out the query named mergedColumnsQuery just before i run > the cfquery select statement on that query and it does contain a row with the > data that i am trying to select > > would it have anything to do with column types? > > thanks
Well the first thought I had was can one do "NULL" in a query of query? I wonder because CF does not normally grock 'NULL' and null columns from a database are 'empty strings' in ColdFusion record sets. You might try changing your 'IS NULL' comparisons to = ''. (equal empty string) comparisons. But why the first works with IS NULL and the second doesn't, I do not understand. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308772 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
