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".>>DonovanAhh yes (kind of). I guess he wants only those companys that start witha 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 numberonly.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:
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".>>DonovanAhh yes (kind of). I guess he wants only those companys that start witha 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 numberonly.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)