Title:
Bug 87150:-(Watson Migration Closure)<cfscript> qry = QueryNew(""); col1 = ["this doesn't bother me", "this one does"]; queryAddColumn(qry, "col1", col1); </cfscript> <cfquery dbtype="query" name="q"> SELECT* FROMqry WHEREcol1 NOT LIKE '
| View in TrackerStatus/Resolution/Reason: Closed/Won't Fix/LowImpact
Reporter/Name(from Bugbase): Steve Onnis / Steve Onnis (Steve Onnis)
Created: 10/24/2011
Versions: 9.0.1
Failure Type: Unspecified
Found In Build/Fixed In Build: 9,0,1,274733 /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Platforms All
Vote Count: 0
Problem:
<cfscript>
qry = QueryNew("");
col1 = ["this doesn't bother me", "this one does"];
queryAddColumn(qry, "col1", col1);
</cfscript>
<cfquery dbtype="query" name="q">
SELECT*
FROMqry
WHEREcol1 NOT LIKE '%doesn''t%'
</cfquery>
<cfdump var="#q#">
---------------------------------------------------------------
Running the above code will return both rows in the recordset where the query indicates that we are trying to exclude the record with the word "doesn't" in it.
Method:
Result:
Query of Query does not recognise "LIKE" clauses with an escaped single quote in the value
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3086154
External Customer Info:
External Company:
External Customer Name: Steve Onnis
External Customer Email: 6B4F6ECA439559160AAC0C16
External Test Config: 10/24/2011Attachments:
Comments: