close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Name/Desc is sent to oderdetails table but what if you need more data to be sent

Thread began 2/16/2010 8:12 am by ant.knott394719 | Last modified 2/16/2010 5:07 pm by Dani Chankhour | 611 views | 1 replies |

ant.knott394719

Name/Desc is sent to oderdetails table but what if you need more data to be sent

Can someone tell me if it is possible to use the store summary and details behaviour to add data from column/s in your items table. I have a spare column in the orderdetails table i can use to test this. I had a go last night. I did an items recordset on the confirm.php page, clicked on the store order details behaviour then selected my item. There's obviously a bit more to it than this as when i tested it by doing an order it just shows the very first item from the items table irrespective of what has been ordered. As a test i selected the thumb1 column from the items recordset i created, i did a number of different orders but the order history details page had the same image reference on every row C001.jpg. They should have all been different, they need to match what has actually been ordered.

I was advised that instead of the above, i could do a join statement on the history details page, if this is an easier way to do it, great, but when i tried this i had the same problem as above. The order history details page shows the same image ref (C001.jpg) on every row regardless as to what has actually been ordered. pls help me to accomplish one of the above solutions.

My goal is to have all the details stored in the items table accessible to the customer in the order history pages but to also have a page containing all the item details for there order so i can send it to the customer using universal email. Ideally, a search on orderID would bring up a product catalogue style page with an image and a list of 7 characteristics from the items table below it. I would then send this after payment. It is important these details are not seen in the cart. (only 'name and description' from the items table should be seen in the cart)

Any help with this would as usual be v.appreciated.

Sign in to reply to this post

Dani Chankhour

Instead of updating your Orders Table, you need to be updating your Order Details table.

So instead of reentering the store summary in database, you need to reenter the store details in database server behavior. And you should add your column to the order details table instead of the order table because the column you are adding is per product and not for the entire order.

Sign in to reply to this post

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...