AND/OR searches in WebCat 3.07
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49002
interpreted = N
texte = Trying to do an AND/OR searches in WebCat 3.07 Macintosh 9.1 WebStar 4.5.I'm doing this using the '&AllReqd=T' tag.I have 12 fields that need serching I have a option to select AND/OR when submittinghere is the search context[search db=[var_Database_Dir]/testdb.db[hideif [DateDay]=]&eqDateDaydata=[DateDay][/hideif][hideif [DateMonth]=]&eqDateMonthdata=[DateMonth][/hideif][hideif [DateYear]=]&eqDateYeardata=[DateYear][/hideif][hideif [Title]=]&wsTitledata=[Title][/hideif][hideif [Author]=]&wsAuthordata=[Author][/hideif][hideif [Publisher]=]&wsPublisherdata=[Publisher][/hideif][hideif [ISBN]=]&wsISBNdata=[ISBN][/hideif][hideif [WebAddress]=]&wsWebAddressdata=[WebAddress][/hideif][hideif [Source]=]&wsSourcedata=[Source][/hideif][hideif [Category]=]&wsCategorydata=[Category][/hideif][hideif [LectureWeek]=]&wsLectureWeekdata=[LectureWeek][/hideif][hideif [ArticleExtract]=]&wsArticleExtractdata=[ArticleExtract][/hideif]&rank=off&max=[pageMaxSearchItems][showif [var_from]=1]&startat=[from][/showif][showif [SearchType]=and]&AllReqd=T[/showif]]Basically the search works when I select OR and hit submit, but when I select AND, the search fails.I have tested the above search context with a smaller subset of fields (ie: 1 and 2 fields) to test whether the &AllReqd=T actually works ... and it does work. AND and OR searches give me the correct results.So why won't my 12 fields search command not process the AND command (and / or is being sumbitted in value [SearchType] ).There are [hideif] thoughout the search for each field, so if the field is left empty in the submit it is not searched apon.Is there a limitation with the search i'm trying to do with the '&AllReqd=T' ?I'm Sending this on Friday here... so I will not be able to respond for 2 days!-- Regards, Marko ------------------------------------------------------------------ Marko Bernyk - Senior System Engineer mailto:marko@conexus.com.au http://www.conexus.com.au Technical Services, Conexus Pty Ltd, Sydney, Australia Ph 02 9975 2799 Fax 02 9975 2799 :) ------------------------------------------------------------------------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Trying to do an AND/OR searches in WebCat 3.07 Macintosh 9.1 WebStar 4.5.I'm doing this using the '&AllReqd=T' tag.I have 12 fields that need serching I have a option to select AND/OR when submittinghere is the search context[search db=[var_Database_Dir]/testdb.db[hideif [DateDay]=]&eqDateDaydata=[DateDay][/hideif][hideif [DateMonth]=]&eqDateMonthdata=[DateMonth][/hideif][hideif [DateYear]=]&eqDateYeardata=[DateYear][/hideif][hideif [Title]=]&wsTitledata=[Title][/hideif][hideif [Author]=]&wsAuthordata=[Author][/hideif][hideif [Publisher]=]&wsPublisherdata=[Publisher][/hideif][hideif [ISBN]=]&wsISBNdata=[ISBN][/hideif][hideif [WebAddress]=]&wsWebAddressdata=[WebAddress][/hideif][hideif [Source]=]&wsSourcedata=[Source][/hideif][hideif [Category]=]&wsCategorydata=[Category][/hideif][hideif [LectureWeek]=]&wsLectureWeekdata=[LectureWeek][/hideif][hideif [ArticleExtract]=]&wsArticleExtractdata=[ArticleExtract][/hideif]&rank=off&max=[pageMaxSearchItems][showif [var_from]=1]&startat=[from][/showif][showif [SearchType]=and]&AllReqd=T[/showif]]Basically the search works when I select OR and hit submit, but when I select AND, the search fails.I have tested the above search context with a smaller subset of fields (ie: 1 and 2 fields) to test whether the &AllReqd=T actually works ... and it does work. AND and OR searches give me the correct results.So why won't my 12 fields search command not process the AND command (and / or is being sumbitted in value [SearchType] ).There are [hideif] thoughout the search for each field, so if the field is left empty in the submit it is not searched apon.Is there a limitation with the search i'm trying to do with the '&AllReqd=T' ?I'm Sending this on Friday here... so I will not be able to respond for 2 days!-- Regards, Marko ------------------------------------------------------------------ Marko Bernyk - Senior System Engineer mailto:marko@conexus.com.au http://www.conexus.com.au Technical Services, Conexus Pty Ltd, Sydney, Australia Ph 02 9975 2799 Fax 02 9975 2799 :) ------------------------------------------------------------------------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Marko Bernyk
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Summing fields (1997)
Sorting by highest number of matches unique to a field (2003)
Understanding texta (1997)
4.0.2b4 (2000)
[OT] Google Info (2004)
Help! WebCat2 bug (1997)
WebCat chatroom/hyperboard (1997)
Locking up with WebCatalog... (1997)
How do I get Google to crawl a WebCat site? (2003)
time format (2005)
Counting records (2000)
Calculating multiple shipping... (1997)
PSC recommends what date format yr 2000??? (1997)
F3 crashing server (1997)
Don't tick me off :) [elaspedtime] (1997)
Re:2nd WebCatalog2 Feature Request (1996)
japanese characters (1997)
Not really WebCat (1997)
WebCat for Unix?? (1997)
[format xs] freeze (1997)