Re: AND/OR searches in WebCat 3.07

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 49005
interpreted = N
texte = >From what I can see, the search itself, though long, looks ok. I may have overlooked something. You didn't have any linebreaks in it which would definitly cause problems in here, but to be safe, and for viewing purposes, you can put it in your page like this:[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]]Just in case the text is wrapping.My guess is the very last line, obviously.Make sure SearchType is passing what you think it is, [showif [SearchType]=and] Yup, equals AND [/showif]Also, is SearchType a reserved keyword? I don't know, but seems that it could be (we really need a list of reserved keywords on the interactive doc's :)You might try changing SearchType to another variable name and see how it goes.GK 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&m ax=[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:

    
  1. Re: AND/OR searches in WebCat 3.07 (Marko Bernyk 2003)
  2. Re: AND/OR searches in WebCat 3.07 (Tim Robinson 2003)
  3. Re: AND/OR searches in WebCat 3.07 (Donovan 2003)
  4. Re: AND/OR searches in WebCat 3.07 (Gary Krockover 2003)
  5. Re: AND/OR searches in WebCat 3.07 (Stuart Tremain 2003)
  6. AND/OR searches in WebCat 3.07 (Marko Bernyk 2003)
>From what I can see, the search itself, though long, looks ok. I may have overlooked something. You didn't have any linebreaks in it which would definitly cause problems in here, but to be safe, and for viewing purposes, you can put it in your page like this:[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]]Just in case the text is wrapping.My guess is the very last line, obviously.Make sure SearchType is passing what you think it is, [showif [SearchType]=and] Yup, equals AND [/showif]Also, is SearchType a reserved keyword? I don't know, but seems that it could be (we really need a list of reserved keywords on the interactive doc's :)You might try changing SearchType to another variable name and see how it goes.GK 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&m ax=[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/ Gary Krockover

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:

RAM variables (1997) Country & Ship-to address & other fields ? (1997) Encrypt broken on Mac 3.05b13?? (2000) Showing unopened cart (1997) Ship Cost Not working (2000) emailer error 452 (2001) wo search help (1999) Running _every_ page through WebCat ? (1997) triggers.db (1999) Help! WebCat2 bug (1997) Example Search Form (1997) Fun with Dates - finally resolved but.... (1997) Ampersand (1997) date formatting for CC card expiration date check (1998) Browsername (1998) WebCatalog for Mac 2.0.1 Released (1997) NT Manual (1997) searchable list archive (1997) Shopping cart problem (2003) Multiple fields on 1 input (1997)