www.webdeveloper.com
Results 1 to 2 of 2

Thread: onclick or onchange to sql record

  1. #1
    Join Date
    Nov 2005
    Posts
    6

    onclick or onchange to sql record

    Hi

    Have an asp page that user selects a week from date picker and it returns data from sql table in a series of checkboxes for overtime availability.

    ie for the week of 10/10/2011 the checkboxes are Monday through Sunday, the user clicks the checkboxes they want to work overtime and hits a submit button. Let's assume they chose Monday and Wednesday. If they go back to this page later and pick the week of 10/10/2011 the sql table shows checked in the Monday and Wednesday checkboxes. They can then make any changes they want, hit the submit button, and that sql record is updated with the new data.

    So on to the issue........For audit purposes, there is another sql table called ot_audit. What I want to do is every time one of the checkboxes is changed (pre hitting the submit button), I need a new record added to the ot_audit table. It will show a datetime stamp, who made the change, what was clicked, and if it was checked or unchecked.

    Question is....how in the heck do I do this? I'm new here and all I know is there are onChange and onClick events. Lost after that. Please help me.

  2. #2
    Join Date
    Nov 2005
    Posts
    6
    Anyone have any ideas?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles