Re: ' add to cart ' or ' sku ' problem

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 20095
interpreted = N
texte = Thanks for responding!Unfortunately, I believe that I've checked each of your recommendations and foundthat I am already complying. I put the Add to cart link in the same FOUNDITEMSlink that I use to display the the items; the [sku] successfully fills the tablewith the correct values from the SKU field in my database. Very perplexing! I'vecopied the offending page (and the small database) if you have a moment to see whatI'm talking about.[searchdb=msports.db&eqNAMEdata=[key_words]&SKUsort=1&SKUsdir=de&cart=[cart]&max=1&startat=[startat]]FOUND [numfound] ITEMS
 [founditems] [/founditems]

Cat ID	ProdName	Description	Price	Photo	A ction
[SKU]	[name]	[desc]	$[format .2f][Price][/format]		Addto cart

[shownext startat=[startat]] Show Items[start]-[end]
[/shownext][/search]Show ShoppingCart
Back to search[formvariables][name],[value]
[/formvariables]SKU NAME DESC PRICE PICT2222 item6 thisisitemtwo 2.22 pict23333 item2 thisisitemthree 3.33 pict34444 item2 thisisitemfour 4.44 pict35555 item2 thisisitemfive 5.55 pict26666 item2 thisisitemsix 6.66 pict37777 item2 thisisitemseven 7.77 pict38888 item2 thisisitemeight 8.88 pict3PCS Technical Support wrote:> >I get the message Error: couldn't find SKU '[SKU]' in product> >database. when I click on the Add to Cart link.> >> >The link's url is:> >WebCatalog/92498/shoppingcart.tpl?command=add&db=msports.db&SKU=[SKU]&cart=2989> >515176129>> If the link has literally [sku] in it (rather than your actual product sku> text), then either the WebDNA is not getting interpreted on that page, or> there's no [sku] field in your database, or you're outside of a> [FoundItems] loop which would provide the context for knowing what [sku]> means.>> You might have used one of those poorly-written graphical HTML editors that> decides to change '[' to '%5B', so make sure you are really looking at the> HTML source of your template useing a real text editor instead of PageMill> or whatever.>> Technical Support | ==== eCommerce and Beyond ====> Pacific Coast Software | WebCatalog, WebMerchant,> 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,> San Diego, CA 92128 | Typhoon> 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Solution:' add to cart ' or ' sku ' problem (John Bennett 1998) Re: ' add to cart ' or ' sku ' problem (John Bennett 1998) Re: ' add to cart ' or ' sku ' problem (PCS Technical Support 1998) ' add to cart ' or ' sku ' problem (John Bennett 1998) Re: ' add to cart ' or ' sku ' problem (PCS Technical Support 1998)

Thanks for responding!Unfortunately, I believe that I've checked each of your recommendations and foundthat I am already complying. I put the Add to cart link in the same FOUNDITEMSlink that I use to display the the items; the [sku] successfully fills the tablewith the correct values from the SKU field in my database. Very perplexing! I'vecopied the offending page (and the small database) if you have a moment to see whatI'm talking about.[searchdb=msports.db&eqNAMEdata=[key_words]&SKUsort=1&SKUsdir=de&cart=[cart]&max=1&startat=[startat]]FOUND [numfound] ITEMS
 [founditems] [/founditems]

Cat ID	ProdName	Description	Price	Photo	A ction
[SKU]	[name]	[desc]	$[format .2f][Price][/format]		[cart]>Addto cart

[shownext startat=[startat]] Show Items[start]-[end]
[/shownext][/search][cart]>Show ShoppingCart
Back to search[formvariables][name],[value]
[/formvariables]SKU NAME DESC PRICE PICT2222 item6 thisisitemtwo 2.22 pict23333 item2 thisisitemthree 3.33 pict34444 item2 thisisitemfour 4.44 pict35555 item2 thisisitemfive 5.55 pict26666 item2 thisisitemsix 6.66 pict37777 item2 thisisitemseven 7.77 pict38888 item2 thisisitemeight 8.88 pict3PCS Technical Support wrote:> >I get the message Error: couldn't find SKU '[SKU]' in product> >database. when I click on the Add to Cart link.> >> >The link's url is:> >WebCatalog/92498/shoppingcart.tpl?command=add&db=msports.db&SKU=[SKU]&cart=2989> >515176129>> If the link has literally [sku] in it (rather than your actual product sku> text), then either the WebDNA is not getting interpreted on that page, or> there's no [sku] field in your database, or you're outside of a> [founditems] loop which would provide the context for knowing what [sku]> means.>> You might have used one of those poorly-written graphical HTML editors that> decides to change '[' to '%5B', so make sure you are really looking at the> HTML source of your template useing a real text editor instead of PageMill> or whatever.>> Technical Support | ==== eCommerce and Beyond ====> Pacific Coast Software | WebCatalog, WebMerchant,> 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,> San Diego, CA 92128 | Typhoon> 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ John Bennett

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:

Is there a max number of fields? (1998) Comments in db? (1997) Date comparison (I think) has bugs ... (1998) DRC content management site (2003) $Quit, $CloseDatabase corrections (1997) [WebDNA] A universal version of WebDNA ... (2008) form data submission gets truncated (1997) page chokes on hideif when false and ignored (1998) question: Eudora 3.1.1 (1997) Possible Bug in 2.0b15.acgi (1997) OT: RAID Options (2004) Shipping costs question (2002) Best way to upload file.... (2000) contextual shownext (1998) Single Link browsing (1997) Not really WebCat (1997) Text data with spaces in them... (1997) IIS4/WebCat3.0 Authentication (1999) [OT] Bad Cookie / Internet Option / Internet Explorer (2004) WCS Newbie question (1997)