Re: Related database

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 26762
interpreted = N
texte = Hi Bert,I do what you are asking about:I have this in my detail.tpl: (within a [founditems] that has found a record from the product.db)[showif [hasSizes]=T]


Please choose size before adding to cart: [/showif]All you have to do is populate the [sizeHTML] field in your products.db with the unique size options for that SKU.Any other angle you are asking about?-John…©rßa wrote:> Morning, > > I made a shop with items like clothes and cd's, some of the items have > sizes, but not all the items have the same kind of sizes (example: item > 10003 has L and XL, item 10002 has M, L, and XL. > I managed to create the related.db with correct settings, i only don't know > how to include it in the results and detail pages. Some tips would be > greatly appreciated..:)) > > related.db: > > 1 10002 1 [__C_RANK] O M 1 > 2 10002 1 [__C_RANK] O L 2 > 3 10002 1 [__C_RANK] O XL 3 > 1 10003 1 [__C_RANK] O M 1 > 2 10003 1 [__C_RANK] O L 2 > 3 10003 1 [__C_RANK] O XL 3 > 2 10091 1 [__C_RANK] O L 2 > 3 10091 1 [__C_RANK] O XL 3 > 2 10092 1 [__C_RANK] O L 2 > 3 10092 1 [__C_RANK] O XL 3 > 2 10093 1 [__C_RANK] O L 2 > 3 10093 1 [__C_RANK] O XL 3 > 1 40001 1 [__C_RANK] O M 1 > 2 40001 1 [__C_RANK] O L 2 > 3 40001 1 [__C_RANK] O XL 3 > 2 40002 1 [__C_RANK] O L 2 > 3 40002 1 [__C_RANK] O XL 3 > 1 40003 1 [__C_RANK] O M 1 > 2 40003 1 [__C_RANK] O L 2 > 3 40003 1 [__C_RANK] O XL 3 > > Bert > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: Related database (John Butler 2000)
  2. Related database (…©rßa 2000)
Hi Bert,I do what you are asking about:I have this in my detail.tpl: (within a [founditems] that has found a record from the product.db)[showif [hasSizes]=T]


Please choose size before adding to cart: [/showif]All you have to do is populate the [sizeHTML] field in your products.db with the unique size options for that SKU.Any other angle you are asking about?-John…©rßa wrote:> Morning, > > I made a shop with items like clothes and cd's, some of the items have > sizes, but not all the items have the same kind of sizes (example: item > 10003 has L and XL, item 10002 has M, L, and XL. > I managed to create the related.db with correct settings, i only don't know > how to include it in the results and detail pages. Some tips would be > greatly appreciated..:)) > > related.db: > > 1 10002 1 [__C_RANK] O M 1 > 2 10002 1 [__C_RANK] O L 2 > 3 10002 1 [__C_RANK] O XL 3 > 1 10003 1 [__C_RANK] O M 1 > 2 10003 1 [__C_RANK] O L 2 > 3 10003 1 [__C_RANK] O XL 3 > 2 10091 1 [__C_RANK] O L 2 > 3 10091 1 [__C_RANK] O XL 3 > 2 10092 1 [__C_RANK] O L 2 > 3 10092 1 [__C_RANK] O XL 3 > 2 10093 1 [__C_RANK] O L 2 > 3 10093 1 [__C_RANK] O XL 3 > 1 40001 1 [__C_RANK] O M 1 > 2 40001 1 [__C_RANK] O L 2 > 3 40001 1 [__C_RANK] O XL 3 > 2 40002 1 [__C_RANK] O L 2 > 3 40002 1 [__C_RANK] O XL 3 > 1 40003 1 [__C_RANK] O M 1 > 2 40003 1 [__C_RANK] O L 2 > 3 40003 1 [__C_RANK] O XL 3 > > Bert > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 John Butler

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:

CommandSecurity? (1997) search question (2001) Change Subtotal (2000) emailer (1997) Chat (2000) Email encryption (1998) Configuring E-mail (1997) [WebDNA] decrypt appears to be hosed (2008) No incentive ... (2000) WebCatalog for guestbook ? (1997) A little syntax help (1997) search function (2005) [WebDNA] WebDNA 8.6.4 (2020) protect (summer holidays with wcat???) (2000) WC Database Format (1997) webcat2b12 CGI -- Date comparisons (1997) Tuition - UK (2000) WebDNA Server Not Running (2005) World Address Info (2003) WebStar5 and realm authentication (2003)