Re: Storebuilder Seems to have just died

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 46881
interpreted = N
texte = On 1/15/03 9:59 AM, Donovan wrote:> put a [cart] right before the [purchase] tag > to make sure the right cart is getting passed to it. > > Donovan > Donovan, I hate to do this do you but it seems the most prudent. Here is the thanks.inc file. Again since email receipts are definitely not being sent, nor orders being moved I think this is the culptrit file. Lets hope so. Here it is: [orderfile cart=[cart]][setheader cart=[cart]][formvariables name=__&exact=F][getchars start=3][name][/getchars]=[url][value][/url]&[/formvariables][/setheader] [setheader cart=[cart]]payMethod=AC[/setheader][!] check for required fields [/!] [showif [name]=]NAME:
[text]failed=T[/text][/showif] [showif [address1]=]ADDRESS:
[text]failed=T[/text][/showif] [showif [city]=]CITY:
[text]failed=T[/text][/showif] [showif [zip]=]ZIP:
[text]failed=T[/text][/showif] [showif [state]=NA][text]failed=T[/text]STATE:
[/showif][/orderfile][showif [failed]=T]

Please go back and fill in the required fields shown above.

[/showif][hideif [failed]=T][orderfile cart=[cart]] [math show=f]creditOK=1[/math][showif [validcard accountNum=[accountNum]&card=[listwords words=[lookup db=admin/prefs.db&lookinfield=pref&value=CREDIT_CARDS&returnfield=value]&del imiters=[url]+ [/url]][lookup db=admin/cards.db&lookinfield=CC_ID&value=[word]&returnfield=CC_ABRV]+[/list words]]=F] [math show=f]creditOK=0[/math] Please re-enter your credit card number. The number you entered may have a mistyped number or may be missing digits.

Credit Card
Card Number
Expiration
[/showif][/orderfile][showif [math]creditOK[/math]=1][orderfile cart=[cart]]Thanks For Purchasing

Your order will be shipped as soon as your credit card has been charged.You will be notified if there are any problems charging your card.

[Text]__EMailFrom=[lookup db=WebMerchant/WebMerchantPrefs.db&lookInField=preference&value=EMailFrom&re turnField=value¬Found=][/Text] This page is your final receipt.[hideif [email]=] A copy will be emailed to [email].[/hideif] Please note the order number on any correspondence. If you have any questions about your order contact [__EMailFrom].
[text]WebDelFol=[lookup db=webmerchant/webmerchantprefs.db&lookinfield=preference&value=WebDeliveryF older&returnfield=value¬found=webmerchant/webdelivery/][/text] Please click here to view authorization and download information.
[!]This writes out a temporary page that is replaced by the GoodPath/PendingPath/BadPath include files[/!] [WRITEFILE secure=F&file=[webdelfol][cart].tpl] Processing

Your order is being processed



