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, Will On 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, Will On 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:
Forumulas.db & Variables (2002)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Suggestions (1998)
database editor add field, etc. (2005)
Linux WebDNA Server probs (2004)
f2 download problems (1997)
Using Currencies other than Dollars (1997)
[include file=filename.inc&strip=t] (2002)
Installing on IIS 5.1 Windows XP Pro - Username/Password (2006)
showif and cart (1997)
NT [delete] (1998)
upgrading (1997)
Mac Lockup Problems (1998)
Bug or syntax error on my part? (1997)
[WebDNA] WebDNA glitch, no response required ... (2009)
AppleShare IP 6.1 (1998)
New NT beta available (1997)
RequiredFields template (1997)
Help name our technology! I found it (1997)