$db = 'F:\\wwwroot\\xxxxxx.mdb';
$conn = new COM('ADODB.Connection');
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db");
$db_usrname="root";
$db_password="";
$sql = 'SELECT * FROM article ORDER BY id';
$rs = $conn->Execute($sql);
$conn=mysql_connect("localhost",$db_usrname,$db_password) or die ('I cannot connect to the database.');
mysql_select_db("software",$conn);
while (!$rs->EOF):
//下面就是报错的行
mysql_query("insert into article (ID,title,content,link_name,ftp_url,Publisher,OSSupport,License,Dateadded,LastUpdate,Size,title_url,download_url,lanmu,lanmu_folder,fenlei,fenlei_folder) values('$rs->Fields['id']->Value','$rs->Fields['title']->Value','$rs->Fields['content']->Value','$rs->Fields['link_name']->Value','$rs->Fields['ftp_url']->Value','$rs->Fields['Publisher']->Value','$rs->Fields['OSSupport']->Value','$rs->Fields['License']->Value','$rs->Fields['Dateadded']->Value','$rs->Fields['LastUpdate']->Value','$rs->Fields['Size']->Value','$rs->Fields['title_url']->Value','$rs->Fields['download_url']->Value','$rs->Fields['lanmu']->Value','$rs->Fields['lanmu_folder']->Value','$rs->Fields['fenlei']->Value','$rs->Fields['fenlei_folder']->Value')");
$rs->MoveNext();
endwhile;
$rs->Close();
$conn->Close();
报的错误是:Catchable fatal error: Object of class variant could not be converted to string in
这可能是空字符造成的，应该怎么办？谢谢 |
