Tom, I think that is definitely the case. Check out this blog post:
http://www.bennadel.com/index.cfm?dax=blog:144.view I have found that ColdFusion query of queries throws errors on NULL fields when using LIKE, UPPER(), and LOWER(). ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 8:07 AM To: CF-Talk Subject: RE: Head Banging Access LIKE error in QoQ That's closer I think: I DO have empty fields interspersed with populated fields in the column.. Just need to get the syntax right now.. T -----Original message----- From: "Katz, Dov B \(IT\)" [EMAIL PROTECTED] Date: Tue, 7 Nov 2006 12:44:19 +0000 To: CF-Talk [email protected] Subject: RE: Head Banging Access LIKE error in QoQ > Just a guess: > > You might have an empty phototag value somewhere > > Try > > WHERE ("" & phototag) LIKE "%#trim(variables.thistag)#%' > > Or, try ""+phototag (not sure of syntax) > > Does this fix the issue? > > Dov > > > -----Original Message----- > From: Tom King [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 07, 2006 7:30 AM > To: CF-Talk > Subject: Head Banging Access LIKE error in QoQ > > OK, This have been driving me nuts... > > request.photolist exists, and has phototag etc fields. > variables.thistag is also fine: > BUT, this code: > > <cfquery dbtype="query" name="GetTaggedPhotos"> > SELECT * from request.photolist WHERE phototag LIKE > '%#trim(variables.thistag)#%'; > </cfquery> > > Throws this very unhelpful error: > > The system has attempted to use an undefined value, which usually > indicates a programming error, either in your code or some system code. > > Null Pointers are another name for undefined values. > > java.lang.NullPointerException > > Using this works, but obvious doesn't return the same recordset, as > it's looking for an exact match: > <cfquery dbtype="query" name="GetTaggedPhotos"> > SELECT * from request.photolist WHERE phototag = > '#variables.thistag#'; > </cfquery> > > Help??????? > > Ta > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259417 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
