Re: AND/OR searches in WebCat 3.07
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49006
interpreted = N
texte = Lot-o-room for [url][/url] problems...DonovanGary Krockover wrote:>>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> >-- -Donovan Brooke-Administrator of IT /-Assc. Art Director-Creative Services-Epsen Hillmer Graphics-402.342.1169 X297-------------------------------------------------------------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:
Lot-o-room for [url][/url] problems...DonovanGary Krockover wrote:>>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> >-- -Donovan Brooke-Administrator of IT /-Assc. Art Director-Creative Services-Epsen Hillmer Graphics-402.342.1169 X297-------------------------------------------------------------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/
Donovan
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:
Opinion: [input] should be called [output] ... (1997)
Opinion: [input] should be called [output] ... (1997)
[WebDNA] TLS 1.2 and [tcpconnect] (2018)
Summary search -- speed (1997)
SAVECART (1997)
WebCatalog/Mac 2.1b2 - PIXO (1997)
email messages (1997)
[Listdatabases] (2000)
Re: (1997)
SSL and reg web*L and reg web* (1997)
Webcat/Webmerchant (1998)
Updating checkboxes made easy !!! (1998)
Upgrade to wsV (2004)
select multiple 2 more cents (1997)
Grouping search fields, etc. (1997)
ListFiles and NT Email Sender 2nd Answer (2000)
Server slowing down. (1997)
Unix webcat perms & multiple versions of same db in cache issue (2000)
RE: Languages (1997)
Redirect in 4.0 (2000)