Yeah, I think I ran across that one time and had to dig deep to find that. Query of queries is an odd beast, there are a lot of little "gotchas" to be dealt with. Also check out the case sensitivity issue, that got me one time too.
-- Josh ----- Original Message ----- From: "Richard White" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Friday, June 20, 2008 4:42 PM Subject: Re: null pointer? need your expertise! > that did it! > > thanks again Josh, good find, i have been tearing my hair out over that > all night > > thanks again > > > >>Richard, I found this on the CF7 livedocs comments: >> >>============== >>"Null Pointers are another name for undefined values." >> >>If this error is returned when trying to use the LIKE operator it is >>likely >>because there are NULL values in the column in question. Try the following >>variation: >> >><CFQUERY name="aQuery" dbtype="query"> >>SELECT * FROM aQuery >>WHERE aField IS NOT NULL >>AND aField LIKE 'right_string_exp' >></CFQUERY> >> >>The IS NOT NULL clause causes a NULL row to be discounted before the LIKE >>clause is executed. >>================= >> >>-- Josh >> >>> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:307884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
