How do I write this search?
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66588
interpreted = N
texte = 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&astimesort= 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
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&astimesort= 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 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:
WebCatalog for Postcards ? (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
PCS Emailer's role ? (1997)
Shipping.db (1998)
WebCat2 - [format thousands] (1997)
mail on NT (1998)
webcat and webkitty votes needed (1997)
Frames and WebCat (1997)
Problems appending to database (1997)
error No such file (2001)
Can you do this??? and other stuff (1997)
frames & carts (1997)
Cookies (1999)
Weird Math (2000)
WC Database Format (1997)
Shipping Calc - done (1998)
Limiting user access to .tmpl files (1997)
Re:no template caching (1997)
Changes to the List (1997)
Order not created error (never mind) (1997)