Personal Video Database

English => Support => Topic started by: korbenPL on September 17, 2010, 12:41:56 pm

Title: SQL Error
Post by: korbenPL on September 17, 2010, 12:41:56 pm

What I was trying to accomplish is here:

http://www.videodb.info/forum_en/index.php?topic=1825.0

and the result is here:

(http://imgur.com/mSyEA.png)

Title: Re: SQL Error
Post by: nostra on September 17, 2010, 02:21:53 pm

So how exactly does the advanced search look like producing this error?

Title: Re: SQL Error
Post by: korbenPL on September 17, 2010, 02:28:05 pm

1] I filter the DB to get this:
http://i44.tinypic.com/1hd08l.png

2] I use the adv search as suggested, then click on containing and select = from the popup, enter "In Collection" into the edit box.

3] when I hit 'OK"  the error appears

Title: Re: SQL Error
Post by: rick.ca on September 17, 2010, 06:33:50 pm

I think what nostra is asking you for is, what exactly is the Advanced search query that is causing the error? Please attach a screen shot of the search dialog.

Advance search should work properly, but you could use a different technique for selecting records (for any purpose)...Select all the records in one group and bookmark them, then filter by bookmarks.

Title: Re: SQL Error
Post by: korbenPL on October 03, 2010, 12:16:57 pm

What I've been trying to achieve is exactly described in the thread link I had posted, so it's

(http://i39.tinypic.com/mczxbc.png)

For the first time ever tried the trick with Bookmarking all of my Owned movies, then using the Filters I choose: Bookmarked and I can view all of my own DVDs,

then back to the issue of getting the actual statistics... the same error appears on my screen.

Help, please

Title: Re: SQL Error
Post by: rick.ca on October 03, 2010, 05:44:10 pm

Should that not be Collection Status = In Collection? And why is there a second blank condition?

Advanced search does not do much in the way of error catching. If there are errors in your query, you'll get a SQL error.

Title: Re: SQL Error
Post by: korbenPL on October 04, 2010, 06:25:40 am

Definitely, I add =
I removed second blank condition
All I get is the SQL error seen in post#1   ???