VB/ASP question, probably easy for a geek

[bigmaddaz]

Basically I got a page which lists all the records in a database:

When the user clicks the button on left under staff ID they are then shown the following:

The above was coded using ASP and SQL, the above shows the update one and when clicked any changes are saved, I have exactly the same code for the delete, its brought up in similar window but there is a "delete record" button at bottom instead, basically I want delete record and update record both on same page, I have the code for both how do I put them together on one page?

Think its to do with VB or ASP, where u have "if" or "else" statements!

Code for update is:

<form method="post" action="demo_update.asp">
<table>
<%for each x in rs.Fields%>
<tr>
<td><%=x.name%></td>
<td><input name="<%=x.name%>" value="<%=x.value%>"></td>
<%next%>
</tr>
</table>
<br /><br />
<input type="submit" value="Update record">
</form>
<%
else
sql="UPDATE staff SET "
sql=sql & "sname='" & Request.Form("sname") & "',"
sql=sql & "fname='" & Request.Form("fname") & "',"
sql=sql & "dob='" & Request.Form("dob") & "',"
sql=sql & "dept='" & Request.Form("dept") & "'"
sql=sql & " WHERE staffid=" & cid & ""
on error resume next
conn.Execute sql
if err<>0 then
response.write("No update permissions!")
else
response.write("Record " & cid & " was updated!")
end if
end if
conn.close
%>


Code for delete is :

<form method="post" action="demo_delete.asp">
<table>
<%for each x in rs.Fields%>
<tr>
<td><%=x.name%></td>
<td><input name="<%=x.name%>" value="<%=x.value%>"></td>
<%next%>
</tr>
</table>
<br /><br />
<input type="submit" value="Delete record">
</form>
<%
else
sql="DELETE FROM staff"
sql=sql & " WHERE staffid=" & cid & ""
'on error resume next
conn.Execute sql
'if err<>0 then
'response.write("No update permissions!")
response.write("Record " & cid & " was deleted!")
end if
conn.close
%>

Basically how do I merge them together so they are both on same page?

Cheers!!!!

 

[cava83]

Write a function and call it..........

 

[bigmaddaz]

Yea, I was going to have the delete part as a funtion, and update part as a function, but how do I call a function on the click of a submit button?

 

[bigmaddaz]

This is working demo:

http://www.w3schools.com/ado/demo_db_list.asp

But I dont know how to merge my code together, its all done, but dont know how to make it on one page

 

[cava83]

call the function when you submit the form ? that's one way of doing it

 

[bigmaddaz]

Yea, but im a little confused about exactly where this call goes, how do I link the submit button to the call?

 

[cava83]

http://www.w3schools.com/ado/showcode.asp?source=demo_db_edit.asp

Maybe that

Soz, have a think, I am sure it will come to you shortly

Post the answer for others though, comes in handy for when people do searches on here for answers

 

[KDF]

Just use a different name/value on the submit button, do an if/switch to find out if the value is delete or update and call the appropriate function based on that.