Re: Storebuilder Seems to have just died

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 46882
interpreted = N
texte = Did you change any folder names in the store hierarchy?>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 href=mailto:[__EMailFrom]>[__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] >align=right>$[subTotal] > >[showif [lookup >db=admin/prefs.db&lookinfield=pref&value=SHIP_TAX&returnfield=value¬found >=F]=F] >align=right>$[taxTotal] >align=right>$[shippingTotal] >[/showif] > >[showif [lookup >db=admin/prefs.db&lookinfield=pref&value=SHIP_TAX&returnfield=value¬found >=F]=T] >align=right>$[shippingTotal] >align=right>$[taxTotal] >[/showif] > >align=right>$[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.com > >Interface 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/-- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com------------------------------------------------------------- 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)
Did you change any folder names in the store hierarchy?>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 href=mailto:[__EMailFrom]>[__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] >align=right>$[subTotal] > >[showif [lookup >db=admin/prefs.db&lookinfield=pref&value=SHIP_TAX&returnfield=value¬found >=F]=F] >align=right>$[taxTotal] >align=right>$[shippingTotal] >[/showif] > >[showif [lookup >db=admin/prefs.db&lookinfield=pref&value=SHIP_TAX&returnfield=value¬found >=F]=T] >align=right>$[shippingTotal] >align=right>$[taxTotal] >[/showif] > >align=right>$[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.com > >Interface 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/-- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com------------------------------------------------------------- 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/ John Hill

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:

SQLResult chokes on null values? (2006) [WebDNA] Dead line Time Math (2017) Week # problem (1998) shortening the cart (1998) & Problem in Textarea (1999) question: webmerchant connection (1997) Any Newsletters out there (1998) Search with Special Chars (1997) Search/sort in URL Was: GuestBook example (1997) [getchars] questions (1997) WCf2 and nested tags (1997) Date in IF ELSE Comparison (2004) Enhanced Master Counter? (1997) No Line Breaks from OSX server (2002) WebCat2b12 forgets serial # (1997) shell problems again... (2003) Mozilla/4. and Browser Info.txt (1997) [WebDNA] API Integration (2010) Searching Relational Databases (2004) Emailer (1997)