This URL will automatically reload every 30 seconds. [/WRITEFILE][text]shopcart=[cart][/text] [lineitems] [search db=admin/carts.db&neCARTdatarq=find_all&rank=off][founditems] [hideif [interpret][text[CART]][/interpret]=] [search db=admin/related.db&eqR_IDdatarq=[interpret][text[CART]][/interpret]][foundi tems] [setlineitem db=admin/categories.db&index=[lineindex]&cart=[shopcart]]text[CART]=[url][R_ NAME][/url][/setlineitem] [/founditems][/search] [/hideif] [/founditems][/search] [/lineitems]
Order Number [cart]
Ship To
[shiptocompany]
[shiptoname]
[shiptoaddress1]
[showif [shiptoaddress]!][shiptoaddress2]
[/showif] [shiptoCity], [shiptostate] [shiptozip]
[showif [shiptoCountry]!][shiptoCountry]
[/showif] [showif [shiptoemail]!][shiptoemail][/showif]
Bill To
[company]
[name]
[address1]
[showif [address]!][address2]
[/showif] [City], [state] [zip]
[showif [Country]!][Country]
[/showif] [showif [email]!][email][/showif]
[lineItems] [/lineItems] $[subTotal][showif [lookup db=admin/prefs.db&lookinfield=pref&value=SHIP_TAX&returnfield=value¬found =F]=F] $[taxTotal] $[shippingTotal] [/showif][showif [lookup db=admin/prefs.db&lookinfield=pref&value=SHIP_TAX&returnfield=value¬found =F]=T] $[shippingTotal] $[taxTotal] [/showif]$[grandTotal]
SKUProductQtyPriceTotal
[SKU][lookup db=admin/products.db&lookinfield=SKU&value=[url][sku][/url]&returnfield=TITL E] [search db=admin/carts.db&neCARTdatarq=find_all&rank=off][founditems] [hideif [interpret][text[CART]][/interpret]=] [search db=admin/related.db&eqR_IDdatarq=[interpret][text[CART]][/interpret]][foundi tems] [lookup db=admin/categories.db&lookinfield=C_ID&value=[R_CATEGORY]&returnfield=C_NAM E]:[R_NAME] [/founditems][/search] [/hideif] [/founditems][/search] [quantity][lookup db=admin/prefs.db&lookinfield=pref&value=CURRENCY&returnfield=value][price]< /td> [lookup db=admin/prefs.db&lookinfield=pref&value=CURRENCY&returnfield=value][format .[lookup db=admin/prefs.db&lookinfield=pref&value=CURRENCY_ACCURACY&returnfield=value ]f][math][quantity]*[price][/math][/format]
Sub Total
Tax Rate:[taxRate]% Tax
Shipping & Handling
Shipping & Handling
Tax Rate:[taxRate]% Tax
Grand Total
[hideif [email]=][Include file=WebMerchant/EmailsTemplates/Thankyou.email&StoreID=[lookup db=admin/prefs.db&lookinfield=pref&value=MERCH_STOREID&returnfield=value]&fr omEmail=[url][__EMailFrom][/url]&toEmail=[url][email][/url]&cart=[cart]][/hideif][sendmail to=[url][lookup db=admin/prefs.db&lookinfield=pref&value=STORE_EMAIL&returnfield=value][/url ]&from=[url][lookup db=admin/prefs.db&lookinfield=pref&value=STORE_EMAIL&returnfield=value][/url ]&subject=Receipt for order [cart]] Order Number [cart] Ship To [shiptocompany] [shiptoname] [shiptoaddress1] [shiptoaddress2] [shiptoCity], [shiptostate] [shiptozip] [shiptoCountry]Bill To [company] [name] [address1] [address2] [City], [state] [zip] [Country]SKU Product Qty Price ($) Total ($) __________|________________________________________|______|__________|______ ____ [lineItems][format 10s][sku][/format] [format 20s][lookup db=admin/products.db&lookinfield=SKU&value=[url][sku][/url]&returnfield=TITL E][/format][format 20s][search db=admin/carts.db&neCARTdatarq=find_all&rank=off][founditems][hideif [interpret][text[CART]][/interpret]=][search db=admin/related.db&eqR_IDdatarq=[interpret][text[CART]][/interpret]][foundi tems][lookup db=admin/categories.db&lookinfield=C_ID&value=[R_CATEGORY]&returnfield=C_NAM E]:[R_NAME][/founditems][/search][/hideif][/founditems][/search][/format] [format 6.0f][quantity][/format] [format 10.2f][price][/format] [format 10.2f][math][quantity]*[price][/math][/format] [/lineitems]________________________________________________________________ ________________ Sub Total: [format 10.2f][subTotal][/format] [showif [taxableshipping]=F] Tax Rate:[taxRate]% Tax: [format 10.2f][taxTotal][/format] Shipping & Handling: [format 10.2f][shippingTotal][/format][/showif][showif [taxableshipping]=T] Shipping & Handling: [format 10.2f][shippingTotal][/format] Tax Rate: [format 6.2f][taxRate][/format]% Tax: [format 10.2f][taxTotal][/format][/showif] _______________________ Grand Total: [format 10.2f][grandTotal][/format] [/sendmail][/orderfile][purchase cart=[cart]][/showif][/hideif] Alex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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: Storebuilder Seems to have just died (Donovan 2003)
  2. Re: Storebuilder Seems to have just died (Alex McCombie 2003)
  3. Re: Storebuilder Seems to have just died (Alex McCombie 2003)
  4. Re: Storebuilder Seems to have just died (Alex McCombie 2003)
  5. Re: Storebuilder Seems to have just died (Daryl Mitchell 2003)
  6. Re: Storebuilder Seems to have just died (Donovan 2003)
  7. Re: Storebuilder Seems to have just died (John Hill 2003)
  8. Re: Storebuilder Seems to have just died (Alex McCombie 2003)
  9. Re: Storebuilder Seems to have just died (Donovan 2003)
  10. Re: Storebuilder Seems to have just died (Alex McCombie 2003)
  11. Re: Storebuilder Seems to have just died (Donovan 2003)
  12. Re: Storebuilder Seems to have just died (Alex McCombie 2003)
  13. Re: Storebuilder Seems to have just died (Donovan 2003)
  14. Re: Storebuilder Seems to have just died (Alex McCombie 2003)
  15. Storebuilder Seems to have just died (Alex McCombie 2003)
