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

NT challenges default admin/admin password (2000) More on the email templates (1997) WebCat2 beta 11 - new prefs ... (1997) Cart ID Duplication (2001) Before I Can Begin . . . (1998) Price lookup problem - was Cart questions (1997) Weird Errors (2007) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) [WebDNA] Receive JSON POST (2019) delayed email response (2005) read and write you own cookies with webcat (1997) Execute Applescript (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Shopping problems with 2.1b3 acgi (1997) HELP WITH DATES (1997) No luck with taxes (1997) What the *(**&^* webcat/mer (1998) emailer (1997) I forgot (1998) New Command prefs ... (1997)