Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › order management

order management

Thread began 7/16/2010 5:41 am by tim.wolak331163 | Last modified 8/05/2010 10:24 am by tim.wolak331163 | 1816 views | 7 replies

7/16/2010 5:41 amtim.wolak331163

order management

I have gone through the wizard to create my detail pages but have a few issues. How can I get my order management pages to display one line for an order. For example if order 111 ordered four items there are four lines for order 111. Also I would like to have the detail combine the orders and orderdetails table which I have my sql statement saying select * from orders, orderdetails where orders.detailID = orderdetails.orderDetailID. This gets me that data I want I just need to know how to sort it like the question above.

Thanks,
Tim

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.