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:

WebCatalog can't find database (1997) EditPlus 2 WebDNA cliptext (2002) why is this line in GeneralStore? (1998) New public beta available (1997) WebDNA v6 & MySQL (2008) [WebDNA] crashes are back (2008) RE: Languages (1997) Authorize.net setup (2002) [WebDNA] .htm files (2008) Date Help (2004) Setting up WebCatalog with Retail Pro data (1996) Opening 'order file'. (1999) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) WebCat2 Append problem (B14Macacgi) (1997) Changing price for a SLU based on options (size, etc.) (1997) Missing Link (2000) [OT] Backup/ failsafe strategies (2003) corrupted jpgs (2003) Package Prices (2000) Location of Webcat site in folder hierarchy (1997)