close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

How to modify an existing order using a cart page

Thread began 6/18/2009 4:30 pm by neileisen207079 | Last modified 6/20/2009 11:05 am by neileisen207079 | 1747 views | 5 replies |

neileisen207079

How to modify an existing order using a cart page

The client wants to be able to go to an existing order, and change a quantity or price or something, and then save it that way.

I have it working so that they can look at all the orders for a given customer, and go in to a specific order and look at it in a cart page, and then reorder it if they want to with changes.... but the client wants to be able to change that order without re-ordering it....just saving it with the changes.

Since that cart page is showing info from both the orders table and the orderdetails table... I assumed you could add a dataassist behavior to store cart details in database, and store cart summary in database when they clicked on a new button... but then I realized that it would make a new record, instead of updating the existing one...right?

Then I thought of using the multiple records update...but when I tried it came up with an error saying I had to have a repeating form area on my page...which I do --- its the cart page... but it thinks I dont.

Anyway... am I on the right track? Originally I told them that they probably would have to delete the order and redo it, but of course they dont want to do that. I also figured I could make a form that edits the record, but I would have to edit the order and the details, and then do the math, etc....

Aghhh. I am confused....so maybe someone can help. thanks.

Sign in to reply to this post

neileisen207079

So I guess no one can help me with this. I am gone for the day but I'll keep checking the forum. I also had a problem the other day and submitted a ticket, as I was told to do by the WA person in the forum. Then I was asked for additional info, which I supplied. Now I havent heard anything in 2 days, including from this.

I am deep into a project that I wish I never started, but now I HAVE to finish it. I have tried hiring help and no one can do what I need done. I am making progress, but I really need help. Thank you so much for all your help so far. I need to figure the rest out... hopefully you are all just busy. I am SOOOOOO frustrated. Thanks.

Sign in to reply to this post

Ray BorduinWebAssist

You need to use the "Repeat Selection" server behavior that comes with DataAssist and not the "Repeat Region" other than that it sounds like you are on the right track.

Just remove the repeat region and add the repeat selection, then try applying the mulitple update.

Sign in to reply to this post

neileisen207079

I think I can do that... but the repeat selection requires a recordset, and the data is in the ecart - which isnt available as an option in the repeat selection dialog.

I can use the orderdetails table, but it doesnt have all the fields...like total for each item, etc. Is there a way to use the ecart data with a Repeat Selection behavior?

Sign in to reply to this post

Ray BorduinWebAssist

No you would have to use a recordset and the order details.

To get something like the total you can use math in your SQL:

SELECT *, DetailQuantity * DetailPrice AS DetailRowTotal FROM table

Sign in to reply to this post

neileisen207079

OK, I see its a lot harder than I thought. Too bad it doesn't work with the Repeat Region - or either that or if I could have used the cart data as a recordset.....either way would have made my life a lot easier.... but alas... my life isnt gonna be any easier until I get this job out of my shop. Sigh.
Thank you SO much Ray. Again... I appreciate your talents.

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...