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:

WebCatalog Upgrade Pricing? (1997) Webstar 1.3.1 PPC (1997) How true is this? (1999) WC Database Format (1997) Assign Variable Value (1998) WebCatalog for guestbook ? (1997) WC1.6 to WC2 date formatting (1997) Question (1997) searchable list archive (1997) [CART] inside a [LOOP] (1997) Sendmail & Time Issue (2001) webcat- multiple selection in input field (1997) SSL PROBLEM (1999) [append] vs. [appendfile] delta + question? (1997) Multiple Newcarts (1996) [sendmail] sending twice... (2003) Newbie needs advice to learn to use WebDNA (2003) To Use Cookies or Not To Use Cookies (2003) New syntax feedback for 4.0 (2000) No luck with taxes (1997)