Re: company names not begin with a letter

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 63100
interpreted = N
texte = Gary Krockover wrote: > shouldn't that be &bwCOMPANYdatarq=..... ;) > > > At 08:48 AM 9/23/2005, you wrote: > Try: > > >>[search db=...&woCOMPANYdatarq=[url]1 2 3 4 5 6 7 8 9 0[/url]&COMPANYword=sw] >> >>Looks for any one of these numbers as the starting character value in the fieldname "COMPANY". >>Donovan Ahh yes (kind of). I guess he wants only those companys that start with a number. BW isn't going to do it because you can't set an or statement with BW (unless you do a really long search context with non rq'd data?) I don't know that CL would work either.. would it pickup mid numbered words? I'd do a if/then hack for clarity: [search db=test.db&woCOMPANYdatarq=[url]1 2 3 4 5 6 7 8 9 0[/url]&COMPANYword=sw&COMPANYfbrk=[url] [/url]] [founditems] [if ([company]~1) | ([company]~2) | ([company]~3) | ([company]~4) | ([company]~5) | ([company]~6) | ([company]~7) | ([company]~8) | ([company]~9) | ([company]~0)] [then] [company]
[/then] [/if] [/founditems] [/search] This first finds all values that have numbers in them, then parses out the ones that begin with a number only. Watch email line breaks.. this one is tested. :-) Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Euca Design Center <-Web Development (specializing in eCommerce), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke Euca Design Center 1871 HWY MM Fitchburg, WI 53575 PH:> 1.608.835.2476 Web:> http://www.egg.bz http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: company names not begin with a letter ( devaulw@onebox.com 2005)
  2. Re: company names not begin with a letter ( Donovan Brooke 2005)
  3. Re: company names not begin with a letter ( "Kenneth Grome" 2005)
  4. Re: company names not begin with a letter ( Donovan Brooke 2005)
  5. Re: company names not begin with a letter ( Gary Krockover 2005)
  6. Re: company names not begin with a letter ( Gary Krockover 2005)
  7. Re: company names not begin with a letter ( Donovan Brooke 2005)
  8. Re: company names not begin with a letter ( fin dragon 2005)
  9. Re: company names not begin with a letter ( Donovan Brooke 2005)
  10. company names not begin with a letter ( fin dragon 2005)
Gary Krockover wrote: > shouldn't that be &bwCOMPANYdatarq=..... ;) > > > At 08:48 AM 9/23/2005, you wrote: > Try: > > >>[search db=...&woCOMPANYdatarq=[url]1 2 3 4 5 6 7 8 9 0[/url]&COMPANYword=sw] >> >>Looks for any one of these numbers as the starting character value in the fieldname "COMPANY". >>Donovan Ahh yes (kind of). I guess he wants only those companys that start with a number. BW isn't going to do it because you can't set an or statement with BW (unless you do a really long search context with non rq'd data?) I don't know that CL would work either.. would it pickup mid numbered words? I'd do a if/then hack for clarity: [search db=test.db&woCOMPANYdatarq=[url]1 2 3 4 5 6 7 8 9 0[/url]&COMPANYword=sw&COMPANYfbrk=[url] [/url]] [founditems] [if ([company]~1) | ([company]~2) | ([company]~3) | ([company]~4) | ([company]~5) | ([company]~6) | ([company]~7) | ([company]~8) | ([company]~9) | ([company]~0)] [then] [company]
[/then] [/if] [/founditems] [/search] This first finds all values that have numbers in them, then parses out the ones that begin with a number only. Watch email line breaks.. this one is tested. :-) Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Euca Design Center <-Web Development (specializing in eCommerce), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke Euca Design Center 1871 HWY MM Fitchburg, WI 53575 PH:> 1.608.835.2476 Web:> http://www.egg.bz http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Donovan Brooke

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:

WebCat/CyberStudio Compatibility (1998) Nesting format tags (1997) Very serious bug with the [protect] tag (2003) Strange intermittent WebDNA problems (2008) [OT] Death Clock (2003) Here's how to kill a Butler Database. (1997) Still can't upgrade users.db to 2.1.1 (1998) emailer (1997) [ConvertChars] problem (1997) Summing fields (1997) # fields limited? (1997) Attn: Bug in GeneralStore example b15 (1997) WebSite and *NO* Authentication Dialog Box!!? (1998) Search in 2 or more catalogs (1997) WebCatalog on Linux/MacOSX/etc (2000) Removing [showif] makes a big difference in speed (1997) PIXO support (1997) [table] tag (2003) First postarg not taking in $Commands (1997) Purchased cart being overwritten - still !?? (1997)