Re: How do I write this search?
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66592
interpreted = N
texte = Odd. It works as expected-almost. The first record that is not shipped and not approved shows up in the list. The later ones don't. The other records that are not shipped but approved show up properly. Any idea why? -Will On Mar 29, 2006, at 8:02 PM, WJ Starck wrote: > 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&astime >>>> sort=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 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:
Odd. It works as expected-almost. The first record that is not shipped and not approved shows up in the list. The later ones don't. The other records that are not shipped but approved show up properly. Any idea why? -Will On Mar 29, 2006, at 8:02 PM, WJ Starck wrote: > 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&astime >>>> sort=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 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:
Re:listfiles-looking for slick solution (1997)
Execute Applescript (1997)
anyone using encrypted templates on non-US NT OS (1999)
Double postings (2000)
Multiple prices (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
carriage returns in data (1997)
Two options to consider (2008)
Nested tags count question (1997)
Re:E-mailer application times out (1998)
and vs or vs not (1998)
[math] show=F exists? (1997)
encryption in browser? (1998)
looking for developers with solutions (2000)
WebCat Sites Hanging (!) (2003)
PCS Frames (1997)
6.0 /Panther install issues (2004)
Where's Cart Created ? (1997)
anyone about? (2004)
Trouble with formula.db (1997)