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 INVENTORYShirts T-Shirt Black L 10Shirts T-Shirt Black M 0Shirts T-Shirt Black S 4Shirts 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:
TITLE ITEM COLOR SIZE INVENTORYShirts T-Shirt Black L 10Shirts T-Shirt Black M 0Shirts T-Shirt Black S 4Shirts 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)