I'm encountering a problem with queries of queries and the like statement:
This works:
<cfquery name="results" dbtype="query">
select *
from assets
WHERE STATUSID = 6
AND ASSETTYPEID = 1
AND WORKSTATIONNAME = 'abcd'
</cfquery>
but this doesn't:
<cfquery name="results" dbtype="query">
select *
from assets
WHERE STATUSID = 6
AND ASSETTYPEID = 1
AND WORKSTATIONNAME LIKE 'abcd'
</cfquery>
(notice the addition of LIKE)
This generates the following 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.
I also tried some variations:
AND WORKSTATIONNAME LIKE 'abcd%'
AND WORKSTATIONNAME LIKE '%abcd'
AND WORKSTATIONNAME LIKE '%abcd%'
AND WORKSTATIONNAME LIKE #preservesinglequotes("'abcd'")#
AND WORKSTATIONNAME LIKE #preservesinglequotes("abcd")#
and wrapping the entire WHERE class in preservesinglequotes
None of which worked.
Help!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
