Title:
Bug 83347:(Watson Migration Closure)When a query result contains a string that looks like a date, and you run a query of queries looking for records that match that string, an equal sign will not work
| View in TrackerStatus/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): dan bracuk / dan bracuk (Dan Bracuk)
Created: 06/14/2010
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Minor / Unknown
Locale/System: English / Win All
Vote Count: 1
Problem:
When a query result contains a string that looks like a date, and you run a query of queries looking for records that match that string, an equal sign will not work. The sql keyword "like" can be used as a workaround.
Method:
This occurs with any database query and also with cold fusion queries. Here is an example.<cfscript>q = QueryNew("s","varchar");x = QueryAddRow(q, 1);x = QuerySetCell(q, "s", "2010-06-10");</cfscript>This query will not return any rows.cfquery name="z" dbtype="query">select s from qwhere s = '2010-06-10'</cfquery>This query will retun one row:<cfquery name="zz" dbtype="query">select s from qwhere s like '2010-06-10'</cfquery>
Result:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3041655
External Customer Info:
External Company:
External Customer Name: dan bracuk
External Customer Email: 230864C34456071E9920157F
External Test Config: 06/14/2010Attachments:
Comments: