Re[2]: searches with dash, period etc. (back form politenes
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 25944
interpreted = N
texte = YES it works! Thank you!!! John(s) you were both precisely correct about the space causing my problems. I was so relieved to get this functioning that I let out a yell that could be probably be heard at PCS's headquarters. This little problem has caused me a ridiculous amount of frustration and I have wasted days and days reworking our development to get around using this technique and its delayed our launch by several weeks.And I don't want to sound ungrateful, but my relief to have this working is of course tempered by the realization of how much time and energy could have been saved had PCS/SM responded to any of the multiple requests for support with this simple issue.Most appreciatively, Marty Schmid >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 you >overrode the default wbrk characters with comma, WebCat correctly determined >that Joe Jones is not the same as Joe Jones (from the database), and the >same for the other case. > >You need to clean up your name list to only contain the names and commas; you >cannot add space to the wbrk list since that will break on first name/last >name >as well. The characters in the wbrk list are all of the characters that are >used 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=,] > >HTH > >John Peacock >____________________Reply Separator____________________ >Subject: Re: searches with dash, period etc. (back form politeness) >Author:
(WebCatalog Talk) >Date: 1/6/00 1:25 PM > >John, thanks for the response & acknowledgement. >Ok here's my example that was posted to the list as well as sent to tech >support: > >I have a value list such as: [text]namelist=Joe Smith, Joe Jones, Joe >Roberts[/text] > >and a db with: >Name ID >Joe Smith 1 >Joe Jones 2 >Joe Roberts 3 >Joe Brown 4 > >My search is: >[search db=nametest.db&wonamedatarq=[namelist]&nameword=ww&namewbrk=,] >or >[search >db=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 the >search as a whole word, followed by Joe Jones & Joe Roberts, so that >all records are returned except for Joe Brown's. > >This now only returns the first instance - Joe Smith. URLing the break >character 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 > ------------------------------------------------------------- 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:
YES it works! Thank you!!! John(s) you were both precisely correct about the space causing my problems. I was so relieved to get this functioning that I let out a yell that could be probably be heard at PCS's headquarters. This little problem has caused me a ridiculous amount of frustration and I have wasted days and days reworking our development to get around using this technique and its delayed our launch by several weeks.And I don't want to sound ungrateful, but my relief to have this working is of course tempered by the realization of how much time and energy could have been saved had PCS/SM responded to any of the multiple requests for support with this simple issue.Most appreciatively, Marty Schmid >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 you >overrode the default wbrk characters with comma, WebCat correctly determined >that Joe Jones is not the same as Joe Jones (from the database), and the >same for the other case. > >You need to clean up your name list to only contain the names and commas; you >cannot add space to the wbrk list since that will break on first name/last >name >as well. The characters in the wbrk list are all of the characters that are >used 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=,] > >HTH > >John Peacock >____________________Reply Separator____________________ >Subject: Re: searches with dash, period etc. (back form politeness) >Author: (WebCatalog Talk) >Date: 1/6/00 1:25 PM > >John, thanks for the response & acknowledgement. >Ok here's my example that was posted to the list as well as sent to tech >support: > >I have a value list such as: [text]namelist=Joe Smith, Joe Jones, Joe >Roberts[/text] > >and a db with: >Name ID >Joe Smith 1 >Joe Jones 2 >Joe Roberts 3 >Joe Brown 4 > >My search is: >[search db=nametest.db&wonamedatarq=[namelist]&nameword=ww&namewbrk=,] >or >[search >db=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 the >search as a whole word, followed by Joe Jones & Joe Roberts, so that >all records are returned except for Joe Brown's. > >This now only returns the first instance - Joe Smith. URLing the break >character 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 > ------------------------------------------------------------- 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
Marty Schmid
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:
RE: Formulas.db + Users.db (1997)
Execute Applescript (1997)
Emailer choke (1997)
Problem displaying search result (1997)
Attn: Bug in GeneralStore example b15 (1997)
[ShowNext] feature in 2.0 (1997)
Can this be done? (1997)
$Append for Users outside the ADMIN group (1997)
Navigator 4.01 (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
Sorting Numbers (1997)
iTools and 3.0.8 (2000)
CORR: date format (2000)
Grouping fields problem (1998)
Fwd: Protect Tag and Groups (1998)
Moment of Thanks (1997)
How do I get WebCatalog to interpret WebDNA tags in .html files? (1997)
PCS Frames-Default page is solution! (1997)
NTbeta18 corrupted? (1997)
Click-through/Referral tracking solution needed (2000)