Re: [WebDNA] ww- whole word in search tag

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110304
interpreted = N
texte = --Apple-Mail=_D4DCA5A8-454A-4EE3-8E8F-1E5E6CDF6CB5 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 > Hi Al,, >=20 > I have a search tag using the wo: 'word-or' comparison. >=20 > [search = db=3Dproducts.db&woRECORD_NAMEdata=3D[searchforthis]&woTEXT_1data=3D[searc= hforthis]&woCATEGORYdata=3D[searchforthis]]=20 >=20 > If I search for the word Oven, it correctly finds the word in the = RECORD_NAME field, but it also supplies the word 'proven' from the = TEXT_1 field. > My customer doesn't want this. >=20 > So I tried various uses of the ww: 'whole-word' comparison and I can't = get any results that work. >=20 > ww in the TEXT_1 field only didn't work. > [search = db=3Dproducts.db&woRECORD_NAMEdata=3D[searchforthis]&wwTEXT_1data=3D[searc= hforthis]&woCATEGORYdata=3D[searchforthis]]=20 >=20 > ww in all the fields didn't work. > [search = db=3Dproducts.db&wwRECORD_NAMEdata=3D[searchforthis]&wwTEXT_1data=3D[searc= hforthis]&wwCATEGORYdata=3D[searchforthis]]=20 try it like this: (this is what the docs really are saying to do) [search = db=3Dproducts.db&woRECORD_NAMEdata=3D[searchforthis]&woTEXT_1data=3D[searc= hforthis]&TEXT_1word=3Dww&woCATEGORYdata=3D[searchforthis]] I would probably wrap the "[searchforthis]" in [url]...[/url] too, if I = were you, but that is another topic. -Govinda= --Apple-Mail=_D4DCA5A8-454A-4EE3-8E8F-1E5E6CDF6CB5 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1

Hi Al,,

I have a search tag using the = wo: 'word-or' comparison.

[search = db=3Dproducts.db&woRECORD_NAMEdata=3D[searchforthis]&woTEXT_1data=3D= [searchforthis]&woCATEGORYdata=3D[searchforthis]] 

=
If I search for the word Oven, it correctly finds the word in = the RECORD_NAME field, but it also supplies the word 'proven' from = the TEXT_1 field.
My customer doesn't want = this.

So I tried various uses of the ww: = 'whole-word' comparison = and I can't get any results that work.

ww in the TEXT_1 field = only didn't work.
[search = db=3Dproducts.db&woRECORD_NAMEdata=3D[searchforthis]&wwTEXT_1data=3D= [searchforthis]&woCATEGORYdata=3D[searchforthis]] 

=
ww in all the fields didn't work.
[search = db=3Dproducts.db&wwRECORD_NAMEdata=3D[searchforthis]&wwTEXT_1data=3D= [searchforthis]&wwCATEGORYdata=3D[searchforthis]] 


try it like this: =  (this is what the docs really are saying to = do)

[search = db=3Dproducts.db&woRECORD_NAMEdata=3D[searchforthis]&woTEXT_1data=3D= [searchforthis]&TEXT_1word=3Dww&woCATEGORYdata=3D[searchforthis]]<= /div>

I would probably wrap the "[searchforthis]" in = [url]...[/url] too, if I were you, but that is another = topic.

-Govinda
= --Apple-Mail=_D4DCA5A8-454A-4EE3-8E8F-1E5E6CDF6CB5-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] ww- whole word in search tag (John Buler 2013)
  2. Re: [WebDNA] ww- whole word in search tag (Stephen Braun 2013)
  3. Re: [WebDNA] ww- whole word in search tag (John Buler 2013)
  4. [WebDNA] ww- whole word in search tag (Stephen Braun 2013)
