[WebDNA] Filtering exact numbers

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101317
interpreted = N
texte = Hi, I'm trying to filter serial numbers and have run into a glitch in my programming. Can anyone see how to fix it? Here's what I'm trying to do: Step 1: Generate a list of serial numbers using a standard search [search db=myfirst.db] [text] TheList =[/text] [founditems] [text]TheList=[TheList][SerialNumberFromDatabaseOne] [/text] [/founditems] Step 2: Compare this list to a 2nd list of serial numbers, also generated by a search, and include only serial numbers that are on both lists [search db=mysecond.db] [founditems] [showif [url] [TheList][/url]^[url][SerialNumberFromDatabaseTwo][/url]] The problem I am running into is that some of the values included in [TheList] are very long (i.e. 79873966092380) and some of the values for [SerialNumberFromDatabaseTwo] are very short (i.e. 3966) so on occasion the value of a "SerialNumberFromDatabaseTwo" is found WITHIN a value of a SerialNumberFromDatabaseOne that appears on "TheList" so data for serial numbers that don't "match" is included in my results. Is there any way to allow the value of a "SerialNumber" to be shown only if it exactly matches an entire serial#? Thanks! Suzanne Swift SpecSimple.com Where the World of Design Connects 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)
Hi, I'm trying to filter serial numbers and have run into a glitch in my programming. Can anyone see how to fix it? Here's what I'm trying to do: Step 1: Generate a list of serial numbers using a standard search [search db=myfirst.db] [text] TheList =[/text] [founditems] [text]TheList=[TheList][SerialNumberFromDatabaseOne] [/text] [/founditems] Step 2: Compare this list to a 2nd list of serial numbers, also generated by a search, and include only serial numbers that are on both lists [search db=mysecond.db] [founditems] [showif [url] [TheList][/url]^[url][SerialNumberFromDatabaseTwo][/url]] The problem I am running into is that some of the values included in [TheList] are very long (i.e. 79873966092380) and some of the values for [SerialNumberFromDatabaseTwo] are very short (i.e. 3966) so on occasion the value of a "SerialNumberFromDatabaseTwo" is found WITHIN a value of a SerialNumberFromDatabaseOne that appears on "TheList" so data for serial numbers that don't "match" is included in my results. Is there any way to allow the value of a "SerialNumber" to be shown only if it exactly matches an entire serial#? Thanks! Suzanne Swift SpecSimple.com Where the World of Design Connects 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:

Firesite and [referrer] atg broke (1997) Sendmail doesn't (was Queertrons?) (1997) How do I get Google to crawl a WebCat site? (2003) Reversed words (1997) Re[2]: Weird [blank] interpretation (1999) $Quit, $CloseDatabase corrections (1997) Shopping Cart Limits? (1998) Protect (1997) WebDNA Solutions ... sorry! (1997) RequiredFields parameter (1998) can WC render sites out? (1997) Help formatting search results w/ table (1997) WebCat2: Items xx to xx shown, etc. (1997) Strange Crash (1998) Exclamation point (1997) Re:2nd WebCatalog2 Feature Request (1996) WebCat2.0 [format thousands .0f] no go (1997) Multiple Admins through users.db (1997) Multiple 'Users.db' files not possible (1997) WebCatalog-NT?'s (1996)