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 number the user enters. The exact code is as follows:[search db=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 PRICE 1 1 149.95 2 2 149.95 3 3 149.95 4 4 149.95 5 5 149.95 6 6 149.95 7 7 149.95 8 8 149.95 9 9 149.95 10 10 149.95 11 11 149.95 12 12 149.95 13 13 149.95 14 14 149.95 15 15 149.95 16 16 149.95 17 17 149.95 18 18 2,570.00 19 19 2,570.00 20 20 2,570.00 21 21 2,570.00 22 22 2,570.00 23 23 2,570.00 24 24 2,570.00 25 25 2,570.00 26 50 2,570.00 51 100 2,570.00 101 250 2,570.00 251 500 2,570.00 501 999 2,570.00 1000 1999 2,570.00 2000 3499 2,570.00 3500 4999 2,570.00 5000 9999 2,570.00 10000 24999 2,570.00 25000 49999 2,570.00 50000 74999 2,570.00--- When I tried reversing le and ge I did get very abnormal results. It would return a record but the price would be something like 6500.00 and there is no 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=2 00&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 to SKU #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 to SKU #3 > >And you get nothing... >----- >The value 19 comes from the user, you said - but where does the 200 come from? >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.com josh@pop-art.com eCommerce / Web Design / Multimedia7000 SW Hampton St. tel: (503) 968.5957 Suite 124 fax: (503) 620.8487 Portland, OR 97223-8361 Associated Messages, from the most recent to the oldest:

    
  1. Re: Trouble Searching (The Mooseman 1999)
  2. Re: Trouble Searching (josh@pop-art.com 1999)
  3. Re: Trouble Searching (Bob Minor 1999)
  4. Re: Trouble Searching (Kenneth Grome 1999)
  5. Re: Trouble Searching (Peter Ostry 1999)
  6. Re: Trouble Searching (josh@pop-art.com 1999)
  7. Re: Trouble Searching (PCS Technical Support 1999)
  8. Re: Trouble Searching (josh@pop-art.com 1999)
  9. Re: Trouble Searching (Kenneth Grome 1999)
  10. Trouble Searching (josh@pop-art.com 1999)
The 200 should not be there. Both values should be 19, or whatevere number the user enters. The exact code is as follows:[search db=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 PRICE 1 1 149.95 2 2 149.95 3 3 149.95 4 4 149.95 5 5 149.95 6 6 149.95 7 7 149.95 8 8 149.95 9 9 149.95 10 10 149.95 11 11 149.95 12 12 149.95 13 13 149.95 14 14 149.95 15 15 149.95 16 16 149.95 17 17 149.95 18 18 2,570.00 19 19 2,570.00 20 20 2,570.00 21 21 2,570.00 22 22 2,570.00 23 23 2,570.00 24 24 2,570.00 25 25 2,570.00 26 50 2,570.00 51 100 2,570.00 101 250 2,570.00 251 500 2,570.00 501 999 2,570.00 1000 1999 2,570.00 2000 3499 2,570.00 3500 4999 2,570.00 5000 9999 2,570.00 10000 24999 2,570.00 25000 49999 2,570.00 50000 74999 2,570.00--- When I tried reversing le and ge I did get very abnormal results. It would return a record but the price would be something like 6500.00 and there is no 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=2 00&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 to SKU #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 to SKU #3 > >And you get nothing... >----- >The value 19 comes from the user, you said - but where does the 200 come from? >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.com josh@pop-art.com eCommerce / Web Design / Multimedia7000 SW Hampton St. tel: (503) 968.5957 Suite 124 fax: (503) 620.8487 Portland, 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)