Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Fields being deleted when Modifying


Message #1 by "Joshua Krause" <jkrause@t...> on Sat, 6 Apr 2002 15:44:18
There are 2 fields that go blank after i modify a record.  Any one got any 
ideas.
Here is my code:

<%@ Language="VBScript" %>
<%
	Set RRConn = Server.CreateObject("ADODB.Connection")
	RRConnstring = "DSN=Contact; UID=; PWD="
	RRConn.Open(RRConnstring)

	If Request.Form("Type") = "Delete" Then
		Set rrRst = Server.CreateObject("ADODB.Recordset")
		sqlstring = "DELETE FROM [Contact] WHERE [ID] =" & 
Request.Form("Contact")
		rrRst.Open sqlstring, RRConn, 3, 3
		RRConn.Close
		Response.Write "<center><b>Record was deleted</center></b>"
	End If
	If Request.Form("Type") = "Modify" Then
		Set rrRst = Server.CreateObject("ADODB.Recordset")
		sqlstring = "UPDATE Contact SET Account = '" & Request.Form
("Account") & "', Customer = '" & Request.Form("Customer") & "', 
Street_Address = '" & Request.Form("Street_Address")  & "', Phone = '" & 
Request.Form("Phone") & "', Batch = '" & Request.Form("Batch") & "', 
Technical_Contact = '" & Request.Form("Technical_Contact") & "', Email 
= '" & Request.Form("Email") & "', Old_IP = '" & Request.Form("Old_IP") 
& "', New_IP = '" & Request.Form("New_IP") & "', MAC_Addy = '" & 
Request.Form("MAC_Addy") & "', Node = '" & Request.Form("Node") & "', CMTS 
= '" & Request.Form("CMTS") & "', GW_IP = '" & Request.Form("GW_IP") & "', 
Start = '" & Request.Form("Start") & "', E_n_d = '" & Request.Form
("E_n_d") & "', NAT_GW_IP = '" & Request.Form("NAT_GW_IP") & "', 
Static_NAT = '" & Request.Form("Static_NAT") & "', Port_Fwds = '" & 
Request.Form("Port_Fwds") & "', DHCP = '" & Request.Form("DHCP") & "', 
Subnet = '" & Request.Form("Subnet") & "', Notes = '" & Request.Form
("Notes") & "', Pre_Conf_On = '" & Request.Form("Pre_Conf_On") & "', 
Post_Conf_On = '" & Request.Form("Post_Conf_On") & "', Pre_Call_Done = '" 
& Request.Form("Pre_Call_Done") & "', Post_Call_Done = '" & Request.Form
("Post_Call_Done") & "', Updated_by = '" & Request.Form("Updated_by") 
& "', Date_Updated = '" & Request.Form("Date_Updated") & "' WHERE ID = " & 
Request.Form("Contact")
		rrRst.Open sqlstring, RRConn, 3, 3
		'rrRst.Fields("Account") = Request.Form("Account")
		'rrRst.Fields("Customer") = Request.Form("Customer")
		'rrRst.Fields("Street_Address") = Request.Form
("Street_Address")
		'rrRst.Fields("Phone") = Request.Form("Phone")
		'rrRst.Fields("Batch") = Request.Form("Batch")
		'rrRst.Fields("Technical_Contact") = Request.Form
("Technical_Contact")
		'rrRst.Fields("Email") = Request.Form("Email")
		'rrRst.Fields("Old_IP") = Request.Form("Old_IP")
		'rrRst.Fields("New_IP") = Request.Form("New_IP")
		'rrRst.Fields("MAC_Addy") = Request.Form("MAC_Addy")
		'rrRst.Fields("Node") = Request.Form("Node")
		'rrRst.Fields("CMTS") = Request.Form("CMTS")
		'rrRst.Fields("GW_IP") = Request.Form("GW_IP")
		'rrRst.Fields("Start") = Request.Form("Start")
		'rrRst.Fields("E_n_d") = Request.Form("E_n_d")
		'rrRst.Fields("NAT_GW_IP") = Request.Form("NAT_GW_IP")
		'rrRst.Fields("Static_NAT") = Request.Form("Static_NAT")
		'rrRst.Fields("Port_Fwds") = Request.Form("Port_Fwds")
		'rrRst.Fields("DHCP") = Request.Form("DHCP")
		'rrRst.Fields("Subnet") = Request.Form("Subnet")
		'rrRst.Fields("Notes") = Request.Form("Notes")
		'rrRst.Fields("Pre_Conf_On") = Request.Form("Pre_Conf_On")
		'rrRst.Fields("Post_Conf_On") = Request.Form
