tracker issue : CF-3043024

select a category, or use search below
(searches all categories and all time range)
Title:

Bug 85498:(Watson Migration Closure)The query returned by cfsearch doesn't properly type the columns

| View in Tracker

Status/Resolution/Reason: Closed/Won't Fix/LowImpact

Reporter/Name(from Bugbase): Raymond Camden / Raymond Camden (Raymond Camden)

Created: 01/04/2011

Components: Text Search, Solr

Versions: 9.0.1

Failure Type: Unspecified

Found In Build/Fixed In Build: 0000 /

Priority/Frequency: Normal / Unknown

Locale/System: English / Platforms All

Vote Count: 1

Problem:

The query returned by cfsearch doesn't properly type the columns. Score, RecordsSearched, and Size, are varchar, which can have issues if you try to sort. See: http://www.coldfusionjedi.com/index.cfm/2011/1/4/Searching-multiple-ColdFusion-SOLR-Collections-at-once
Method:

<CFsearch collection="84068s, 84068s1" criteria="" name="s1">


<cfquery name="newresults" dbtype="query">

 select title, score

  from s1

  order by score desc

  </cfquery>
<cfdump var="#getmetadata(newresults)#" >
Result:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3043024

External Customer Info:
External Company:  
External Customer Name: Raymond Camden
External Customer Email: 5FBC41E943BD265C992015D5
External Test Config: 01/04/2011

Attachments:

Comments: