Re: how to construct a search for not this entire string?

This WebDNA talk-list message is from

2000

It keeps the original formatting. numero = 31173
interpreted = N
texte = >I want to search for one random (we'll just imagine sdir=ra is working>properly) record in my subscribers.db which does not contain the string>feeling-goods.com (so no one inside the company ever wins the free>socks ;-). Did I do this right?>>[Search db=subscribers.db>&wnEmailAddressdata=feeling-goods.com>&EmailAddresswbrk=@>&EmailAddresssort=1>&EmailAddresssdir=ra>&max=1&allhit=1]>>(returns added for readability)More or less. You shouldn't need the wbrk parameter, that's only necessary when you're trying to find an exact match of a specific word, and in this case you're only looking for the presence of the string feeling-goods.com in the entire field, so that parameter should be unnecessary.I never use allhit either, I forget what it's used for ... ?================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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:

Re: how to construct a search for not this entire string? (Kenneth Grome 2000) Re: how to construct a search for not this entire string? (Aaron Lynch 2000) Re: how to construct a search for not this entire string? (Kenneth Grome 2000) how to construct a search for not this entire string? (John Butler 2000) how to construct a search for not this entire string? (John Butler 2000)

>I want to search for one random (we'll just imagine sdir=ra is working>properly) record in my subscribers.db which does not contain the string>feeling-goods.com (so no one inside the company ever wins the free>socks ;-). Did I do this right?>>[Search db=subscribers.db>&wnEmailAddressdata=feeling-goods.com>&EmailAddresswbrk=@>&EmailAddresssort=1>&EmailAddresssdir=ra>&max=1&allhit=1]>>(returns added for readability)More or less. You shouldn't need the wbrk parameter, that's only necessary when you're trying to find an exact match of a specific word, and in this case you're only looking for the presence of the string feeling-goods.com in the entire field, so that parameter should be unnecessary.I never use allhit either, I forget what it's used for ... ?================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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  Kenneth Grome

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:

Search all Fields in a db (1997) More on the email templates (1997) E-Mailer (WebCatb15acgiMac) (1997) WebCatalog for Postcards ? (1997) Relay link (2002) Word Break (1999) WebCatalog Upgrade Pricing? (1997) Database Sizes (2000) Problems setting MIME Headers (1998) month from number (2005) Getting total number of items ordered (1997) Upload Text File/ Append to DB (2003) [format 40s]text[/format] doesn't work (1997) Silly Question (1997) WebCat2 - many [carts] on one template page? (1997) HomePage Caution (1997) Banner DNA (1997) $Append for Users outside the ADMIN group (1997) Web Catalog Book? (1998) JavaScript Image Problem (1998)