Re: Trouble Searching
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22230
interpreted = N
texte = 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 price1 10 20 2002 20 100 20003 100 200 20000-----Let's apply your first argument:geNUM.USERS.LOWdatarq=19in num.users.low 20 is greater than or equal to 19, so this points to SKU #2Then apply your second argument:leNUM.USERS.HIGHdatarq=200in num.users.high 200 is less than or equal to 200, so this points to SKU #3And 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 youwant to do.Peter++++++++++++++++++++++++++++++++++++++++++++++++Peter Ostry - Vienna/Austria - www.ostry.comFon ++43-1-877 74 54 Fax ++43-1-877 74 54-21++++++++++++++++++++++++++++++++++++++++++++++++
Associated Messages, from the most recent to the oldest:
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 price1 10 20 2002 20 100 20003 100 200 20000-----Let's apply your first argument:geNUM.USERS.LOWdatarq=19in num.users.low 20 is greater than or equal to 19, so this points to SKU #2Then apply your second argument:leNUM.USERS.HIGHdatarq=200in num.users.high 200 is less than or equal to 200, so this points to SKU #3And 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 youwant to do.Peter++++++++++++++++++++++++++++++++++++++++++++++++Peter Ostry - Vienna/Austria - www.ostry.comFon ++43-1-877 74 54 Fax ++43-1-877 74 54-21++++++++++++++++++++++++++++++++++++++++++++++++
Peter Ostry
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:
Backwards list behavior ... (1997)
No Data Results (1997)
WebCat.acgi from /cgi-bin/? (1997)
Search/sort in URL Was: GuestBook example (1997)
expired beta (1997)
RequiredFields template (1997)
Need correct syntax for writing to header2 (1999)
Generating unique SKU from [cart] - FIXED! (1997)
Using Cookie for client specific info? (1997)
Tax and Shipping Examples (1997)
Dummy Credit Card Number for debug? (1997)
Calculating multiple shipping... (1997)
Does not begin with.... (2003)
Sizes and colors (1999)
[OT] Happy Turkey Day! (2003)
webcat2b12 CGI -- Date comparisons (1997)
EMailer - WebSTAR V - OSX - WebDNA (2003)
Debug mode (1999)
Look out kiwis! (2003)
WebCatalog for Mac 2.0.1 Released (1997)