Re: [WebDNA] Filtering exact numbers
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101319
interpreted = N
texte = You're not posting the actual code you're using. Please post the actual code then we can fix it for you so it works the way you want.Sincerely,Ken Grome> 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>>> ---------------------------------------------------------> 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:
You're not posting the actual code you're using. Please post the actual code then we can fix it for you so it works the way you want.Sincerely,Ken Grome> 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>>> ---------------------------------------------------------> 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/
Kenneth Grome
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:
WC Bulletin Board Issue (2003)
Garbage files created -METOO (2000)
OT: Poll Results (2002)
Difficult Alternating Problem (2001)
redirect with frames (1997)
appleshare/ip (1997)
(1997)
Virtual hosting and webcatNT (1997)
[Webcat 2]Next (1997)
[WebDNA] Grep out square brackets? (2010)
[WebDNA] Best WebDNA version for OS X Server 10.5.8 on PowerPC? (2010)
Summing fields (1997)
Tea Room trouble (1997)
[Announce] Newest Commerce Site based on WebCatalog (1997)
Limitations on fields? Server is crashing (1997)
Re:multiple digests, please stop (1997)
[WebDNA] Decode Base64 Image (2019)
Location of Webcat site in folder hierarchy (1997)
Sorry I didn't pay attention-but ??? (1997)
OT Pager notification of completed orders (1998)