Skip to main content
Participating Frequently
August 26, 2009
Question

Honeymoon Registry using ASP

  • August 26, 2009
  • 1 reply
  • 1365 views

I'm trying to create a honeymoon registry for a travel client of mine and I'm confused on how to do it.

Here's how I would like it to work:

I would have the list of items on the page with a checkbox next to each one for purchase. When that box is checked it would update the "purchased" field in the database and also be submitted in the form. When one of the items is purchased I want it to say "Purchased" so the next person knows it's not available.

The item would be submitted to the travel company with Credit card information, it would not be processed on the site.

Now, here's what I have thought out:

I had thought about just setting up a shopping cart but since they don't want the usual "checkout" I figured I would scrap that idea.

Instead, I would have to do it from scratch. I would create a database with three fields: item, price and purchased (yes or no)

I define my database and create a recordset. I insert the fields from the bindings tab. I create a checkbox for the purchased item.

I installed the Advanced Conditional Region extension to get the items to show as "purchased".

Now, I'm not sure if I'm doing this correctly. Do I need to do the recordset and bindings? If I repeated the region and had all of the items listed, how would the checkbox work for each item?

It seems like it would be so simple but I can't seem to wrap my brain around it!

TIA!

Dawn

This topic has been closed for replies.

1 reply

Lon_Winters
Inspiring
August 26, 2009

So taking this one step at a time, how much of it have you got it to work so far?  Are you able to update the database with the purchased indicator?

Participating Frequently
August 26, 2009

Not working yet. The update record isn't working.

I'm still trying to figure out how to set up the database.

I have two. One with item, price and purchased. The other I have a column for each item purchased -- yes/no selection.

Lon_Winters
Inspiring
August 26, 2009

Are you using MSSQL or Access?  Have you established a connection to the database via dreamweaver?  Please provide all this background info on what you did and whether it works to help solve your issue.