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 haveoverlooked something. You didn't have any linebreaks in it which woulddefinitly 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 itcould be (we really need a list of reserved keywords on the interactivedoc's :)You might try changing SearchType to another variable name and see how itgoes.GKTrying 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 serchingI 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 Iselect 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 itdoes 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 isleft 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 2days!--Regards,Marko------------------------------------------------------------------Marko Bernyk - Senior System Engineermailto:marko@conexus.com.au http://www.conexus.com.auTechnical Services, Conexus Pty Ltd, Sydney, AustraliaPh 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:
>From what I can see, the search itself, though long, looks ok. I may haveoverlooked something. You didn't have any linebreaks in it which woulddefinitly 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 itcould be (we really need a list of reserved keywords on the interactivedoc's :)You might try changing SearchType to another variable name and see how itgoes.GKTrying 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 serchingI 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 Iselect 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 itdoes 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 isleft 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 2days!--Regards,Marko------------------------------------------------------------------Marko Bernyk - Senior System Engineermailto:marko@conexus.com.au http://www.conexus.com.auTechnical Services, Conexus Pty Ltd, Sydney, AustraliaPh 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)