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:

pull downs (1997) WebCatalog/Mac 2.1b2 - PIXO (1997) creating an index based on first letter of word inspecific field in database (2002) Price Not Appearing (2000) Sort Order on a page search (1997) OT: CT Scan might have saved my life!! (2006) [isfolder] and [filename] (1997) Using [Include] Context (1999) cybercash on OSX - was Executing remote AppleScript (2000) Re:2nd WebCatalog2 Feature Request (1996) RE: Can't get appendfile to work (1997) Updating Prices in Online Database (1999) Navigator Parsing (1997) Webcatalog quitting (1997) Simple way to create unique SKU (1997) TCPConnect & Post (2002) Nested tags count question (1997) creating a ShipCosts database (1997) how to determine the actual file format of an image file? (2002) unsubscribe (1999)