& as a whole word: Threat or Menace?

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 30744
interpreted = N
texte = This one goes out to Grant, Jay, John, Support, or anyone who can come up with a good explanation,Here's a hypothetical. I'm not looking to put this into practice any time soon, and I'm not looking for a work-around. Just a little search syntax concern I have (inspired by an earlier thread):Let's say I have a database: SKU FIELD 1 hello 2 hello & goodbye 3 & 4 &&Now, if I want to find records that contain & as a whole word (records 2 and 3), I would say [SEARCH db=test.db&waFIELDdatarq=[URL]&[/URL]&FIELDword=ww], right? Well, I'm not getting the results I expect. For some reason, the && record sneaks in. Is there a reason that a & in && is considered a whole word? Setting FIELDwbrk to any number of things doesn't help (does wbrk *expand* the list of breaks or *replace* it, anyway?).Maybe this is a bug, or maybe there's some greater logic behind it that escapes me. If anyone has some insight to the inner-workings of this please speak up. I haven't tried it, but it seems like this would happen with other special characters as well (,.|[]{}) which could lead to problems.Michael------------------------------------------------------------- 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:

    
This one goes out to Grant, Jay, John, Support, or anyone who can come up with a good explanation,Here's a hypothetical. I'm not looking to put this into practice any time soon, and I'm not looking for a work-around. Just a little search syntax concern I have (inspired by an earlier thread):Let's say I have a database: SKU FIELD 1 hello 2 hello & goodbye 3 & 4 &&Now, if I want to find records that contain & as a whole word (records 2 and 3), I would say [SEARCH db=test.db&waFIELDdatarq=[url]&[/URL]&FIELDword=ww], right? Well, I'm not getting the results I expect. For some reason, the && record sneaks in. Is there a reason that a & in && is considered a whole word? Setting FIELDwbrk to any number of things doesn't help (does wbrk *expand* the list of breaks or *replace* it, anyway?).Maybe this is a bug, or maybe there's some greater logic behind it that escapes me. If anyone has some insight to the inner-workings of this please speak up. I haven't tried it, but it seems like this would happen with other special characters as well (,.|[]{}) which could lead to problems.Michael------------------------------------------------------------- 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 Michael Winston

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:

I think WebDNA-Talk died ... :( (1997) [shownext max=?] armed (1997) View order not right (1997) Show if file exists (2004) Mac OS X Server, Apache etc etc (1999) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) [no_cache]?! (2000) [WebDNA] Query re: autonumber (2010) WebCat Bulletin Board Solution ? (1998) [BULK] [WebDNA] How to valuate a domain name? (2010) SKU lookup (1997) OT: Limit on # of Pulldown entries (1997) Separate SSL Server (1997) Keep away (1997) Swear words (2002) [Sum] function? (1997) searchable list archive (1997) WebCatalog for guestbook ? (1997) syntax question, not in online refernce (1997) Any Newsletters out there (1998)