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 b15 Mac plug-in (1997) Getting Total Quantity (1997) test (2001) Physical Security for WebCatalog Directories (1997) Calendar (1997) Using Plug-In while running 1.6.1 (1997) Emailer Q (2002) WebCat vs. ASP (1999) RE: OK, here goes... (1997) filemaker - orderfile (1997) Re[2]: Enhancement Request for WebCatalog-NT (1996) [WebDNA] configuring 5.1 with apache 2? (2008) WebDNA for Dummies (2004) Sorting by date (1997) [WebDNA] [convertchars] and ascii problem (2010) WC Database Format (1997) Help name our technology! I found it (1997) catagories (1997) Questions To Answer (1997) Re:No Data (1997)