On 1/15/03 9:59 AM, Donovan wrote:> put a [cart] right before the [purchase] tag > to make sure the right cart is getting passed to it. > > Donovan > Donovan, I hate to do this do you but it seems the most prudent. Here is the thanks.inc file. Again since email receipts are definitely not being sent, nor orders being moved I think this is the culptrit file. Lets hope so. Here it is: [orderfile cart=[cart]][setheader cart=[cart]][formvariables name=__&exact=F][getchars start=3][name][/getchars]=[url][value][/url]&[/formvariables][/setheader] [setheader cart=[cart]]payMethod=AC[/setheader][!] check for required fields [/!] [showif [name]=]NAME:
[text]failed=T[/text][/showif] [showif [address1]=]ADDRESS:
[text]failed=T[/text][/showif] [showif [city]=]CITY:
[text]failed=T[/text][/showif] [showif [zip]=]ZIP:
[text]failed=T[/text][/showif] [showif [state]=NA][text]failed=T[/text]STATE:
[/showif][/orderfile][showif [failed]=T]

Please go back and fill in the required fields shown above.

[/showif][hideif [failed]=T][orderfile cart=[cart]] [math show=f]creditOK=1[/math][showif [validcard accountNum=[accountNum]&card=[listwords words=[lookup db=admin/prefs.db&lookinfield=pref&value=CREDIT_CARDS&returnfield=value]&del imiters=[url]+ [/url]][lookup db=admin/cards.db&lookinfield=CC_ID&value=[word]&returnfield=CC_ABRV]+[/list words]]=F] [math show=f]creditOK=0[/math] Please re-enter your credit card number. The number you entered may have a mistyped number or may be missing digits.

[cart]>
Credit Card
Card Number
Expiration
[/showif][/orderfile][showif [math]creditOK[/math]=1][orderfile cart=[cart]]Thanks For Purchasing

Your order will be shipped as soon as your credit card has been charged.You will be notified if there are any problems charging your card.

[text]__EMailFrom=[lookup db=WebMerchant/WebMerchantPrefs.db&lookInField=preference&value=EMailFrom&re turnField=value¬Found=][/Text] This page is your final receipt.[hideif [email]=] A copy will be emailed to [email].[/hideif] Please note the order number on any correspondence. If you have any questions about your order contact [__EMailFrom].
[text]WebDelFol=[lookup db=webmerchant/webmerchantprefs.db&lookinfield=preference&value=WebDeliveryF older&returnfield=value¬found=webmerchant/webdelivery/][/text] Please click [cart].tpl>here to view authorization and download information.
[!]This writes out a temporary page that is replaced by the GoodPath/PendingPath/BadPath include files[/!] [WRITEFILE secure=F&file=[webdelfol][cart].tpl] [cart].tpl> Processing

Your order is being processed



