Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Creating Order History

Creating Order History

Thread began 8/05/2009 5:24 pm by 4egidio363291 | Last modified 5/27/2010 10:53 am by 4egidio363291 | 3407 views | 10 replies

8/12/2009 11:44 amJason ByrnesWebAssist

Looking at the code on the page, i found that the recordsets where not created properly:

On the Order History page, the problem is the WADAOrders recordset.

the select statement was limiting the columns returned:
SELECT OrderUserID FROM Orders

It should be:
SELECT * FROM Orders

On the order details, User ID Session Variable was being compared to the Order ID column in the Where statement:
AND Orders.OrderID = paramUID

it should be the OrderUserID column
AND Orders.OrderUserID = paramUID

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.