[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:

searchable list archive (1997) database size? (1997) related data (2003) NTbeta18 corrupted? (1997) [WebDNA] WebDNA future (2010) WebCat2 - [format thousands] (1997) Email within tmpl ? (1997) [format 40s]text[/format] doesn't work (1997) [WebDNA] HTML [sendmail] revisited (2009) Webmerchant 3.08: Help! Error Can't open order file.Ignoring [Orderfile] context (2000) Cart contains # (2000) SKU lookup (1997) Emailer (WebCat2) (1997) Database Options (1997) [defined]ish (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) maximu values for sendmail! (1997) Problem with [Search] inside of [Loop]? (1997) Is this possible, WebCat2.0 and checkboxes (1997) Math, Multiple Equasions and Show/Hide (1998)