small hairball -- stuck on [showif] for related db

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21139
interpreted = N
texte = OK, am feeling brain dead. Wonder if someone can offer some suggestions -- either what I'm missing or better yet, a simpler way -- on the following...I have certain SKUs that a customer may customize. For these SKUs, I want to send them to a separate page to provide the customization info (for now, simple text field in a form).The problem I'm having is in using a [showif] so that the FORM sends the customer to the customize page next instead of the shopping cart page.What makes this a small hairball (at least for me) is that the SKUs are in a related db, not the catalog.db that's been searched up to this point. So I want to do this...1) search the pricing.db to see if the SKU selected can be customized ([customized]=T)2) if the SKU can be customized, use [showif] so that the FORM action will send the shopper to the Customize.tmpl next I've tried surrounding the [showif] with a SEARCH context, but am missing something. Here's what I have so far:
Here's the surrounding snippet; you can see that trying this Search is inside of another Search.....[SEARCH db=pricing.db&eqItemdatarq=[Item]&SKUsort=1&SKUsortdir=as] [foundItems] [SKU] [showif [SkuName]>0][SkuName][/showif] [showif [ProdSizes]>0][ProdSizes][/showif] [showif [Colors]>0][Colors][/showif] $[Price] [showif [SRP]>0]$[SRP][/showif] [showif [SRP]>0][Format .1f][math](([SRP]-[price])/[SRP])*100[/math][/format]%[/showif]
[/FoundItems] [/SEARCH] Any thoughts on how to remove this hairball before the weekend greatly appreciated!Dale Stokdyk dstokdyk@dvs.mv.com Associated Messages, from the most recent to the oldest:

    
  1. Re: small hairball -- stuck on [showif] for related db (Dale Stokdyk 1998)
  2. Re: small hairball -- stuck on [showif] for related db (PCS Technical Support 1998)
  3. small hairball -- stuck on [showif] for related db (Dale Stokdyk 1998)
OK, am feeling brain dead. Wonder if someone can offer some suggestions -- either what I'm missing or better yet, a simpler way -- on the following...I have certain SKUs that a customer may customize. For these SKUs, I want to send them to a separate page to provide the customization info (for now, simple text field in a form).The problem I'm having is in using a [showif] so that the FORM sends the customer to the customize page next instead of the shopping cart page.What makes this a small hairball (at least for me) is that the SKUs are in a related db, not the catalog.db that's been searched up to this point. So I want to do this...1) search the pricing.db to see if the SKU selected can be customized ([customized]=T)2) if the SKU can be customized, use [showif] so that the FORM action will send the shopper to the Customize.tmpl next I've tried surrounding the [showif] with a SEARCH context, but am missing something. Here's what I have so far:
[founditems][showif [customize]=T]GiftCustomize.tmpl[/showif][/founditems][/search][hideif [customize]=T]GiftCart.tmpl$add[/hideif]>Here's the surrounding snippet; you can see that trying this Search is inside of another Search.....[SEARCH db=pricing.db&eqItemdatarq=[Item]&SKUsort=1&SKUsortdir=as] [founditems] [founditems][showif [customize]=T]GiftCustomize.tmpl[/showif][/founditems][/search][hideif [customize]=T]GiftCart.tmpl$add[/hideif]> [cart]> [SKU] [showif [SkuName]>0][SkuName][/showif] [showif [ProdSizes]>0][ProdSizes][/showif] [showif [Colors]>0][Colors][/showif] $[Price] [showif [SRP]>0]$[SRP][/showif] [showif [SRP]>0][Format .1f][math](([SRP]-[price])/[SRP])*100[/math][/format]%[/showif]
[/FoundItems] [/SEARCH] Any thoughts on how to remove this hairball before the weekend greatly appreciated!Dale Stokdyk dstokdyk@dvs.mv.com Dale Stokdyk

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:

Linux problems (2000) Kaaaaahhhhhhhnnnnnnn! (1997) WebDNA release (2005) Execute Applescript (1997) Multiple catalog databases and showcart (1997) Not really WebCat (1997) SSL/Document Contains NO Data (1998) free zip codes database (1999) Conveting Characters to Graphics (1997) SQL Connections (2004) WebDNA 5.0 Questions (2003) Anomaly ? causes NT application event log to overflow (1997) Web Catalog vs. ICAT (1997) Setting up WebCatalog with Retail Pro data (1996) Me know logical no need (2002) [WebDNA] PDF creation (2013) Emailer setup (1997) Limit on nested [ShowIf]'s? (1997) Bill To - Ship To Information display (1997) WebCat b13 CGI -shownext- (1997)