Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:
Attach:
(Clear Attachment)
(more attachments)
Allowed file types: gif, jpg, png, txt, tpl, lng, ini, pvd, psf, ini, cfg, csv, zip, xml, pas, 7z
Restrictions: 4 per post, maximum total size 1024KB, maximum individual size 1024KB
Note that any files attached will not be displayed until approved by a moderator.
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:
What is the fifth word in this sentence?:

shortcuts: hit alt+s to submit/post or alt+p to preview


Topic Summary

Posted 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   ???

Posted 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.
Posted 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



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
Posted 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.
Posted 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
Posted by: nostra
« on: September 17, 2010, 02:21:53 pm »

So how exactly does the advanced search look like producing this error?
Posted 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: