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:
carriage returns in data (1997)
pc (1997)
Error.html (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Separate SSL Server (1997)
combine search (1998)
[spawn] and [formvariables] (1999)
HTML Editors (1997)
Credit card processing - UK (1997)
About Include (2001)
searching with if/then (2004)
[WebDNA] Record click-thrus (2008)
searchable list archive (1997)
WebCat2 - [format thousands] (1997)
OT: Digger (2007)
Re:Hideif / Showif (1998)
Include a big block of text (1997)
Db design question (relational vs. flat?) (1998)
Emailer tracking (1997)
Beta 18 (1997)