Re: [WebDNA] Filtering exact numbers

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101334
interpreted = N
texte = To expand on Donovan's point here... Given your code, [TheManufacturers] will end up with a space-delimited listing of [ManSerialNumber] values, which is good as long as you are guaranteed that [ManSerialNumber] will never contain a space character (if the values may contain spaces, a different delimiter should be used). In your last line, if you force space characters around [TheManufacturers] and [Manufacturer], then you should get what you're looking for: [showif [url] [TheManufacturers] [/url]^[url] [Manufacturer] [/url]] For example, given the manufacturer values "1234", "52345" and "2345", your "TheManufacturers" value would be "1234 52345 2345" If Manufacturer is set to "2345", your showif would evaluate to (%20 being a url'ed space character): [showif %201234%2052345%202345%20^%202345%20] which would evaluate to TRUE. If Manufacturer is set to "234", your showif would evaluate to: [showif %201234%2052345%202345%20^%20234%20] which would evaluate to FALSE. Even though the string contains "234" as portions of manufacturer values, adding the delimiters makes the test essentially check for whole words. This is a common technique I use in my code, as it is considerably faster than using listwords and checking each value independantly. Brian Fries BrainScan Software On Nov 3, 2008, at 11:18 AM, 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 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)
To expand on Donovan's point here... Given your code, [TheManufacturers] will end up with a space-delimited listing of [ManSerialNumber] values, which is good as long as you are guaranteed that [ManSerialNumber] will never contain a space character (if the values may contain spaces, a different delimiter should be used). In your last line, if you force space characters around [TheManufacturers] and [Manufacturer], then you should get what you're looking for: [showif [url] [TheManufacturers] [/url]^[url] [Manufacturer] [/url]] For example, given the manufacturer values "1234", "52345" and "2345", your "TheManufacturers" value would be "1234 52345 2345" If Manufacturer is set to "2345", your showif would evaluate to (%20 being a url'ed space character): [showif %201234%2052345%202345%20^%202345%20] which would evaluate to TRUE. If Manufacturer is set to "234", your showif would evaluate to: [showif %201234%2052345%202345%20^%20234%20] which would evaluate to FALSE. Even though the string contains "234" as portions of manufacturer values, adding the delimiters makes the test essentially check for whole words. This is a common technique I use in my code, as it is considerably faster than using listwords and checking each value independantly. Brian Fries BrainScan Software On Nov 3, 2008, at 11:18 AM, 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 Brian Fries

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:

New public beta available (1997) ShowNext (1997) Running 2 two WebCatalog.acgi's (1996) Text data with spaces in them... (1997) webcat error log (1998) Another question about credit cards (1997) Speed Optimization - Mac (1997) SiteBuilder Problem (2004) SAVECART (1997) Emailer help....! (1997) Converting Quotes in Javascript (2001) RE: [WebDNA] [ReturnRaw] problem (2010) product differences (1999) changing names of Graphic files (2002) Tracking System? (1997) AAgghh!! Help, please. SSL strikes again. (1997) Web Catalog vs. ICAT (1997) denied access (1997) Frames and WebCat (1997) blank page from template (1997)