Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › Urgent: Site not returning from Paypal

Urgent: Site not returning from Paypal

Thread began 1/24/2012 4:13 am by laura_ellis427550 | Last modified 1/24/2012 11:41 am by laura_ellis427550 | 1358 views | 6 replies

1/24/2012 11:27 amlaura_ellis427550

I sent that last reply too early. Code on line 24 is

$query_rsDetail = sprintf("SELECT stock - (SELECT coalesce(sum(DetailQuantity),0) as soldStock from orders INNER JOIN orderdetails ON OrderID = DetailOrderID WHERE DetailProductID = ProductID AND OrderDate > stock_update) as newStock FROM products WHERE productID = %s", GetSQLValueString($colname_rsDetail, "int"));

This was added when I was entering an inventory control section to the site and was done in conjunction with one of the Webassist tech guys. As I needed help to implement it, I don't know how to work out what's going wrong.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.