home *** CD-ROM | disk | FTP | other *** search
/ Dynamic HTML Construction Kit / Dynamic HTML Construction Kit.iso / source_code / dhtmlunl / dhtml.exe / CD Content / Chap20 / dun20_2.txt < prev    next >
Encoding:
Text File  |  1997-12-18  |  800 b   |  27 lines
  1. <html><head><title>Submit Changes</title></head>
  2. <body>
  3. <%set conn = server.createobject("ADODB.connection")
  4. conn.open "DSN=Cards"
  5.  
  6. set rs = Server.createobject("ADODB.recordset")
  7. rs.open "Select * from Cards where CardID = " + request("CardID"), conn, 1, 2, 1
  8.  
  9. rs("Year") = request("Year")
  10. rs("Issuer") = request("Issuer")
  11. rs("SetName") = request("SetName")
  12. rs("CardNumber") = request("CardNumber")
  13. rs("Description") = request("Description")
  14. rs("Grade") = request("Grade")
  15. rs("Value") = request("Value")
  16.  
  17. on error resume next
  18. rs.Update
  19.  
  20. if err then %>
  21. <h2 align="center">An error occurred updating the database:</h2>
  22. <h3 align="center"><%= err.description %></h3>
  23. <% else %>
  24. <h2 align="center">Updates successful!</h2>
  25. <% end if %>
  26. </body></html>
  27.