Okay - correct me if I've missed the point here. But I think we've come at cross purporse (we being cfug-list)
What I THINK you seem to want to do is determine if a value passed back from a query is what would be referred to as NULL within the database - specifically when dealing with outer joins and the like? When getting back a query object with 'null' values from a database, coldfusion just processes them as empty strings - so you can compare them to "" and find out if they are 'null' that way. Just got to remember that 'NULL' for a DB is different for 'NULL' for CF, Am I wrong in what you are looking for? Mark > Andrew Dickinson <[EMAIL PROTECTED]> wrote: > > Okay, I'll have a go at this one from a different angle. > > In the thread below, I asked how to read NULL as an explicit value in > CF. > Given that CF can't do this, comments please if this is a better > approach. > > Suppose I have two tables, table1 and table2. The key records in > table2 > are a subset of the key records of table1. I want to increment an > array > counter for every instance of the key record in table1 NOT being in > table2, and to increment a different array for the values in common. > > I wanted to manage this all in the one CFQUERY, but it appears I'll > need > two of them. The following is pseudocode. > > CFQUERY CountNulls > (Left/Right Join table1 and table2) > (Where result is null) > > CFQUERY CountOthers > (Left/Right Join table1 and table2) > (Where result is not null) > > CFLOOP CountNulls > Increment CountNullsArray[x] > > CFLOOP CountOthers > Increment CountOthersArray[x] > > There are several other layers of this program, which is why I'm > using > arrays rather than single variables, but this is the portion I need > to > solve, in order to make the program run faster. > > Is this the most straightforward method ? Is there no way to achieve > this > in a single query ? > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ ----------------------------------- [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [www.safefrombees.com] --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
