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:
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)