Well, in this case, I think it is giving the error based on an unsuccesful search of the dataset. The null pointer is simply saying there is 0 records that match your search term. So say your search term is "foo" and the record in the previous query is "foo", what do you get?
Doug B. Doug ----- Original Message ----- From: "Tom King" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, November 07, 2006 5:30 AM 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:259411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
