Inventory Debit Procedure

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 20854
interpreted = N
texte = I want to set the Qty_OH (quantity on hand) amount in the database of products to 0 when a purchase is completed. There is only 1 item of each, and I want to set Qty=0, order_date = the date, and order_num= the cart.I set replace functions in the line items conxt on the Thankyou Template to do a replace on each of the values:[replace db=laserdisc.db&eqskudata=[sku]]qty_oh=0[/replace] [replace db=laserdisc.db&eqskudata=[sku]]date_sold=[date format %x][/replace] [replace db=laserdisc.db&eqskudata=[sku]]order_no=[cart][/replace]Problem is it kills the server. When I remove these, the system works fine.Any help would be appreciated. Alternative methods included.Mac G3, 8.1, Webstar SSL 2.1, WebCatalog 2.0 plugin -- haven't upgraded to v3 Webstar because of memory error plugin problems with WebCat and v3 SSL; cannot reprogram for acgi because of other production stuff on same server.Thanks in advanceLarry======================================================================== Hewitt Consulting... Business Internet Solutions ======================================================================== www.hewittco.com Larry Hewitt larryh@hewittco.com Hewitt Consulting voice: 360/740-1090 Managing Partner cell: 360/508-6014 fax: 360/740-0998 Associated Messages, from the most recent to the oldest:

    
  1. Re: Inventory Debit Procedure (PCS Technical Support 1998)
  2. Re: Inventory Debit Procedure (Rob Marquardt 1998)
  3. Inventory Debit Procedure (Larry Hewitt 1998)
I want to set the Qty_OH (quantity on hand) amount in the database of products to 0 when a purchase is completed. There is only 1 item of each, and I want to set Qty=0, order_date = the date, and order_num= the cart.I set replace functions in the line items conxt on the Thankyou Template to do a replace on each of the values:[replace db=laserdisc.db&eqskudata=[sku]]qty_oh=0[/replace] [replace db=laserdisc.db&eqskudata=[sku]]date_sold=[date format %x][/replace] [replace db=laserdisc.db&eqskudata=[sku]]order_no=[cart][/replace]Problem is it kills the server. When I remove these, the system works fine.Any help would be appreciated. Alternative methods included.Mac G3, 8.1, Webstar SSL 2.1, WebCatalog 2.0 plugin -- haven't upgraded to v3 Webstar because of memory error plugin problems with WebCat and v3 SSL; cannot reprogram for acgi because of other production stuff on same server.Thanks in advanceLarry======================================================================== Hewitt Consulting... Business Internet Solutions ======================================================================== www.hewittco.com Larry Hewitt larryh@hewittco.com Hewitt Consulting voice: 360/740-1090 Managing Partner cell: 360/508-6014 fax: 360/740-0998 Larry Hewitt

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:

WebCat2: Items xx to xx shown, etc. (1997) StoreBuilder/SiteBuilder (2005) New public beta available (1997) accessing Webcat from another server (2000) Emailer setup (1997) God's Truth (1998) OT: need perl help, and question about switches (2007) Delete context run amok (2005) [WebDNA] Protect TextArea and other Input-Fields with WebDNA - (2009) 2.0 Info (1997) Security Issues and WebCommerce Solution (1997) [Price] (1997) authenticating a second user (1997) RE: Still Learning (1997) WebSTAR 2.1 freezes my Mac (1997) WC Database Format (1997) Follow-up to listfiles bug report ... (2003) Re[2]: Shopping Cart Directory (2000) 2.0 Info (1997) Add all products to cart at once? (1997)