Re: How do I write this search?
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66591
interpreted = N
texte = Ah yes, that's it. Thought it might be something simple.I had tried[Search db=../orders.db&neSHIPPEDdata=T&eqAPPROVEDdatarq=T](neglecting to rq the SHIPPEDdata field)but I see the logic now.Thank you,WillOn Mar 29, 2006, at 7:51 PM, Stuart Tremain wrote:> Sorry>> Not shipped, have been approved.>> You need the RQ = required>>> [Search db=../orders.db&neSHIPPEDdatarq=T&eqAPPROVEDdatarq=T]>>> Stuart Tremain> idfk web developments, sydney, australia>>> On 30 Mar 2006, at 12:46 PM, Stuart Tremain wrote:>>> [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 Tremain>> idfk web developments, sydney, australia>>>>>> On 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&astimes >>> ort=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 > 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 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:
Ah yes, that's it. Thought it might be something simple.I had tried[Search db=../orders.db&neSHIPPEDdata=T&eqAPPROVEDdatarq=T](neglecting to rq the SHIPPEDdata field)but I see the logic now.Thank you,WillOn Mar 29, 2006, at 7:51 PM, Stuart Tremain wrote:> Sorry>> Not shipped, have been approved.>> You need the RQ = required>>> [Search db=../orders.db&neSHIPPEDdatarq=T&eqAPPROVEDdatarq=T]>>> Stuart Tremain> idfk web developments, sydney, australia>>> On 30 Mar 2006, at 12:46 PM, Stuart Tremain wrote:>>> [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 Tremain>> idfk web developments, sydney, australia>>>>>> On 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&astimes >>> ort=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 > 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 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/
WJ Starck
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:
[WriteFile] problems (1997)
Undeclared variables (2004)
Calculating multiple shipping... (1997)
[/application] error? (1997)
Tab Charactor (1997)
Sort Order on a page search (1997)
cart file creation (2003)
Cut off from the list and can't get an answer to the confused re:QTY price updating question (1998)
WebCat2b13MacPlugIn - [include] (1997)
shipcost (1997)
If Empty ? (1997)
Running _every_ page through WebCat ? (1997)
Applescript error (1998)
[OT] See Flash? (2003)
Removing a character (2000)
Goofy Date Sorting (1998)
Windows-based Code Editor (2002)
Requiring that certain fields be completed (1997)
Webmerchant/Cybercash (2000)
Emailer not working (1998)