2008-11-01, 16:28
I've been developing a remote for XBMC in Flash. I started the project a few months ago, and I'm just getting back to it. It seems that something has changed in the SQL database query processing in XBMC. I am now running Atlantis Beta 2 on the Xbox. The following SQL query used to work as expected, but now it returns every record in my music db (I do use encodeURI() in Flash to convert spaces to %20, but I'm displaying it with spaces for readability):
select song.strTitle, artist.strArtist, path.strPath, song.strFileName from song, path, artist where song.strTitle LIKE '%what%' AND song.idPath=path.idPath AND song.idArtist=artist.idArtist
This should filter results by songs with "what" in the title and return the song title, artist, path, and file name. I've tested the query using SQLite Database Browser and it returns the expected results. And Like I said, this same query string used to return correct results, although it did used to randomly lock up XBMC, which is what ended up discouraging me from continuing.
Any ideas what the problem may be?
select song.strTitle, artist.strArtist, path.strPath, song.strFileName from song, path, artist where song.strTitle LIKE '%what%' AND song.idPath=path.idPath AND song.idArtist=artist.idArtist
This should filter results by songs with "what" in the title and return the song title, artist, path, and file name. I've tested the query using SQLite Database Browser and it returns the expected results. And Like I said, this same query string used to return correct results, although it did used to randomly lock up XBMC, which is what ended up discouraging me from continuing.
Any ideas what the problem may be?