check box to mark yes/no data type field

[drewangell]

I've created a form where people can request samples of our product to be sent
to them. I've created a list page where it lists out all of the current
requests that still need shipped. In my database I have a field called shipped
with data type yes/no.

I made another page which lists all requests that need shipped based off that
shipped field (yes/no.) From this list there's a link to view the details of
each record.

On that details page I'd like to include a check box that we can simply click
to mark the shipped field to yes so that it won't show up on the list of stuff
that needs shipped anymore.

Seems like this should be easy...but I'm an idiot. Please help.

Thanks!

[drewangell]

I've actually switched from the checkbox idea to a simple form button that says
Shipped.

I've created a hidden field called Shipped and given it the value of 1. Then I
use an update record behavior in dreamweaver to update the Shipped field with a
1 when it's clicked from its default value of 0.

It then sends me back to the list of the others that need shipped, and it does
indeed remove the one I just marked shipped.

However, my problem now is that when it returns me to the list it's leaving
the paramater on the end of the URL which breaks the page. It displays fine,
but when I try and click into the details of another record I get an error.

For instance, I open up sampleRequestList.asp and it shows me my list of all
requests where Shipped = 0. I've made the person's name a link using the
requestID field as the paramater to look it up so the next page is something
like sampleRequestDetails.asp?requestID=10. Then I click that shipped button
and it sends me back to the sampleRequestList.asp page and the record I just
marked shipped is now gone...but the URL for my list page is now
sampleRequestList.asp?requestID=10.

Again, the page displays fine but when I click on any more of the detail page
I get a syntax error because it ends up being something like
sampleRequestDetails?requestID=10&requestID=17

[drewangell]

Ok I got it fixed. the update behavior creates a variable called MM_editAction
like so:

MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If

I just had to comment out the &"?" & Server..... part.