Re: Trouble Searching
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22234
interpreted = N
texte = The 200 should not be there. Both values should be 19, or whatevere numberthe user enters. The exact code is as follows:[searchdb=database/pricing.db&leNUM.USERS.LOWdatarq=[users]&geNUM.USERS.HIGHdatarq=[users]&NUM.USERS.LOWtype=num&NUM.USERS.HIGHtype=num][numfound]
[founditems][NETG.COURSE.IT.NET.PURCH.PRICE][/founditems]The database is:NUM.USERS.LOW NUM.USERS.HIGH PRICE1 1 149.952 2 149.953 3 149.954 4 149.955 5 149.956 6 149.957 7 149.958 8 149.959 9 149.9510 10 149.9511 11 149.9512 12 149.9513 13 149.9514 14 149.9515 15 149.9516 16 149.9517 17 149.9518 18 2,570.0019 19 2,570.0020 20 2,570.0021 21 2,570.0022 22 2,570.0023 23 2,570.0024 24 2,570.0025 25 2,570.0026 50 2,570.0051 100 2,570.00101 250 2,570.00251 500 2,570.00501 999 2,570.001000 1999 2,570.002000 3499 2,570.003500 4999 2,570.005000 9999 2,570.0010000 24999 2,570.0025000 49999 2,570.0050000 74999 2,570.00---When I tried reversing le and ge I did get very abnormal results. It wouldreturn a record but the price would be something like 6500.00 and there isno such number in the db.Thanks,Josh At 10:31 PM 1/3/99, you wrote:>At 11:51 Uhr -0800 03.01.1999, josh@pop-art.com wrote:>>>The database has 3 fields that I am conserned with: num.users.low,>>num.users.high and price, so if I enter 19, it should return the record>>where 19 is greater than or equal to the num.users.low and 19 is less than>>or equal to them num.users.high. This does not work and all and I cannot>>find my bug.>>>>At 10:27 AM 1/2/99 -0800, you wrote:>>>>[search>>>>db=database/pricing.db&geNUM.USERS.LOWdatarq=19&leNUM.USERS.HIGHdatarq=200&N>>>>UM.USERS.LOWtype=num&NUM.USERS.HIGHtype=num]>>>>[numfound]
>>>>[/search]>>>What is the data in your database?>Are you sure that both search arguments apply to the same record?>If you have for example:>----->SKU num.users.low num.users.high price>1 10 20 200>2 20 100 2000>3 100 200 20000>----->Let's apply your first argument:>geNUM.USERS.LOWdatarq=19>in num.users.low 20 is greater than or equal to 19, so this points toSKU #2>>Then apply your second argument:>leNUM.USERS.HIGHdatarq=200>in num.users.high 200 is less than or equal to 200, so this points toSKU #3>>And you get nothing...>----->The value 19 comes from the user, you said - but where does the 200 comefrom?>But even with two 19's it would not work in this example.>You should post the few original fields in question, so we can see what you>want to do.>>>Peter>>++++++++++++++++++++++++++++++++++++++++++++++++>Peter Ostry - Vienna/Austria - www.ostry.com>Fon ++43-1-877 74 54 Fax ++43-1-877 74 54-21>++++++++++++++++++++++++++++++++++++++++++++++++>>>>---------------------------------------------------------------------------Joshua Blank Pop Art LLC http://pop-art.comjosh@pop-art.com eCommerce / Web Design / Multimedia7000 SW Hampton St. tel: (503) 968.5957Suite 124 fax: (503) 620.8487Portland, OR 97223-8361
Associated Messages, from the most recent to the oldest:
The 200 should not be there. Both values should be 19, or whatevere numberthe user enters. The exact code is as follows:[searchdb=database/pricing.db&leNUM.USERS.LOWdatarq=[users]&geNUM.USERS.HIGHdatarq=[users]&NUM.USERS.LOWtype=num&NUM.USERS.HIGHtype=num][numfound]
[founditems][NETG.COURSE.IT.NET.PURCH.PRICE][/founditems]The database is:NUM.USERS.LOW NUM.USERS.HIGH PRICE1 1 149.952 2 149.953 3 149.954 4 149.955 5 149.956 6 149.957 7 149.958 8 149.959 9 149.9510 10 149.9511 11 149.9512 12 149.9513 13 149.9514 14 149.9515 15 149.9516 16 149.9517 17 149.9518 18 2,570.0019 19 2,570.0020 20 2,570.0021 21 2,570.0022 22 2,570.0023 23 2,570.0024 24 2,570.0025 25 2,570.0026 50 2,570.0051 100 2,570.00101 250 2,570.00251 500 2,570.00501 999 2,570.001000 1999 2,570.002000 3499 2,570.003500 4999 2,570.005000 9999 2,570.0010000 24999 2,570.0025000 49999 2,570.0050000 74999 2,570.00---When I tried reversing le and ge I did get very abnormal results. It wouldreturn a record but the price would be something like 6500.00 and there isno such number in the db.Thanks,Josh At 10:31 PM 1/3/99, you wrote:>At 11:51 Uhr -0800 03.01.1999, josh@pop-art.com wrote:>>>The database has 3 fields that I am conserned with: num.users.low,>>num.users.high and price, so if I enter 19, it should return the record>>where 19 is greater than or equal to the num.users.low and 19 is less than>>or equal to them num.users.high. This does not work and all and I cannot>>find my bug.>>>>At 10:27 AM 1/2/99 -0800, you wrote:>>>>[search>>>>db=database/pricing.db&geNUM.USERS.LOWdatarq=19&leNUM.USERS.HIGHdatarq=200&N>>>>UM.USERS.LOWtype=num&NUM.USERS.HIGHtype=num]>>>>[numfound]
>>>>[/search]>>>What is the data in your database?>Are you sure that both search arguments apply to the same record?>If you have for example:>----->SKU num.users.low num.users.high price>1 10 20 200>2 20 100 2000>3 100 200 20000>----->Let's apply your first argument:>geNUM.USERS.LOWdatarq=19>in num.users.low 20 is greater than or equal to 19, so this points toSKU #2>>Then apply your second argument:>leNUM.USERS.HIGHdatarq=200>in num.users.high 200 is less than or equal to 200, so this points toSKU #3>>And you get nothing...>----->The value 19 comes from the user, you said - but where does the 200 comefrom?>But even with two 19's it would not work in this example.>You should post the few original fields in question, so we can see what you>want to do.>>>Peter>>++++++++++++++++++++++++++++++++++++++++++++++++>Peter Ostry - Vienna/Austria - www.ostry.com>Fon ++43-1-877 74 54 Fax ++43-1-877 74 54-21>++++++++++++++++++++++++++++++++++++++++++++++++>>>>---------------------------------------------------------------------------Joshua Blank Pop Art LLC http://pop-art.comjosh@pop-art.com eCommerce / Web Design / Multimedia7000 SW Hampton St. tel: (503) 968.5957Suite 124 fax: (503) 620.8487Portland, OR 97223-8361
josh@pop-art.com
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:
Pipes instead of tabs (1998)
WebCat2 - many [carts] on one template page? (1997)
all records returned. (1997)
math with a [numfound] (2005)
SEARCH Peram (2003)
limitation found on group searching (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Searching multiple Databases (1997)
WebCat2 Append problem (B14Macacgi) (1997)
Re2: Calculating multiple shipping... (1997)
WebDNA 5 - Privacy Issue (Built in sniffer) (2003)
Search/sort in URL Was: GuestBook example (1997)
eCommerce Idea Patented? (2002)
shownext (1997)
[WebDNA] grep again (2010)
[protect] on NT? (1997)
Secure server question (1997)
alternatives for WebDNA (2004)
Something about defining variables (1998)
no global [username] or [password] displayed ... (1997)