Hi Ian, yes i did start off comparing with empty strings - like where xx = "" but i wont always know the data type of the column and therefore i get an error if the column data type is an integer for example, so i thought that by adding 'is null' will then work for all column types.
if anyone sees a better way of doing this and that this may be unreliable i will appreciate it, as i dont know how else to compare an integer column with no data? thanks > 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:308784 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
