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:
unitshipcost vs shipcosts (1997)
Emailer setup (1997)
A Suggestion? (1998)
For those of you not on the WebCatalog Beta... (1997)
NetSplat and WebCat2 (1997)
Search Command, multiple dbs, etc. --still confused (2000)
Parameter Problem (1998)
[LookUp] (1999)
webcat and OS 8 (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Design Help Needed (1998)
Checkboxes and neSKUdata=[blank] (1998)
Ampersand Character (&) (1997)
WebCatalog Upgrade Pricing? (1997)
Cart # Starting at 1000 (2000)
[PROTECT] Problem (2003)
Kaaaaahhhhhhhnnnnnnn! (1997)
name of file (2002)
[OT] Server check please (2006)
WebCat (2000)