That's strange... the syntax works ok for me
if phototag is a valid column and there are records in
request.photolist then it is a bit of a weird one...not much help I
know but just letting you know the syntax works here
On 11/7/06, Katz, Dov B (IT) <[EMAIL PROTECTED]> wrote:
> 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:259410
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
