Re: whole word matching
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59754
interpreted = N
texte = I ran a test with Donovan's code, and it works fine for me, assuming I understand what you're looking for. First issue: The "fbrk" parameter was introduced in WebDNA 4.5.1 - you said you're testing on 4.5 If your "4.5" is really "4.5.1", then it should work (though there was also a bug fix with the fbrk parameter in version 5.1e). If it is "4.5.0", it will not work. Try putting "[unurl][svar][/unurl]
" above your search so you can see exactly what your code is generating - this often shows unexpected problems with the preceding code. Finally, let's clarify what you're looking for. From what I've read in this thread (hey, that rhymes!), I take it that your "PUBLISHER" field contains one or more publisher names, separated by commas. For example, it could contain "Food Image Source,Bob's Publishing House" or simply "Image Source". Given those two examples, you want to find "Image Source" but not "Food Image Source"... correct? This is the result I see in my quick test with Donovan's code. - brian On Oct 25, 2004, at 5:35 AM, Erol Guneri wrote: > Thanks for the code Donovan, but still creates the same problem. > > Erol > > ----- Original Message ----- > From: "Donovan Brooke"
> To: "WebDNA Talk" > Sent: Monday, October 25, 2004 1:31 PM > Subject: Re: whole word matching > > >> Erol, heading out of the office... >> >> Try this (not tested): >> >> [text]svar=[url][!] >> [/!][IF ("[OrderFile cart=[cart]][Header5][/orderfile]"!"")][!] >> [/!][Then][!] >> [/!]&woPUBLISHERdatarq=[url][OrderFile > cart=[cart]][Header5][/orderfile][/url][!] >> [/!]&Publisherwbrk=,[!] >> [/!]&Publisherfbrk=,[!] >> [/!]&Publisherword=ww[!] >> [/!][/Then][!] >> [/!][/if][!] >> [/!][/url][/text] >> >> >> [search db=dbs/cadmium.db[unurl][svar][/unurl]] >> >> [FoundItems] >> [Publisher]
>> [/FoundItems] >> [/search] >> >> >> Cheers, >> Donovan > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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:
I ran a test with Donovan's code, and it works fine for me, assuming I understand what you're looking for. First issue: The "fbrk" parameter was introduced in WebDNA 4.5.1 - you said you're testing on 4.5 If your "4.5" is really "4.5.1", then it should work (though there was also a bug fix with the fbrk parameter in version 5.1e). If it is "4.5.0", it will not work. Try putting "[unurl][svar][/unurl]
" above your search so you can see exactly what your code is generating - this often shows unexpected problems with the preceding code. Finally, let's clarify what you're looking for. From what I've read in this thread (hey, that rhymes!), I take it that your "PUBLISHER" field contains one or more publisher names, separated by commas. For example, it could contain "Food Image Source,Bob's Publishing House" or simply "Image Source". Given those two examples, you want to find "Image Source" but not "Food Image Source"... correct? This is the result I see in my quick test with Donovan's code. - brian On Oct 25, 2004, at 5:35 AM, Erol Guneri wrote: > Thanks for the code Donovan, but still creates the same problem. > > Erol > > ----- Original Message ----- > From: "Donovan Brooke" > To: "WebDNA Talk" > Sent: Monday, October 25, 2004 1:31 PM > Subject: Re: whole word matching > > >> Erol, heading out of the office... >> >> Try this (not tested): >> >> [text]svar=[url][!] >> [/!][IF ("[OrderFile cart=[cart]][Header5][/orderfile]"!"")][!] >> [/!][Then][!] >> [/!]&woPUBLISHERdatarq=[url][OrderFile > cart=[cart]][Header5][/orderfile][/url][!] >> [/!]&Publisherwbrk=,[!] >> [/!]&Publisherfbrk=,[!] >> [/!]&Publisherword=ww[!] >> [/!][/Then][!] >> [/!][/if][!] >> [/!][/url][/text] >> >> >> [search db=dbs/cadmium.db[unurl][svar][/unurl]] >> >> [founditems] >> [Publisher]
>> [/FoundItems] >> [/search] >> >> >> Cheers, >> Donovan > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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/
Brian Fries
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:
looking for developers with solutions (2000)
carriage returns in data (1997)
Convert Chars Q (2000)
RE: WebDNA-Talk searchable? (1997)
Help formatting search results w/ table (1997)
Re:Help name our technology! (1997)
Off Topic: Help Wanted (1997)
Not really WebCat (1997)
Loss in Form (1998)
PIXO with cometsite ... and/or other plugins (1998)
Delete only one duplicate record? (2003)
Suggestions on best way to work with yyyy/mm/dd (1997)
Change to UPPERCASE (2000)
Emailer (1997)
Just Testing (1997)
GrandTotal not right (1997)
Logging purchases (1997)
Make sure I understand this??? (1997)
Emailer error 550? Never mind. (1999)
Stumped (1999)