delete record

Results 1 to 2 of 2

Thread: delete record

  1. #1
    Join Date
    Dec 1969

    Default delete record

    simple stuff here i hope for you guys. I hve a record, simply enough i want to delete it out of a database based on whether or not the checkbox is checked on the asp page. <BR><BR>who can help here??<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: delete record

    You need to call the information from the previous page (the page with a check box):<BR><BR>myVar=request.form("check_box_Name")< BR><BR>Then Delete the file if the check box was checked with creating a connection first then running a delete SQL statement.<BR><BR>if myVar="passedvaluefrompreviouspage" then<BR>set rs=Server.CreateObject("adodb.Recordset")<BR>conne ctme="DSNname"<BR><BR>strSQLdelete= "Delete from per_Team_Membership where mp_ID=&#039"&Emp_ID&"&#039<BR><BR> strSQLdelete, connectme<BR><BR>end if<BR><BR><BR>Good Luck<BR>Brandon Monahan<BR><BR><BR><BR>

Posting Permissions

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