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:

Requiring that certain fields be completed (1997) WebCat b13 CGI -shownext- (1997) Advanced WebCat Guidelines - do they exist beyond docs (1999) My URL, Your URL (2002) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Serious bug writing to a database ... (2002) Documentation Feedback (1997) Replace context problem ... and answers (1997) Fulfillment emails not emailing after upgrade (2002) WebCat2 several catalogs? (1997) headers (2004) WebDNA to Apache RewriteMap (2005) itools (2000) Weird Linux WebCat Issue (2003) [REPLACE] inside [FOUNDITEMS] (1998) Error Lob.db records error message not name (1997) Email within tmpl ? (1997) PSC recommends what date format yr 2000??? (1997) Re:2nd WebCatalog2 Feature Request (1996) WC2b15 File Corruption (1997)