Hi Ernst,
I don't know about those date searches. Maybe we can look into that later.
As for gallery searches: If you don't like SQL, a possible workaround is that you simply assign a unique keyword to all the files in that gallery, and then do a regular search for that keyword, plus your additional search criteria.
If you prefer an SQL method, I will copy 2 very old but relevant messages below from the old Cerious Newsgroups. They come without their original context (otherwise I'd have to copy and paste whole threads), but the information contained in them could still be helpful, I think.
Regards,
-Daan-
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=[ 1 ]=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
From: "Jose G. Filippa" <
jose@cerious.com>
Newsgroups: cerious.support
Subject: Re: Thumbsplus 7.0 problem with gallery search
Date: Fri, 14 Apr 2006 10:14:46 -0300
Hi Chris,
In order to find those thumbnails which are included in at least one gallery
or sub-gallery but are not included in a specific gallery you should use the
following SQL statement:
tn.idThumb in (select gt.idThumb from GalleryThumb as gt) and tn.idThumb not
in (select GalleryThumb.idThumb from GalleryThumb inner join Gallery on
GalleryThumb.idGallery=Gallery.idGallery where Gallery.name like 'UF\%')
Now for a set of galleries and sub-galleries you should use:
tn.idThumb in (select gt.idThumb from GalleryThumb as gt) and tn.idThumb not
in (select GalleryThumb.idThumb from GalleryThumb inner join Gallery on
GalleryThumb.idGallery=Gallery.idGallery where Gallery.name in
('UF\Gallery1','Temp'))
(Note that you can not use wildcards when using the "in" operator.)
Or if you really need to use wildcards:
tn.idThumb in (select gt.idThumb from GalleryThumb as gt) and tn.idThumb not
in (select GalleryThumb.idThumb from GalleryThumb inner join Gallery on
GalleryThumb.idGallery=Gallery.idGallery where (Gallery.name like 'UF\%' or
Gallery.name like 'Temp%'))
By the way, your query (the one that hung your ThumbsPlus) worked OK in
ThumbsPlus in my system. I will continue investigating about this issue.
Best regards,
José G. Filippa
Cerious Software
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=[ 2 ]=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
From: Uwe Zimmermann <uwezi@/no_mail/sciencetronics.com>
Newsgroups: cerious.support
Subject: Re: Search Gallery
Date: Mon, 01 Nov 2004 12:56:16 +0100
Until galleries finally work like normal directories, you should be
able to use the additional SQL query:
this is for one specific gallery "galleryname"
-----------------------------------------------
exists (select idThumb from gallerythumb gt inner join gallery
ga on gt.idGallery = ga.idGallery where ga.name = 'galleryname' and
gt.idThumb = tn.idThumb)
this is for images in any gallery
-----------------------------------------------
exists (select idThumb from gallerythumb gt where
gt.idThumb = tn.idThumb)
Uwe.
Recent Posts