[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 SwiftSpecSimple.comWhere the World of Design Connects
Associated Messages, from the most recent to the oldest:
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 SwiftSpecSimple.comWhere 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:
Tax Moratorium Expiring (2001)
Location of Browser Info.txt file (1997)
Question about replacing words (1998)
PCS Frames (1997)
Extended [ConvertChars] (1997)
dates as search criteria (2000)
auto-stripping of spaces (1997)
webcat2b12 CGI -- Date comparisons (1997)
[OT] Disable/enable field (2003)
Emailer tracking (1997)
I think WebDNA-Talk died ... :( (1997)
WebCatalog Hosting (1996)
format rounding?! (2001)
Almost a there but..bye bye NetCloak (1997)
Snake Bites (1997)
Can't load tmpl files (1997)
Problem (1997)
OFF TOPIC: Sendmail problem (2003)
Where is f2? (1997)
WebCatalog 2.0 b 15 mac (1997)