$rs->movenext()我会了,现在是
$rs->addnew();
$rs->fields("username")="asd";
$rs->fields("password")="asd";
$rs->fields("id")=4;
$rs->updata();
好象不行,应该怎么样写?
$rs->addnew();
$rs->fields("username")="asd";
$rs->fields("password")="asd";
$rs->fields("id")=4;
$rs->updata();
好象不行,应该怎么样写?
/////////////////////////////////////////////////////////////
<?
//phpinfo();
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("driver={sql server};uid=php;pwd=php;server=localhost;database=testphp");
$rs=new com("adodb.recordset");
$rs->open("select * from [user]",$conn,3,3); // Recordset$rsname=$rs->Fields("username");
for($i=0; $i<4; $i++)
{
$rs->AddNew();
$rsname->value="ppII".$i;
$rs->update();
}
$rs->Close();
$conn->Close();$rs->Release();
$conn->Release();$rs = null;
$conn = null;