--Apple-Mail=_D4DCA5A8-454A-4EE3-8E8F-1E5E6CDF6CB5 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 > Hi Al,, >=20 > I have a search tag using the wo: 'word-or' comparison. >=20 > [search = db=3Dproducts.db&woRECORD_NAMEdata=3D[searchforthis]&woTEXT_1data=3D[searc= hforthis]&woCATEGORYdata=3D[searchforthis]]=20 >=20 > If I search for the word Oven, it correctly finds the word in the = RECORD_NAME field, but it also supplies the word 'proven' from the = TEXT_1 field. > My customer doesn't want this. >=20 > So I tried various uses of the ww: 'whole-word' comparison and I can't = get any results that work. >=20 > ww in the TEXT_1 field only didn't work. > [search = db=3Dproducts.db&woRECORD_NAMEdata=3D[searchforthis]&wwTEXT_1data=3D[searc= hforthis]&woCATEGORYdata=3D[searchforthis]]=20 >=20 > ww in all the fields didn't work. > [search = db=3Dproducts.db&wwRECORD_NAMEdata=3D[searchforthis]&wwTEXT_1data=3D[searc= hforthis]&wwCATEGORYdata=3D[searchforthis]]=20 try it like this: (this is what the docs really are saying to do) [search = db=3Dproducts.db&woRECORD_NAMEdata=3D[searchforthis]&woTEXT_1data=3D[searc= hforthis]&TEXT_1word=3Dww&woCATEGORYdata=3D[searchforthis]] I would probably wrap the "[searchforthis]" in [url]...[/url] too, if I = were you, but that is another topic. -Govinda= --Apple-Mail=_D4DCA5A8-454A-4EE3-8E8F-1E5E6CDF6CB5 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1

Hi Al,,

I have a search tag using the = wo: 'word-or' comparison.

[search = db=3Dproducts.db&woRECORD_NAMEdata=3D[searchforthis]&woTEXT_1data=3D= [searchforthis]&woCATEGORYdata=3D[searchforthis]] 

=
If I search for the word Oven, it correctly finds the word in = the RECORD_NAME field, but it also supplies the word 'proven' from = the TEXT_1 field.
My customer doesn't want = this.

So I tried various uses of the ww: = 'whole-word' comparison = and I can't get any results that work.

ww in the TEXT_1 field = only didn't work.
[search = db=3Dproducts.db&woRECORD_NAMEdata=3D[searchforthis]&wwTEXT_1data=3D= [searchforthis]&woCATEGORYdata=3D[searchforthis]] 

=
ww in all the fields didn't work.
[search = db=3Dproducts.db&wwRECORD_NAMEdata=3D[searchforthis]&wwTEXT_1data=3D= [searchforthis]&wwCATEGORYdata=3D[searchforthis]] 


try it like this: =  (this is what the docs really are saying to = do)

[search = db=3Dproducts.db&woRECORD_NAMEdata=3D[searchforthis]&woTEXT_1data=3D= [searchforthis]&TEXT_1word=3Dww&woCATEGORYdata=3D[searchforthis]]<= /div>

I would probably wrap the "[searchforthis]" in = [url]...[/url] too, if I were you, but that is another = topic.

-Govinda
= --Apple-Mail=_D4DCA5A8-454A-4EE3-8E8F-1E5E6CDF6CB5-- John Buler

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:

carriage returns in data (1997) SMSI: WebDNA Versions? (2002) Quit revisited (1997) Searching Relational Databases (2004) Encrypt/decrypt bug in 3.0.5b12 (1999) randomness (1997) WebCatalog2 Feature Feedback (1996) [WebDNA] 30 Minute Cookies (2016) Word search (1997) [OT] See Flash? (2003) multiple record replace (2001) Interfacing WebMerchant to www.fedex.com (1997) WebCat2 several catalogs? (1997) Text data with spaces in them... (1997) SiteGuard Admin Feature ? (1997) Multiple security dbs (1997) PCS Frames-Default page is solution! (1997) Location of Browser Info.txt file (1997) Item counting? (1998) Problems passing [SKU] with $Replace in 2.0 (1997)