Re: How do I write this search?
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66589
interpreted = N
texte = [Search db=../orders.db&neSHIPPEDdatarq=F&eqAPPROVEDdatarq=T]If you don't flag unshipped orders ie marked as F[Search db=../orders.db&neSHIPPEDdatarq=[blank]&eqAPPROVEDdatarq=T]Stuart Tremainidfk web developments, sydney, australiaOn 30 Mar 2006, at 12:15 PM, WJ Starck wrote:> I have a database that contains the fields [approved] and [shipped] > that are flagged to T to indicate whether the credit card auth has > been approved and the item has shipped, respectively.>> I have a webpage that generates barcodes that we scan to create > shipping labels, so on this page I want to show only those records > that have been approved but *not* shipped.>> If I do:>> [search db=../ > orders.db&neshippeddata=T&asorderdatesort=1&astimesort=2]>> I get all records that have not been shipped in a second or two, > but this is not what I want.>> If I add &eqapproveddata=T to the above like so:>> [search db=../ > orders.db&neshippeddata=T&eqapproveddata=T&asorderdatesort=1&astimesor > t=2]>> the search takes a ridiculously long time to display the records > because it is or-ing the neshippedata and eqapproveddata fields, > and basically displaying all the approved records, which is just > about everything in the database.>> I want all the records that have been approved *and* not shipped.>> What's the solution?>> Do I need to group the fields somehow?>> -Will>>>>>> -------------------------------------------------------------> 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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
[Search db=../orders.db&neSHIPPEDdatarq=F&eqAPPROVEDdatarq=T]If you don't flag unshipped orders ie marked as F[Search db=../orders.db&neSHIPPEDdatarq=[blank]&eqAPPROVEDdatarq=T]Stuart Tremainidfk web developments, sydney, australiaOn 30 Mar 2006, at 12:15 PM, WJ Starck wrote:> I have a database that contains the fields [approved] and [shipped] > that are flagged to T to indicate whether the credit card auth has > been approved and the item has shipped, respectively.>> I have a webpage that generates barcodes that we scan to create > shipping labels, so on this page I want to show only those records > that have been approved but *not* shipped.>> If I do:>> [search db=../ > orders.db&neshippeddata=T&asorderdatesort=1&astimesort=2]>> I get all records that have not been shipped in a second or two, > but this is not what I want.>> If I add &eqapproveddata=T to the above like so:>> [search db=../ > orders.db&neshippeddata=T&eqapproveddata=T&asorderdatesort=1&astimesor > t=2]>> the search takes a ridiculously long time to display the records > because it is or-ing the neshippedata and eqapproveddata fields, > and basically displaying all the approved records, which is just > about everything in the database.>> I want all the records that have been approved *and* not shipped.>> What's the solution?>> Do I need to group the fields somehow?>> -Will>>>>>> -------------------------------------------------------------> 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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------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 Web Archive of this list is at: http://webdna.smithmicro.com/
Stuart Tremain
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:
Web Catalog vs. ICAT (1997)
Aaron kant add (or whatever it was) (2000)
NT - Thanks and Taxes (1997)
What am I missing (1997)
Environment Variables (2000)
Credit card processing - UK (1997)
Requiring that certain fields be completed (1997)
WebDNA Feature Request (2006)
OSX Webcatalog Install (2001)
BUG REPORT -- FINAL (1999)
WebCat2: Items xx to xx shown, etc. (1997)
Bug Report, maybe (1997)
RequiredFields template (1997)
Q: writefile and uploads. (1998)
WebCat2b13MacPlugIn - syntax to convert date (1997)
Help! WebCat2 bug (1997)
Moment of Thanks (1997)
[ShowNext] (1997)
Date problems-more (1997)
Forbidden CGI Error (1997)