This URL will automatically reload every 30 seconds. [/WRITEFILE][text]shopcart=[cart][/text] [lineitems] [search db=admin/carts.db&neCARTdatarq=find_all&rank=off][founditems] [hideif [interpret][text[cart]][/interpret]=] [search db=admin/related.db&eqR_IDdatarq=[interpret][text[cart]][/interpret]][foundi tems] [setlineitem db=admin/categories.db&index=[lineindex]&cart=[shopcart]]text[cart]=[url][R_ NAME][/url][/setlineitem] [/founditems][/search] [/hideif] [/founditems][/search] [/lineitems]
Order Number [cart]
Ship To
[shiptocompany]
[shiptoname]
[shiptoaddress1]
[showif [shiptoaddress]!][shiptoaddress2]
[/showif] [shiptoCity], [shiptostate] [shiptozip]
[showif [shiptoCountry]!][shiptoCountry]
[/showif] [showif [shiptoemail]!][shiptoemail][/showif]
Bill To
[company]
[name]
[address1]
[showif [address]!][address2]
[/showif] [City], [state] [zip]
[showif [Country]!][Country]
[/showif] [showif [email]!][email][/showif]
[lineitems] [/lineItems] $[subTotal][showif [lookup db=admin/prefs.db&lookinfield=pref&value=SHIP_TAX&returnfield=value¬found =F]=F] $[taxTotal] $[shippingTotal] [/showif][showif [lookup db=admin/prefs.db&lookinfield=pref&value=SHIP_TAX&returnfield=value¬found =F]=T] $[shippingTotal] $[taxTotal] [/showif]$[grandTotal]
SKUProductQtyPriceTotal
[SKU][lookup db=admin/products.db&lookinfield=SKU&value=[url][sku][/url]&returnfield=TITL E] [search db=admin/carts.db&neCARTdatarq=find_all&rank=off][founditems] [hideif [interpret][text[cart]][/interpret]=] [search db=admin/related.db&eqR_IDdatarq=[interpret][text[cart]][/interpret]][foundi tems] [lookup db=admin/categories.db&lookinfield=C_ID&value=[R_CATEGORY]&returnfield=C_NAM E]:[R_NAME] [/founditems][/search] [/hideif] [/founditems][/search] [quantity][lookup db=admin/prefs.db&lookinfield=pref&value=CURRENCY&returnfield=value][price]< /td> [lookup db=admin/prefs.db&lookinfield=pref&value=CURRENCY&returnfield=value][format .[lookup db=admin/prefs.db&lookinfield=pref&value=CURRENCY_ACCURACY&returnfield=value ]f][math][quantity]*[price][/math][/format]
Sub Total
Tax Rate:[taxRate]% Tax
Shipping & Handling
Shipping & Handling
Tax Rate:[taxRate]% Tax
Grand Total
[hideif [email]=][Include file=WebMerchant/EmailsTemplates/Thankyou.email&StoreID=[lookup db=admin/prefs.db&lookinfield=pref&value=MERCH_STOREID&returnfield=value]&fr omEmail=[url][__EMailFrom][/url]&toEmail=[url][email][/url]&cart=[cart]][/hideif][sendmail to=[url][lookup db=admin/prefs.db&lookinfield=pref&value=STORE_EMAIL&returnfield=value][/url ]&from=[url][lookup db=admin/prefs.db&lookinfield=pref&value=STORE_EMAIL&returnfield=value][/url ]&subject=Receipt for order [cart]] Order Number [cart] Ship To [shiptocompany] [shiptoname] [shiptoaddress1] [shiptoaddress2] [shiptoCity], [shiptostate] [shiptozip] [shiptoCountry]Bill To [company] [name] [address1] [address2] [City], [state] [zip] [Country]SKU Product Qty Price ($) Total ($) __________|________________________________________|______|__________|______ ____ [lineitems][format 10s][sku][/format] [format 20s][lookup db=admin/products.db&lookinfield=SKU&value=[url][sku][/url]&returnfield=TITL E][/format][format 20s][search db=admin/carts.db&neCARTdatarq=find_all&rank=off][founditems][hideif [interpret][text[cart]][/interpret]=][search db=admin/related.db&eqR_IDdatarq=[interpret][text[cart]][/interpret]][foundi tems][lookup db=admin/categories.db&lookinfield=C_ID&value=[R_CATEGORY]&returnfield=C_NAM E]:[R_NAME][/founditems][/search][/hideif][/founditems][/search][/format] [format 6.0f][quantity][/format] [format 10.2f][price][/format] [format 10.2f][math][quantity]*[price][/math][/format] [/lineitems]________________________________________________________________ ________________ Sub Total: [format 10.2f][subTotal][/format] [showif [taxableshipping]=F] Tax Rate:[taxRate]% Tax: [format 10.2f][taxTotal][/format] Shipping & Handling: [format 10.2f][shippingTotal][/format][/showif][showif [taxableshipping]=T] Shipping & Handling: [format 10.2f][shippingTotal][/format] Tax Rate: [format 6.2f][taxRate][/format]% Tax: [format 10.2f][taxTotal][/format][/showif] _______________________ Grand Total: [format 10.2f][grandTotal][/format] [/sendmail][/orderfile][purchase cart=[cart]][/showif][/hideif] Alex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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/ Alex McCombie

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:

Version f1 status (1997) Virtual hosting and webcatNT (1997) change the number format (1997) RE: is sku a REQUIRED field on NT (1997) Emailer (WebCat2) (1997) Quiestion (1997) Merging databases (1997) Multiple catalog databases and showcart (1997) Mozilla Firefox problem (2004) pc (1997) Comments in db? (1997) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) emailer and other smtp (1998) WebCat2 Append problem (B14Macacgi) (1997) WebCat2b15MacPlugin - [protect] (1997) ' add to cart ' or ' sku ' problem (1998) UPDATE PROBLEM (1997) [WebDNA] directory protection questions (2008) Using copyfolder (2001) products db philosophy (2001)