Try: LEN(RTRIM(LTRIM(my_integer_column))) = 0 On Tue, Jul 8, 2008 at 4:01 PM, Richard White <[EMAIL PROTECTED]> wrote:
> 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:308786 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4