("Post_Conf_On")
		'rrRst.Fields("Pre_Call_Done") = Request.Form
("Pre_Call_Done")
		'rrRst.Fields("Post_Call_Done") = Request.Form
("Post_Call_Done")
		'rrRst.Fields("Updated_by") = Request.Form("Updated_by")
		'rrRst.Fields("Date_Updated") = Request.Form
("Date_Updated")
		'rrRst.Update
		'rrRst.Close
	   ' Set MyRst = Nothing
		RRConn.Close
		'Set MyConn = Nothing
		Response.Write "<b><center>Record was 
modified</center></b>"
	End If
	If Request.Form("Type") = "Add" Then
		Set rrRst = Server.CreateObject("ADODB.Recordset")
		sqlstring = "SELECT * FROM [Contact] "
		rrRst.Open sqlstring, RRConn, 3, 3
		rrRst.AddNew
		rrRst.Fields("Account") = Request.Form("Account")
		rrRst.Fields("Customer") = Request.Form("Customer")
		rrRst.Fields("Street_Address") = Request.Form
("Street_Address")
		rrRst.Fields("Phone") = Request.Form("Phone")
		rrRst.Fields("Batch") = Request.Form("Batch")
		rrRst.Fields("Technical_Contact") = Request.Form
("Technical_Contact")
		rrRst.Fields("Email") = Request.Form("Email")
		rrRst.Fields("Old_IP") = Request.Form("Old_IP")
		rrRst.Fields("New_IP") = Request.Form("New_IP")
		rrRst.Fields("MAC_Addy") = Request.Form("MAC_Addy")
		rrRst.Fields("Node") = Request.Form("Node")
		rrRst.Fields("CMTS") = Request.Form("CMTS")
		rrRst.Fields("GW_IP") = Request.Form("GW_IP")
		rrRst.Fields("Start") = Request.Form("Start")
		rrRst.Fields("E_n_d") = Request.Form("E_n_d")
		rrRst.Fields("NAT_GW_IP") = Request.Form("NAT_GW_IP")
		rrRst.Fields("Static_NAT") = Request.Form("Static_NAT")
		rrRst.Fields("Port_Fwds") = Request.Form("Port_Fwds")
		rrRst.Fields("DHCP") = Request.Form("DHCP")
		rrRst.Fields("Subnet") = Request.Form("Subnet")
		rrRst.Fields("Notes") = Request.Form("Notes")
		rrRst.Fields("Pre_Conf_On") = Request.Form("Pre_Conf_On")
		rrRst.Fields("Post_Conf_On") = Request.Form("Post_Conf_On")
		rrRst.Fields("Pre_Call_Done") = Request.Form
("Pre_Call_Done")
		rrRst.Fields("Post_Call_Done") = Request.Form
("Post_Call_Done")
		rrRst.Fields("Updated_by") = Request.Form("Updated_by")
		rrRst.Fields("Date_Updated") = Request.Form("Date_Updated")
		rrRst.Update
		rrRst.Close
		'Set MyRst = Nothing
		RRConn.Close
		'Set MyConn = Nothing
		Response.Write"<center><b>Record was added</b></center>"
		
	End If
	'MyConn.Close
	'Set MyConn = Nothing
	%> 
		

	

<html>

<head>
<title>Write to DB</title>
</head>

<body bgcolor="#182831" text="#FFFFFF" link="#FFFF00" vlink="#FFFF00" 
alink="#FF0000">

<p align="center">Please Follow Link back to welcome page </p>
<p align="center">&nbsp;</p>
<p align="center"><a href="welcome.asp">Home</a></p>

</body>

</html>

  Return to Index