for MX. In CF5 there may also have been a bug due to using mixed case
IIRC there is a technote which contains more details
Kola
-----Original Message-----
From: Suyer, Ed [PRD Non-J&J] [mailto:[EMAIL PROTECTED]
Sent: 08 October 2003 23:12
To: CF-Talk
Subject: QoQ and Like
Hi Folks,
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]
