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:

    
  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)
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)