Quoting Mark Harrison:

Quote:
No progress.  But if you email me a backup of your collection, minus the covers, I'd be happy to take another crack at it.

Just saw your response this minute.  Not sure how I missed it.

Anyway, file has been e-mailed.

Thanks.

Quoting Astrakan:

Quote:
Quoting Mark Harrison:

Quote:
It's been a long time since I've looked at the code, but as I recall, we don't currently have access to the headshot data. So I have don't have an easy way to create that query.  But if the new SDK coming someday supports it, I'll add it.

I had a feeling that might be the case when I made the request. Thanks for keeping it in mind though. Here's to the new SDK coming sooner rather than later.

KM

Yeah, that'd be a sweet addition for those of us gathering headshots.  Bang for the buck is great---I love when I add a headshot and it's someone in 43 profiles!

I'm not getting the error above but I am having a small problem in that the collection number 'find gaps' query is also finding the duplicates.


When I check each one individually I find that 111, 112 and 236 are duplicates and 1477, 1478 and 1479 are missing. 

Not a big deal, just thought I'd let you know.

I backed up just my Wishlist (615 profiles), restored it, and ran the query and it worked fine.

I'll do some more testing.

Quoting hal9g:

Quote:
I backed up just my Wishlist (615 profiles), restored it, and ran the query and it worked fine.

I'll do some more testing.

Maybe restore each separate list? Wish/Order/Own? see if only one causes it? You're probably already thinking that though, or have already done it...

I don't know that error.  What's it mean translated into English?

I'm sure you're right. invalid is better. I'll try your idea, but it will take some time. thanks

Hi, a few questions about Database Query.

First, thanks for the plugin, works well.  But I was wondering if you could give me advice on how to make use of it for very specific searches :

1).  I have a fairly large number of unwatched DVDs.  When I have time to watch a DVD, I generally want to watch the longest DVD I can in the time allotted.  I can use DB Query to search for Running Times over 120 mins for instance, but how do I tell it to list the longest movies first?  When I click on the results bar at the end to sort, it does sort correctly by hour but not by minute.  For instance, the movies which are 2+hours are all grouped together with no sorting within the group.  So the first one may be 2hr3 mins and the very next may be 2hr59 mins.

2).  How do I do combo queries?  Really what I want is for DB Query to come back and tell me "the longest movie you have not yet watched is......<result>"  And list all the movies by Running Time.  Then I can pick the longest movie I feel like watching given the amount of time I happen to have.

3).  Once I have caught up and watched everything at least once, then I would want to change my query to be, "give me the movies over 2 hours which has been the longest time since I have last watched them".

4).  How do I add additional fields to it?  If I want to find all of my Dragon Dynasty DVDs, I used to search on Studio.  With the new 3.5.1 Media Companies field, I now get very few hits.  How do I add Media Companies as a searchable field?


Thanks,
R.