Reply to thread

Message

<blockquote data-quote="hkjensen" data-source="post: 1130798" data-attributes="member: 52267">Movie with filename &quot;C'est Pas Moi, Je Le Jure! (2008).mkv&quot; get imported and saved as &quot;\C''est Pas Moi, Je Le Jure! (2008)&quot; in table filesWhen movie is selected in MP (view: title index) Mp can't find file &quot;C''est Pas Moi, Je Le Jure! (2008).mkv&quot;Also for GetMovieTitlesByGenreThe query should be changed to :&nbsp; var query = (from sql in _connection.movieinfoes&nbsp; join s3 in _connection.genrelinkmovies on sql.idMovie equals s3.idMovie&nbsp; join s4 in _connection.genres on s3.idGenre equals s4.idGenre&nbsp; where s4.strGenre == strGenre&nbsp; orderby sql.strTitle ascending&nbsp; select sql).ToList();The all movies with f.ex genre &quot;Horror&quot; get listet and not only movies with only genre &quot;Horror&quot;sql.strGenre = &quot;Horror / Sci-Fi&quot; dos not get selected with current querywhere sql.strGenre == strGenre //|| sql.strGenre.Contains(strGenre) //like?The Contains(strGenre) could work but using the genrelinkmovies should be faster</blockquote>

[QUOTE="hkjensen, post: 1130798, member: 52267"] Movie with filename "C'est Pas Moi, Je Le Jure! (2008).mkv" get imported and saved as "\C''est Pas Moi, Je Le Jure! (2008)" in table files When movie is selected in MP (view: title index) Mp can't find file "C''est Pas Moi, Je Le Jure! (2008).mkv" Also for GetMovieTitlesByGenre The query should be changed to : var query = (from sql in _connection.movieinfoes join s3 in _connection.genrelinkmovies on sql.idMovie equals s3.idMovie join s4 in _connection.genres on s3.idGenre equals s4.idGenre where s4.strGenre == strGenre orderby sql.strTitle ascending select sql).ToList(); The all movies with f.ex genre "Horror" get listet and not only movies with only genre "Horror" sql.strGenre = "Horror / Sci-Fi" dos not get selected with current query where sql.strGenre == strGenre //|| sql.strGenre.Contains(strGenre) //like? The Contains(strGenre) could work but using the genrelinkmovies should be faster [/QUOTE]

Verification