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