Re: AND/OR searches in WebCat 3.07

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 49085
interpreted = N
texte = Thanx all who helped me.It really wasn't the [search...] code that was wrong, but the way the data was presented in the database (multiple data in a field). Becuase I am using that are checkboxes, it complicated the isses of a search as checkboxs items not selected were still passed as empty and the [search...] had &eqFieldnamedata=[fieldname] instead of &eqFieldnamedata=input. I had to split the data in the databases and create some check variables for empty data that I did not want to appear in the [search...]Here is a tip: If you want to know what your [search...] is doing copy the whole [search...] and paste it above the REAL search and just rename the copy from [search...] to [s earch...]. Buy putting the space in the [s earch...], webcatalog/webdna will not parse it as a [serach...] but display it as text.here is my solution that works correctly:[text]var_Source=[/text] [text]var_Category=[/text] [text]var_LectureWeek=[/text][formvariables] [index]: [name]=[value]
[showif [name]~Source][text]var_Source=[var_Source] [Name][/text][/showif] [showif [name]~Category][text]var_Category=[var_Category] [Name][/text][/showif] [showif [name]~LectureWeek][text]var_LectureWeek=[var_LectureWeek] [Name][/text][/showif] [/formvariables]
[search db=[var_Database_Dir]/mkt525.db[!] [/!][showif [DateDay]!]&eqDateDaydata=[DateDay][/showif][!] [/!][showif [DateMonth]!]&eqDateMonthdata=[DateMonth][/showif][!] [/!][showif [DateYear]!]&eqDateYeardata=[DateYear][/showif][!] [/!][showif [Title]!]&wsTitledata=[Title][/showif][!] [/!][showif [Author]!]&wsAuthordata=[Author][/showif][!] [/!][showif [Publisher]!]&wsPublisherdata=[Publisher][/showif][!] [/!][showif [ISBN]!]&wsISBNdata=[ISBN][/showif][!] [/!][showif [WebAddress]!]&wsWebAddressdata=[WebAddress][/showif][!] [/!][showif [var_source]^Source01]&eqSource01data=[Source01][/showif][!] [/!][showif [var_source]^Source02]&eqSource02data=[Source02][/showif][!] [/!][showif [var_source]^Source03]&eqSource03data=[Source03][/showif][!] [/!][showif [var_source]^Source04]&eqSource04data=[Source04][/showif][!] [/!][showif [var_source]^Source05]&eqSource05data=[Source05][/showif][!] [/!][showif [var_source]^Source06]&eqSource06data=[Source06][/showif][!] [/!][showif [var_source]^Source07]&eqSource07data=[Source07][/showif][!] [/!][showif [var_source]^Source08]&eqSource08data=[Source08][/showif][!] [/!][showif [var_source]^Source09]&eqSource09data=[Source09][/showif][!] [/!][showif [var_Category]^Category01]&eqCategory01data=[Category01][/showif][!] [/!][showif [var_Category]^Category02]&eqCategory02data=[Category02][/showif][!] [/!][showif [var_Category]^Category03]&eqCategory03data=[Category03][/showif][!] [/!][showif [var_Category]^Category04]&eqCategory04data=[Category04][/showif][!] [/!][showif [var_Category]^Category05]&eqCategory05data=[Category05][/showif][!] [/!][showif [var_Category]^Category06]&eqCategory06data=[Category06][/showif][!] [/!][showif [var_Category]^Category07]&eqCategory07data=[Category07][/showif][!] [/!][showif [var_Category]^Category08]&eqCategory08data=[Category08][/showif][!] [/!][showif [var_Category]^Category09]&eqCategory09data=[Category09][/showif][!] [/!][showif [var_Category]^Category10]&eqCategory10data=[Category10][/showif][!] [/!][showif [var_Category]^Category11]&eqCategory11data=[Category11][/showif][!] [/!][showif [var_Category]^Category12]&eqCategory12data=[Category12][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek01]&eqLectureWeek01data=[LectureWeek01][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek02]&eqLectureWeek02data=[LectureWeek02][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek03]&eqLectureWeek03data=[LectureWeek03][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek04]&eqLectureWeek04data=[LectureWeek04][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek05]&eqLectureWeek05data=[LectureWeek05][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek06]&eqLectureWeek06data=[LectureWeek06][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek07]&eqLectureWeek07data=[LectureWeek07][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek08]&eqLectureWeek08data=[LectureWeek08][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek09]&eqLectureWeek09data=[LectureWeek09][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek10]&eqLectureWeek10data=[LectureWeek10][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek11]&eqLectureWeek11data=[LectureWeek11][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek12]&eqLectureWeek12data=[LectureWeek12][/showif][!] [/!][showif [ArticleExtract]!]&wsArticleExtractdata=[ArticleExtract][/showif][!] [/!]&AllReqd=[var_Req][!] [/!]&rank=off[!] [/!]&max=[pageMaxSearchItems][!] [/!][showif [var_from]=1]&startat=[from][/showif][!] [/!]]-- 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          :) ------------------------------------------------------------------On Saturday, 29 March 2003 10:59 AM, Tim Robinson wrote: >You could just have the allreq as a variable on the previous page like this: > > >Then on the next page: >&AllReqd=[allreqd] > >You then don't have to worry about the showif at all. > >Tim > >> From: Donovan >> Reply-To: (WebDNA Talk) >> Date: Fri, 28 Mar 2003 08:08:19 -0600 >> To: (WebDNA Talk) >> Subject: Re: AND/OR searches in WebCat 3.07 >> >> Lot-o-room for [url][/url] problems... >> >> Donovan >> >> >> >> Gary 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/ >> > > >------------------------------------------------------------- >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/ >------------------------------------------------------------- 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)
Thanx all who helped me.It really wasn't the [search...] code that was wrong, but the way the data was presented in the database (multiple data in a field). Becuase I am using that are checkboxes, it complicated the isses of a search as checkboxs items not selected were still passed as empty and the [search...] had &eqFieldnamedata=[fieldname] instead of &eqFieldnamedata=input. I had to split the data in the databases and create some check variables for empty data that I did not want to appear in the [search...]Here is a tip: If you want to know what your [search...] is doing copy the whole [search...] and paste it above the REAL search and just rename the copy from [search...] to [s earch...]. Buy putting the space in the [s earch...], webcatalog/webdna will not parse it as a [serach...] but display it as text.here is my solution that works correctly:[text]var_Source=[/text] [text]var_Category=[/text] [text]var_LectureWeek=[/text][formvariables] [index]: [name]=[value]
[showif [name]~Source][text]var_Source=[var_Source] [Name][/text][/showif] [showif [name]~Category][text]var_Category=[var_Category] [Name][/text][/showif] [showif [name]~LectureWeek][text]var_LectureWeek=[var_LectureWeek] [Name][/text][/showif] [/formvariables]
[search db=[var_Database_Dir]/mkt525.db[!] [/!][showif [DateDay]!]&eqDateDaydata=[DateDay][/showif][!] [/!][showif [DateMonth]!]&eqDateMonthdata=[DateMonth][/showif][!] [/!][showif [DateYear]!]&eqDateYeardata=[DateYear][/showif][!] [/!][showif [Title]!]&wsTitledata=[Title][/showif][!] [/!][showif [Author]!]&wsAuthordata=[Author][/showif][!] [/!][showif [Publisher]!]&wsPublisherdata=[Publisher][/showif][!] [/!][showif [ISBN]!]&wsISBNdata=[ISBN][/showif][!] [/!][showif [WebAddress]!]&wsWebAddressdata=[WebAddress][/showif][!] [/!][showif [var_source]^Source01]&eqSource01data=[Source01][/showif][!] [/!][showif [var_source]^Source02]&eqSource02data=[Source02][/showif][!] [/!][showif [var_source]^Source03]&eqSource03data=[Source03][/showif][!] [/!][showif [var_source]^Source04]&eqSource04data=[Source04][/showif][!] [/!][showif [var_source]^Source05]&eqSource05data=[Source05][/showif][!] [/!][showif [var_source]^Source06]&eqSource06data=[Source06][/showif][!] [/!][showif [var_source]^Source07]&eqSource07data=[Source07][/showif][!] [/!][showif [var_source]^Source08]&eqSource08data=[Source08][/showif][!] [/!][showif [var_source]^Source09]&eqSource09data=[Source09][/showif][!] [/!][showif [var_Category]^Category01]&eqCategory01data=[Category01][/showif][!] [/!][showif [var_Category]^Category02]&eqCategory02data=[Category02][/showif][!] [/!][showif [var_Category]^Category03]&eqCategory03data=[Category03][/showif][!] [/!][showif [var_Category]^Category04]&eqCategory04data=[Category04][/showif][!] [/!][showif [var_Category]^Category05]&eqCategory05data=[Category05][/showif][!] [/!][showif [var_Category]^Category06]&eqCategory06data=[Category06][/showif][!] [/!][showif [var_Category]^Category07]&eqCategory07data=[Category07][/showif][!] [/!][showif [var_Category]^Category08]&eqCategory08data=[Category08][/showif][!] [/!][showif [var_Category]^Category09]&eqCategory09data=[Category09][/showif][!] [/!][showif [var_Category]^Category10]&eqCategory10data=[Category10][/showif][!] [/!][showif [var_Category]^Category11]&eqCategory11data=[Category11][/showif][!] [/!][showif [var_Category]^Category12]&eqCategory12data=[Category12][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek01]&eqLectureWeek01data=[LectureWeek01][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek02]&eqLectureWeek02data=[LectureWeek02][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek03]&eqLectureWeek03data=[LectureWeek03][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek04]&eqLectureWeek04data=[LectureWeek04][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek05]&eqLectureWeek05data=[LectureWeek05][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek06]&eqLectureWeek06data=[LectureWeek06][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek07]&eqLectureWeek07data=[LectureWeek07][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek08]&eqLectureWeek08data=[LectureWeek08][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek09]&eqLectureWeek09data=[LectureWeek09][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek10]&eqLectureWeek10data=[LectureWeek10][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek11]&eqLectureWeek11data=[LectureWeek11][/showif][!] [/!][showif [var_LectureWeek]^LectureWeek12]&eqLectureWeek12data=[LectureWeek12][/showif][!] [/!][showif [ArticleExtract]!]&wsArticleExtractdata=[ArticleExtract][/showif][!] [/!]&AllReqd=[var_Req][!] [/!]&rank=off[!] [/!]&max=[pageMaxSearchItems][!] [/!][showif [var_from]=1]&startat=[from][/showif][!] [/!]]-- 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          :) ------------------------------------------------------------------On Saturday, 29 March 2003 10:59 AM, Tim Robinson wrote: >You could just have the allreq as a variable on the previous page like this: > > >Then on the next page: >&AllReqd=[allreqd] > >You then don't have to worry about the showif at all. > >Tim > >> From: Donovan >> Reply-To: (WebDNA Talk) >> Date: Fri, 28 Mar 2003 08:08:19 -0600 >> To: (WebDNA Talk) >> Subject: Re: AND/OR searches in WebCat 3.07 >> >> Lot-o-room for [url][/url] problems... >> >> Donovan >> >> >> >> Gary 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/ >> > > >------------------------------------------------------------- >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/ >------------------------------------------------------------- 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/ Marko Bernyk

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:

Help name our technology! I found it (1997) Bug Report, maybe (1997) Sort Order on a page search (1997) Help name our technology! (1997) date pref (1999) Using Cookie for client specific info? (1997) ShoppingCart removal (2002) Webstar 1.3.1 PPC (1997) Development terminated. (1998) lookup (1998) List of WebDNA users - Show of Hands (2002) validatin (1998) textarea inputs and returns (1999) math on date? (1997) Sku numbers (1997) WebCat editing, SiteGuard & SiteEdit (1997) [TEST] - Please Ignore (2000) [searchString] (1997) Exclamation point (1997) taxTotal, grandTotal (1997)