Re: [WebDNA] Filtering exact numbers

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101336
interpreted = N
texte = Thanks Donovan! On Nov 3, 2008, at 2:18 PM, Donovan Brooke wrote: > Suzanne Swift wrote: > >> Here's the exact code... >> [search db=../ >> vl_binderloc.db&eqClientIDdatarq=[_ClientID]&ClientIDtype=num] >> [text]TheManufacturers=[/text] >> [founditems] >> [text]TheManufacturers=[TheManufacturers][ManSerialNumber] [/text] >> [/founditems] >> [/search] >> [search db=../reps_per_state.db&eqStatedatarq=[url][TheState][/ >> url]&eqStateRegiondatarq=[url][TheStateRegion][/ >> url]&neRepIDdatarq=[blank]] >> [founditems] >> [showif [repID]![Manufacturer]] >> [showif [url][TheManufacturers][/url]^[url][Manufacturer][/url]] > > > So now that I'm on my lunch break.. :-) I'm reading further.. > > I think you can do a more simple fix here by simply adding > in a space after your second comparison value. > > [showif [url][TheManufacturers][/url]^[url][Manufacturer] [/url]] > > .........................................................^ <--space > there > > since your first list is being deliminated by a space, this small > change *should* ensure that you match exact serialnumbers. > > Donovan > > > > > > > -- > Donovan D. Brooke PH/FAX: 1 (608) 291-2024 > ---------------------------------------------- > VP > WebDNA Software Corporation > 16192 Coastal Highway > Lewes, DE 19958 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Filtering exact numbers (Suzanne Swift 2008)
  2. Re: [WebDNA] Filtering exact numbers (Brian Fries 2008)
  3. Re: [WebDNA] Filtering exact numbers (Donovan Brooke 2008)
  4. Re: [WebDNA] Filtering exact numbers (Govinda 2008)
  5. Re: [WebDNA] Filtering exact numbers (Donovan Brooke 2008)
  6. Re: [WebDNA] Filtering exact numbers (Suzanne Swift 2008)
  7. Re: [WebDNA] Filtering exact numbers (Donovan Brooke 2008)
  8. Re: [WebDNA] Filtering exact numbers (Donovan Brooke 2008)
  9. Re: [WebDNA] Filtering exact numbers (Patrick McCormick 2008)
  10. Re: [WebDNA] Filtering exact numbers (Suzanne Swift 2008)
  11. Re: [WebDNA] Filtering exact numbers (Kenneth Grome 2008)
  12. Re: [WebDNA] Filtering exact numbers (Lawrence 2008)
  13. [WebDNA] Filtering exact numbers (Suzanne Swift 2008)
Thanks Donovan! On Nov 3, 2008, at 2:18 PM, Donovan Brooke wrote: > Suzanne Swift wrote: > >> Here's the exact code... >> [search db=../ >> vl_binderloc.db&eqClientIDdatarq=[_ClientID]&ClientIDtype=num] >> [text]TheManufacturers=[/text] >> [founditems] >> [text]TheManufacturers=[TheManufacturers][ManSerialNumber] [/text] >> [/founditems] >> [/search] >> [search db=../reps_per_state.db&eqStatedatarq=[url][TheState][/ >> url]&eqStateRegiondatarq=[url][TheStateRegion][/ >> url]&neRepIDdatarq=[blank]] >> [founditems] >> [showif [repID]![Manufacturer]] >> [showif [url][TheManufacturers][/url]^[url][Manufacturer][/url]] > > > So now that I'm on my lunch break.. :-) I'm reading further.. > > I think you can do a more simple fix here by simply adding > in a space after your second comparison value. > > [showif [url][TheManufacturers][/url]^[url][Manufacturer] [/url]] > > .........................................................^ <--space > there > > since your first list is being deliminated by a space, this small > change *should* ensure that you match exact serialnumbers. > > Donovan > > > > > > > -- > Donovan D. Brooke PH/FAX: 1 (608) 291-2024 > ---------------------------------------------- > VP > WebDNA Software Corporation > 16192 Coastal Highway > Lewes, DE 19958 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ Suzanne Swift

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:

Include a big block of text (1997) WebCatb15 Mac CGI -- [purchase] (1997) Text data with spaces in them... (1997) Bug? (1997) price search (1998) Not really WebCat (1997) WebMerchant/MacAuthorize (1998) [WebDNA] Databases not staying open (2010) How to append text after the sign & (1997) Sending E-mail (1997) 2.0Beta Command Ref (can't find this instruction) (1997) [carts] and databases (1997) Scoping rules in WebDNA 4.0 (2000) WebCat2 - storing unformatted date data? (1997) Odd Cart Behavior (1997) image magick (2003) WebCat2b12plugin - [search] is broken ... not! (1997) Date format problems (1997) CGI Request Time Out (1997) WCS Newbie question (1997)