Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Disconnected Recordset


Message #1 by "Eddy S Bodhi" <eddysatya@y...> on Thu, 10 Jan 2002 10:35:01 +0700
This is a multi-part message in MIME format.



------=_NextPart_000_0013_01C199C2.75411830

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Hi,



I have used RDS 2.5 on client side with browser IE 5.0

I have typed the following code in my client side script :



<script language=3D"JScript">

............

  function updateAll()

 {

      myDSO.submitChanges();

     myDSO.refresh();

 }

............

</script>

........

<body>

<object classid=3D"clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"

       id=3D"myDSO" ondatasetcomplete=3D"createCells()" height=3D"0" 

width=3D"0">

       <param name=3D"URL" value=3D"pagedata.asp?table=3Dtopic">

</object>

<table id=3D"mytable" datasrc=3D"myDSO">

  ........

</table>

.............

</body>



PageData.asp contains the following script :

<%

       dim dbDir, connstr

       dim conn, rs

       dim strTable

                            

       dbDir =3D server.MapPath("mydb.mdb")

       connstr =3D "Provider=3DMicrosoft.Jet.Oledb.4.0; Data Source=3D" 

& dbDir

       set conn =3D server.CreateObject("Adodb.connection")

       conn.Open connstr

       set rs =3D server.CreateObject("Adodb.recordset")

       strTable =3D Request.QueryString("table")

      

       rs.CursorLocation =3D adUseClient

       rs.Open strTable, conn,adOpenDynamic ,adLockOptimistic , 

adCmdtable

           

       rs.Save response, adPersistXML

      

       rs.Close       

       set rs =3D nothing             

%>



After I modified some records in client side, I call updateAll() 

function.

But the modifid records on server side were not change.

Could any body help me to solve this problem ?



Thanks,



Eddy




















_________________________________________________________



Do You Yahoo!?



Get your free @yahoo.com address at http://mail.yahoo.com








  Return to Index