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:259412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
