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