Case sensitive search error

[mvallevand]

UJB, there seems to be a problem with Match Title/ Case Sensitive searching

I believe you need this logic near line 235 of SearchEngine.cs

Code:

//Check to see if we are matching the title
                    else if (matchTitle)
                    {
                        if (!caseSensitive)
                        {
                            where_cmd += " and UPPER(EPG_EVENT.title) = '" + searchFor + "'";
                        }
                        else
                        {
                            where_cmd += " and EPG_EVENT.title = '" + searchFor + "'";
                        }
                    }

Martin

[UncleJohnsBand]

UJB, there seems to be a problem with Match Title/ Case Sensitive searching

I believe you need this logic near line 235 of SearchEngine.cs

Code:

//Check to see if we are matching the title
                    else if (matchTitle)
                    {
                        if (!caseSensitive)
                        {
                            where_cmd += " and UPPER(EPG_EVENT.title) = '" + searchFor + "'";
                        }
                        else
                        {
                            where_cmd += " and EPG_EVENT.title = '" + searchFor + "'";
                        }
                    }

Martin

Updated to the below....file on the FTP server....

Code:

if (!caseSensitive)
                    {
                        //Check to see if we are searching the start of the title
                        if (startTitle)
                        {
                            where_cmd += " and UPPER(EPG_EVENT.title) like '" + searchFor + "%'";
                        }
                            //Check to see if we are matching the title
                        else if (matchTitle)
                        {
                            where_cmd += " and UPPER(EPG_EVENT.title) = '" + searchFor + "'";
                        }
                        else
                            //we are searching the title
                        {
                            where_cmd += " and UPPER(EPG_EVENT.title) like '%" + searchFor + "%'";
                        }
                    }
                    else
                    {
                        //Check to see if we are searching the start of the title
                        if (startTitle)
                        {
                            where_cmd += " and EPG_EVENT.title like '" + searchFor + "%'";
                        }
                        //Check to see if we are matching the title
                        else if (matchTitle)
                        {
                            where_cmd += " and EPG_EVENT.title = '" + searchFor + "'";
                        }
                        else
                        //we are searching the title
                        {
                            where_cmd += " and EPG_EVENT.title like '%" + searchFor + "%'";
                        }
                    }

[mvallevand]

Thanks, I'll check it in an hour or so. ASCII "like" searches are case insensitive anyway, which is why I skipped that big change, but it is probably more future-proof. l Since this can mess with auto-recordings it might be worth adding the file here.

Martin

[UncleJohnsBand]

Thanks, I'll check it in an hour or so. ASCII "like" searches are case insensitive anyway, which is why I skipped that big change, but it is probably more future-proof. l Since this can mess with auto-recordings it might be worth adding the file here.

Martin

Just dropped another one out there.....the same check needed to be added to subtitle and description......the one on the FTP server now has those areas as well.

Thanks for finding this.

[mvallevand]

UJB, I have taken the liberty of uploading your file here since it is required to run NEWA queries in SearchLite.

To install it backup the file [NPVR Data]\web\App_Code\Classes\SearchEngine.cs and replace with the attached.

Martin

[mvallevand]

UJB, I ran into another logic issue with Exact search matching. You escape the search string to deal with apostrophe's in the string for sqlite but then use it escaped for a check that will fail

Code:

searchFor = HttpUtility.UrlDecode(searchFor).Replace("'", "''");
...
                                if (pgm.Title.IndexOf(searchFor) > -1)
                                {
...

It does work if you unescape it with .Replace("''","'") but I am not sure if that is how you will want to do this.

Martin

[UncleJohnsBand]

UJB, I ran into another logic issue with Exact search matching. You escape the search string to deal with apostrophe's in the string for sqlite but then use it escaped for a check that will fail

Code:

searchFor = HttpUtility.UrlDecode(searchFor).Replace("'", "''");
...
                                if (pgm.Title.IndexOf(searchFor) > -1)
                                {
...

It does work if you unescape it with .Replace("''","'") but I am not sure if that is how you will want to do this.

Martin

Thanks.....attached is the patch.....the issue existed at title, subtitle and description. Also found code preventing genre matching from working because it was still within a loop specific to users with schedulesdirect utilities.....this cleans all of these items up.

[mvallevand]

Thanks UJB that works fine. Although right now I use my own genre logic, are there genre capabilities available via web service?

Martin

[UncleJohnsBand]

Thanks UJB that works fine. Although right now I use my own genre logic, are there genre capabilities available via web service?

Martin

Yes....the web service search object supports genre.