Re: Creating results....

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 50637
interpreted = N
texte = TITLE ITEM COLOR SIZE INVENTORY Shirts T-Shirt Black L 10 Shirts T-Shirt Black M 0 Shirts T-Shirt Black S 4 Shirts T-Shirt White L 2Finds every black T-shirt of the size = [_SIZE] that is in stock or INVENTORY > 0.[Search db=database.db &eqITEMdatarq=T-Shirt &eqCOLORdatarq=Black&eqSIZEdatarq=[ _SIZE]&grINVENTORYdatarq=0] [FoundItems] Title = [TITLE] Product= [ITEM ] Color= [COLOR] Size = [SIZE] Qty in Stock = [INVENTORY] [/FoundItems] [/Search]MKOn Friday, May 23, 2003, at 03:32 AM, Alan White wrote:> Hi > > Here is some logic for what I am trying to do. > > I am trying to pull records out of a database that match a size chosen > on > the previous page that have inventory greater than 0. > > The size being passed has been set as the_SIZE and the field in the > database > that holds the sizes is called SIZES. Once I have a match I want to > pull > out the product title which is TITLE. > > All products are identified by a field called SKU. > > Any suggestions folks? I know my search has to contain (or at least I > think > it does):- > > [search db=database.db& > eqSIZESdatarq=the_SIZE&grNO_INVENTORYdatarq=0&NO_INVENTORYtype=num..... > ..] > > Beyond here I am a little stuck... > > Hope you can help. > > Alan > ------------------------------ > http://www.streethreds.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/ > > Signed: Marc Kaiwi ------------------------------------------------------------- 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:

    
  1. Re: Creating results.... (marc@kaiwi.com (Marc Kaiwi) 2003)
  2. Creating results.... (Alan White 2003)
TITLE ITEM COLOR SIZE INVENTORY Shirts T-Shirt Black L 10 Shirts T-Shirt Black M 0 Shirts T-Shirt Black S 4 Shirts T-Shirt White L 2Finds every black T-shirt of the size = [_SIZE] that is in stock or INVENTORY > 0.[Search db=database.db &eqITEMdatarq=T-Shirt &eqCOLORdatarq=Black&eqSIZEdatarq=[ _SIZE]&grINVENTORYdatarq=0] [founditems] Title = [TITLE] Product= [ITEM ] Color= [COLOR] Size = [SIZE] Qty in Stock = [INVENTORY] [/FoundItems] [/Search]MKOn Friday, May 23, 2003, at 03:32 AM, Alan White wrote:> Hi > > Here is some logic for what I am trying to do. > > I am trying to pull records out of a database that match a size chosen > on > the previous page that have inventory greater than 0. > > The size being passed has been set as the_SIZE and the field in the > database > that holds the sizes is called SIZES. Once I have a match I want to > pull > out the product title which is TITLE. > > All products are identified by a field called SKU. > > Any suggestions folks? I know my search has to contain (or at least I > think > it does):- > > [search db=database.db& > eqSIZESdatarq=the_SIZE&grNO_INVENTORYdatarq=0&NO_INVENTORYtype=num..... > ..] > > Beyond here I am a little stuck... > > Hope you can help. > > Alan > ------------------------------ > http://www.streethreds.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/ > > Signed: Marc Kaiwi ------------------------------------------------------------- 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/ marc@kaiwi.com (Marc Kaiwi)

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:

PCS Frames-Default page is solution! (1997) Bad card db - *mislabled post* (1999) [listfiles] problems (1997) A little syntax help (1997) [subtotal] and others (1997) Make sure I understand this??? (1997) WebCatalog/Mac 2.1b2 New Features (1997) The Classifieds template set (2003) [isfile] ? (1997) F3 crashing server (1997) Question... (2002) Show shoppingcart after remove last item (1997) How to set up searching - properly (2000) WebCat2b15MacPlugin - showing [math] (1997) Anyone have an invoicing system? (1999) PSC recommends what date format yr 2000??? (1997) Unique value creation (1999) Multiple fields on 1 input (1997) Include a big block of text (1997) passing large amount of text in post form (2005)