Re: [WebDNA] Filtering exact numbers

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101318
interpreted = N
texte = Hello Suzanne, have you been using "Searching - Word Breaks FieldNameword=3DXX" What have you been using for "Comparisons FieldNamecomp=3DXX" ?? Suzanne Swift a =E9crit : > Hi, > > I'm trying to filter serial numbers and have run into a glitch in my=20 > 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=3Dmyfirst.db] > [text] TheList =3D[/text] > > [founditems] > [text]TheList=3D[TheList][SerialNumberFromDatabaseOne] [/text] > [/founditems] > > Step 2: Compare this list to a 2nd list of serial numbers, also=20 > generated by a search, and include only serial numbers that are on=20 > both lists > > [search db=3Dmysecond.db] > > [founditems] > > [showif [url] [TheList][/url]^[url][SerialNumberFromDatabaseTwo][/url]] > > The problem I am running into is that some of the values included in=20 > [TheList] are very long (i.e. 79873966092380) and some of the values=20 > for [SerialNumberFromDatabaseTwo] are very short (i.e. 3966) so on=20 > occasion the value of a "SerialNumberFromDatabaseTwo" is found WITHIN=20 > a value of a SerialNumberFromDatabaseOne that appears on "TheList" so=20 > 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=20 > only if it exactly matches an entire serial#? > > Thanks! > Suzanne Swift > SpecSimple.com > > Where the World of Design Connects > > > --------------------------------------------------------- > 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)
Hello Suzanne, have you been using "Searching - Word Breaks FieldNameword=3DXX" What have you been using for "Comparisons FieldNamecomp=3DXX" ?? Suzanne Swift a =E9crit : > Hi, > > I'm trying to filter serial numbers and have run into a glitch in my=20 > 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=3Dmyfirst.db] > [text] TheList =3D[/text] > > [founditems] > [text]TheList=3D[TheList][SerialNumberFromDatabaseOne] [/text] > [/founditems] > > Step 2: Compare this list to a 2nd list of serial numbers, also=20 > generated by a search, and include only serial numbers that are on=20 > both lists > > [search db=3Dmysecond.db] > > [founditems] > > [showif [url] [TheList][/url]^[url][SerialNumberFromDatabaseTwo][/url]] > > The problem I am running into is that some of the values included in=20 > [TheList] are very long (i.e. 79873966092380) and some of the values=20 > for [SerialNumberFromDatabaseTwo] are very short (i.e. 3966) so on=20 > occasion the value of a "SerialNumberFromDatabaseTwo" is found WITHIN=20 > a value of a SerialNumberFromDatabaseOne that appears on "TheList" so=20 > 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=20 > only if it exactly matches an entire serial#? > > Thanks! > Suzanne Swift > SpecSimple.com > > Where the World of Design Connects > > > --------------------------------------------------------- > 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/ > Lawrence

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:

version 2 for NT (1997) Plugin or CGI or both (1997) Password and Allow commands (1998) Multi Actions (1999) 100% cpu load (2006) maybe even an easier plan to satisfy need for solid tech support? (2000) Replace Statement (1997) old 3.0 mac license for sale? (2003) b18 problem on NT 4.0 (1997) [INCLUDE] Limitations (1998) New Business Opportunity (2006) transaction logging (2002) HomePage Caution (1997) Authenticate (1997) Multiple Ad databases? (1997) Rhapsody? (1997) help! problem using [referrer] still in 2.01 (1997) too many nested ... problem (1997) [WebDNA] WebDNA on PowerPC Leopard Server (2009) Middle Context (2002)