Searching blank fields problem
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 24975
interpreted = N
texte = Hi!I'm having a problem with searching blank fields (and I have indeed consulted the blank/empty fields portion of the manual). Here's the search code:[search db=test.db&eqorderdatarq=[ordernumber]&wagroup1datarq=[blank]&group1fi eld=firstfield+secondfield+thirdfield+fourthfield]I'm passing [ordernumber] from a previous page. In my test case, I've got one order for which there are 11 entries in the db. In one of those entries, some of the fields are blank (as in nothing between the tabs in the db), but in all of the other 10 cases, the fields have data.When I run this search, I'm getting all 11 entries returned to me, even though only one of them contains no data in firstfield, secondfield, thirdfield, and fourthfield.Any ideas what I'm doing wrong here?Thanks for any suggestions,MauriceMaurice Rickard | GreenMarketplace.com: Director of Creative & Production | Natural Products for you http://www.greenmarketplace.com/ | and your planet.------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
Hi!I'm having a problem with searching blank fields (and I have indeed consulted the blank/empty fields portion of the manual). Here's the search code:[search db=test.db&eqorderdatarq=[ordernumber]&wagroup1datarq=[blank]&group1fi eld=firstfield+secondfield+thirdfield+fourthfield]I'm passing [ordernumber] from a previous page. In my test case, I've got one order for which there are 11 entries in the db. In one of those entries, some of the fields are blank (as in nothing between the tabs in the db), but in all of the other 10 cases, the fields have data.When I run this search, I'm getting all 11 entries returned to me, even though only one of them contains no data in firstfield, secondfield, thirdfield, and fourthfield.Any ideas what I'm doing wrong here?Thanks for any suggestions,MauriceMaurice Rickard | GreenMarketplace.com: Director of Creative & Production | Natural Products for you http://www.greenmarketplace.com/ | and your planet.------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Maurice Rickard
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:
FAX orders (1996)
911: testing if the field is empty (2000)
Guestbook (2000)
Some shell fun (2004)
The IBC root beer has arrived! (1997)
Bug Report, maybe (1997)
ASP Developer (1999)
WebCatalog for Postcards ? (1997)
[WebDNA] Clean URLS job - will pay (2010)
Deleting Orders (1997)
RE: protect tag on NT (1997)
Add more fields to an existent data base (1997)
Running 2 two WebCatalog.acgi's (1996)
[BULK] [WebDNA] (2017)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Moment of Thanks (1997)
[text] doesn't change [formvariables] (1999)
Banner Rotation (2000)
Great product and great job ! (1997)