Re: Table sorting by selected category then others

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58076
interpreted = N
texte = Gary, The code below is completely off the top of my head and untested, however it "should" accomplish what you are trying todo. Jesse [search db=database.db&eqBRANDdatarq=[url][BRAND][/url]&neCATEGORYdatarq=[url][CATEG ORY][/url]] [founditems] [text show=f]CAT[INDEX]=[CATEGORY][/text] [/founditems] [/search] [search db=database.db&eqBRANDdatarq=[url][BRAND][/url]&eqCATEGORYdatarq=[CAT2]]
[CATEGORY][CATEGORY]
[search db=databse.db&eqBRANDdatarq=[url][BRAND][/url]&eqCATEGORYdatarq=[url][CATEGO RY][/url]] [founditems] [/founditems]
[ITEM]
[/search] 		[search db=database.db&eqBRANDdatarq=[url][BRAND][/url]&eqCATEGORYdatarq=[CAT1]] [founditems] [/founditems]
[ITEM]
[/search]
[founditems] [/founditems]
[ITEM]
[/search] ----- Original Message ----- From: "Gary Krockover" To: "WebDNA Talk" Sent: Wednesday, May 26, 2004 7:05 PM Subject: Table sorting by selected category then others > Wondering if someone has done this already and might be willing to share code: > > database: > sku category brand title > > (straight forward) > > Visitor clicks on category and then clicks on a brand from that > category. Easy enough. > > Now, I want the results page to show in a 3 column table in this order, for > only this brand selected but all categories: > > BRAND X > > > CATEGORY SELECTED | NEXT CATEGORY | NEXT CATEGORY > item1 | item1 this cat | item1 this cat > item2 | item2 this cat | item2 this cat > item3 | item3 this cat | item3 this cat > > > The variables are passed to the page as: > results.html?brand=[url][brand][/url]&category=[url][category][/url] > > TIA, > GK > > > ------------------------------------------------------------- > 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/ > > ------------------------------------------------------------- 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: Table sorting by selected category then others -SOLUTION ( Gary Krockover 2004)
  2. Re: Table sorting by selected category then others ( Gary Krockover 2004)
  3. Re: Table sorting by selected category then others ( "Jesse Crofoot" 2004)
  4. Re: Table sorting by selected category then others ( "Jesse Crofoot" 2004)
  5. Table sorting by selected category then others ( Gary Krockover 2004)
Gary, The code below is completely off the top of my head and untested, however it "should" accomplish what you are trying todo. Jesse [search db=database.db&eqBRANDdatarq=[url][BRAND][/url]&neCATEGORYdatarq=[url][CATEG ORY][/url]] [founditems] [text show=f]CAT[INDEX]=[CATEGORY][/text] [/founditems] [/search] [search db=database.db&eqBRANDdatarq=[url][BRAND][/url]&eqCATEGORYdatarq=[CAT2]]
[CATEGORY][CATEGORY]
[search db=databse.db&eqBRANDdatarq=[url][BRAND][/url]&eqCATEGORYdatarq=[url][CATEGO RY][/url]] [founditems] [/founditems]
[ITEM]
[/search] 		[search db=database.db&eqBRANDdatarq=[url][BRAND][/url]&eqCATEGORYdatarq=[CAT1]] [founditems] [/founditems]
[ITEM]
[/search]
[founditems] [/founditems]
[ITEM]
[/search] ----- Original Message ----- From: "Gary Krockover" To: "WebDNA Talk" Sent: Wednesday, May 26, 2004 7:05 PM Subject: Table sorting by selected category then others > Wondering if someone has done this already and might be willing to share code: > > database: > sku category brand title > > (straight forward) > > Visitor clicks on category and then clicks on a brand from that > category. Easy enough. > > Now, I want the results page to show in a 3 column table in this order, for > only this brand selected but all categories: > > BRAND X > > > CATEGORY SELECTED | NEXT CATEGORY | NEXT CATEGORY > item1 | item1 this cat | item1 this cat > item2 | item2 this cat | item2 this cat > item3 | item3 this cat | item3 this cat > > > The variables are passed to the page as: > results.html?brand=[url][brand][/url]&category=[url][category][/url] > > TIA, > GK > > > ------------------------------------------------------------- > 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/ > > ------------------------------------------------------------- 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/ "Jesse Crofoot"

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:

Sending Mail Confirmation (2002) Last digit of Credit Card Stripped (1997) Spelling Checker (2003) Passing WebCat data to SSL server (1997) WC2.0 Memory Requirements (1997) Stat analyzer (1997) [GROUPS] followup (1997) Sum of Quantities (1997) DataBaseHelper Flawed (1997) Purchased cart being overwritten - still !?? (1997) ACGI processing for .html (1997) Are you an WC expert? (1997) Calculating multiple shipping... (1997) Tracking System? (1997) SSL and reg web* (1997) [format xs] freeze (1997) How to include weather (2000) Signal Raised Error (Part II) (1997) Highlighting words found in a keyword search (2003) Searchable list archive (1997)