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:

Some ThankYou page problems (1997) [WebDNA] SEARCH question - SHOWIF - HIDEIF question (2011) WCS Newbie question (1997) PCS Frames (1997) WebCat cannot handle compatible search parameters? (1997) Not really WebCat (1997) Imagemagick and fonts -- Success! (2004) select multiple (1997) Strange intermittent WebDNA problems (2008) dos performance (1998) emailer on Windows Beta 18 (1997) WHY SO MANY DUPLICATES? (1999) creating an email message (1998) WebCatalog for Postcards ? (1997) syntax question, not in online refernce (1997) Email (1998) Dreamweaver extensions [reprise] (2000) Pirated WebCat? NOT... (2003) Postprocessing CCs (2000) Thanks Grant (1997)