Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
hyper.escape
Posted - 12 May 2009 : 09:36:28 Hello All,
I have around 500 movies in various formats on my harddisk. I have updated all the data correctly from the internet using the IMDB (complete) script.
Then I updated around 5000 actors data from the internet again using the IMDB (actors) script.
Now the Movie and Actors database are complete , I wanted to search for all the movies for a specific actor, which unfortunately is not working. I search for actor A and found only one movie in my database, whereas there are around 3 movies.
Upon investigation I found that the reason is in a number of Movie Records in the movies database, the complete list of actors is not imported. Secondly the Actor ID coloumn is blank in the Movie Database for a number of movies.
Since the Actor search function looks for the Actor ID(Numerical) in all Movie Records, it can only find the actor where the Actor ID is filled.
Is there a way now to fill the Actor IDs in the movie database records where they are missing.
Or maybe is there a way to search for Actors by their 'Names (Text)' instead of 'Actor ID (Numerical)'.