Re[2]: searches with dash, period etc. (back form politenes
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 25941
interpreted = N
texte = Oh, is that what this is all about. You are not understanding wbrk correctly. Note carefully that there is a space after each comma in the namelist. When youoverrode the default wbrk characters with comma, WebCat correctly determinedthat Joe Jones is not the same as Joe Jones (from the database), and thesame for the other case.You need to clean up your name list to only contain the names and commas; youcannot add space to the wbrk list since that will break on first name/last nameas well. The characters in the wbrk list are all of the characters that areused as delimiters, and only those characters are stripped from the test string.This will work as advertised: [text]namelist=Joe Smith,Joe Jones,Joe Roberts[/text] [search db=nametest.db&wonamedatarq=[namelist]&nameword=ww&namewbrk=,]HTHJohn Peacock____________________Reply Separator____________________Subject: Re: searches with dash, period etc. (back form politeness) Author:
(WebCatalog Talk)Date: 1/6/00 1:25 PMJohn, thanks for the response & acknowledgement.Ok here's my example that was posted to the list as well as sent to techsupport:I have a value list such as: [text]namelist=Joe Smith, Joe Jones, JoeRoberts[/text]and a db with:Name IDJoe Smith 1Joe Jones 2Joe Roberts 3Joe Brown 4My search is:[search db=nametest.db&wonamedatarq=[namelist]&nameword=ww&namewbrk=,]or[searchdb=nametest.db&wonamedatarq=[namelist]&nameword=ww&namewbrk=[url],[/url]]Which uses the wholeword modifier and specifies what the word delimiter is(,) so the effect should be that the term Joe Smith is treated in thesearch as a whole word, followed by Joe Jones & Joe Roberts, so thatall records are returned except for Joe Brown's.This now only returns the first instance - Joe Smith. URLing the breakcharacter has no affect.Marty Schmid>Yes, I was inconsiderate with my post and I apologize. I certainly>appreciate Ken's help on this list. However, unless I'm not understanding>something that's been written, it works like I said. I've set up a test>page so you can see the difference the wbrk parameter makes. It does>replace the word break list. If any of you have code where it doesn't look>like this happens please post it. One thing that has made this appear not>to work is not URLizing the word brak characters (especially the space>character). Hit this page to see what I mean:>>http://search.smithmicro.com/wbrk.tpl>>John.>>---------------------------------> John A. Hill> Smith Micro Software> Internet Solutions Division>eCommerce / Consulting / Hosting> http://www.smithmicro.com>(formerly Pacific Coast Software)>>------------------------------------------------------------->Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.>To end your Mail problems go to .>>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>-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Associated Messages, from the most recent to the oldest:
Oh, is that what this is all about. You are not understanding wbrk correctly. Note carefully that there is a space after each comma in the namelist. When youoverrode the default wbrk characters with comma, WebCat correctly determinedthat Joe Jones is not the same as Joe Jones (from the database), and thesame for the other case.You need to clean up your name list to only contain the names and commas; youcannot add space to the wbrk list since that will break on first name/last nameas well. The characters in the wbrk list are all of the characters that areused as delimiters, and only those characters are stripped from the test string.This will work as advertised: [text]namelist=Joe Smith,Joe Jones,Joe Roberts[/text] [search db=nametest.db&wonamedatarq=[namelist]&nameword=ww&namewbrk=,]HTHJohn Peacock____________________Reply Separator____________________Subject: Re: searches with dash, period etc. (back form politeness) Author: (WebCatalog Talk)Date: 1/6/00 1:25 PMJohn, thanks for the response & acknowledgement.Ok here's my example that was posted to the list as well as sent to techsupport:I have a value list such as: [text]namelist=Joe Smith, Joe Jones, JoeRoberts[/text]and a db with:Name IDJoe Smith 1Joe Jones 2Joe Roberts 3Joe Brown 4My search is:[search db=nametest.db&wonamedatarq=[namelist]&nameword=ww&namewbrk=,]or[searchdb=nametest.db&wonamedatarq=[namelist]&nameword=ww&namewbrk=[url],[/url]]Which uses the wholeword modifier and specifies what the word delimiter is(,) so the effect should be that the term Joe Smith is treated in thesearch as a whole word, followed by Joe Jones & Joe Roberts, so thatall records are returned except for Joe Brown's.This now only returns the first instance - Joe Smith. URLing the breakcharacter has no affect.Marty Schmid>Yes, I was inconsiderate with my post and I apologize. I certainly>appreciate Ken's help on this list. However, unless I'm not understanding>something that's been written, it works like I said. I've set up a test>page so you can see the difference the wbrk parameter makes. It does>replace the word break list. If any of you have code where it doesn't look>like this happens please post it. One thing that has made this appear not>to work is not URLizing the word brak characters (especially the space>character). Hit this page to see what I mean:>>http://search.smithmicro.com/wbrk.tpl>>John.>>---------------------------------> John A. Hill> Smith Micro Software> Internet Solutions Division>eCommerce / Consulting / Hosting> http://www.smithmicro.com>(formerly Pacific Coast Software)>>------------------------------------------------------------->Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.>To end your Mail problems go to .>>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>-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
jpeacock@univpress.com
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:
[WebDNA] WebDNA on LiveCD ... (2008)
Compressed cookies? (2003)
Help! (2000)
Creating main- and sub-category search (1997)
Server Slowdown (1999)
America Online Issues (1998)
Checking for blank form fields (sort of...) (1998)
random within a specified range (2001)
Can I do these? (1997)
What's wrong with this [append] context? (2000)
[format 40s]text[/format] doesn't work (1997)
Server crash (1997)
do you have a webcatalog tool you want to sell? (1999)
Date fun with MySQL (2004)
searchable list archive (1997)
New Site Announcement (1998)
Webcatalog error, Plug-in for Webstar (1996)
Separate SSL Server (1997)
SMSI: databases corrupted on crash and permission issueson OSX (2002)
quantity minimum problem (1997)