|
 |
asp_ado_rds thread: RDS : SubmitChanges dose not Update !
Message #1 by vivekMdeshpande@r... on Sat, 26 May 2001 10:25:47
|
|
Below is my code, SubmitChanges is not working !
<!-- Default.ASP -->
<HTML>
<BODY>
<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
ID="dsoAuthor" WIDTH="0" HEIGHT="0">
<PARAM NAME = "URL" VALUE="RecordSet.ASP">
</OBJECT>
<TABLE ID="tblData" DATASRC="#dsoAuthor">
<TR>
<TD><INPUT TYPE="TEXT" DATAFLD="au_id" ></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="au_fname"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="au_lname"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="phone"></INPUT></TD>
</TR>
</TABLE>
<BUTTON ID="btnCancelAll" TITLE "AbandonChanges"
ONCLICK= "dsoAuthor.CancelUpdate()">Abandon Changes</BUTTON>
<BUTTON ID="btnCancelAll" TITLE "UpdateChanges"
ONCLICK= "dsoAuthor.SubmitUpdates()">Update Changes </BUTTON>
<BUTTON ID="btnCancelAll" TITLE "AddNewRecord "
ONCLICK= "dsoAuthor.Recordset.AddNew()">Add New Records</BUTTON>
<BUTTON ID="btnCancelAll" TITLE "Abandon Changes"
ONCLICK= "dsoAuthor.Recordset.Delete()">Delete Record </BUTTON>
------------------------------------------------------------------
Below is code from Recordset.ASP
<%
dim dsoData
dim myConn
myConn="Provider=SQLOLEDB.1;Persist Security Info=False;Initial
Catalog=pubs;Data Source=webserver;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with
column collation when possible=False;User Id=sa;"
SET dsoData = Server.CreateObject("ADODB.Recordset")
dsoData.Open "SELECT * FROM Authors",myConn
dsoData.Save Response,adPersistXML
dsoData.Close
Set dsoData = Nothing
%>
Message #2 by Josh King <JoshK@g...> on Tue, 29 May 2001 08:26:36 -0500
|
|
You have dsoAuthor.SubmitUpdates()
You need to have dsoAuthor.SubmitChanges()
Josh King
-----Original Message-----
From: vivekMdeshpande@r... [mailto:vivekMdeshpande@r...]
Sent: Saturday, May 26, 2001 5:26 AM
To: ASP_ADO_RDS
Subject: [asp_ado_rds] RDS : SubmitChanges dose not Update !
Below is my code, SubmitChanges is not working !
<!-- Default.ASP -->
<HTML>
<BODY>
<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
ID="dsoAuthor" WIDTH="0" HEIGHT="0">
<PARAM NAME = "URL" VALUE="RecordSet.ASP">
</OBJECT>
<TABLE ID="tblData" DATASRC="#dsoAuthor">
<TR>
<TD><INPUT TYPE="TEXT" DATAFLD="au_id" ></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="au_fname"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="au_lname"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="phone"></INPUT></TD>
</TR>
</TABLE>
<BUTTON ID="btnCancelAll" TITLE "AbandonChanges"
ONCLICK= "dsoAuthor.CancelUpdate()">Abandon Changes</BUTTON>
<BUTTON ID="btnCancelAll" TITLE "UpdateChanges"
ONCLICK= "dsoAuthor.SubmitUpdates()">Update Changes </BUTTON>
<BUTTON ID="btnCancelAll" TITLE "AddNewRecord "
ONCLICK= "dsoAuthor.Recordset.AddNew()">Add New Records</BUTTON>
<BUTTON ID="btnCancelAll" TITLE "Abandon Changes"
ONCLICK= "dsoAuthor.Recordset.Delete()">Delete Record </BUTTON>
------------------------------------------------------------------
Below is code from Recordset.ASP
<%
dim dsoData
dim myConn
myConn="Provider=SQLOLEDB.1;Persist Security Info=False;Initial
Catalog=pubs;Data Source=webserver;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with
column collation when possible=False;User Id=sa;"
SET dsoData = Server.CreateObject("ADODB.Recordset")
dsoData.Open "SELECT * FROM Authors",myConn
dsoData.Save Response,adPersistXML
dsoData.Close
Set dsoData = Nothing
%>
|
|
|
View Cart
