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 doingcopy 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 Engineermailto:marko@conexus.com.au http://www.conexus.com.auTechnical Services, Conexus Pty Ltd, Sydney, AustraliaPh 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:
Re: 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 doingcopy 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 Engineermailto:marko@conexus.com.au http://www.conexus.com.auTechnical Services, Conexus Pty Ltd, Sydney, AustraliaPh 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
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...