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:
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)