Fog Creek Software
Discussion Board




Search finds Closed cases when it shouldn't.

It's sporadic, but some searches don't seem to care that the "Also search closed cases" option is not checked, and searches them anyway.

Mike Paddock
Saturday, October 11, 2003

Are they cases that were closed at one time and then reopened?

Michael H. Pryor
Monday, October 13, 2003

Nope.  These are definitely closed inquiries (email submissions), and they were never reopened.

Mike Paddock
Monday, October 13, 2003

Next time it happens, remember the search term... Then you can add a print out during the search and figure out either a) what's wrong with your database or b) what's wrong with the sql query being generated.

Michael H. Pryor
Tuesday, October 14, 2003

In GetSQLSearchFull in the CBugList.asp file, change this line

        If g_fMSSQL Then
            sTitle = " SELECT TOP 50 ixBug FROM Bug where sTitle LIKE ? OR (Bug.ixBug = " & ixBug & ") "

to

        If g_fMSSQL Then
            sTitle = " SELECT TOP 50 ixBug FROM Bug where (sTitle LIKE ? OR Bug.ixBug = " & ixBug & ") "

Michael H. Pryor (fogcreek)
Thursday, November 13, 2003

*  Recent Topics

*  Fog Creek Home