代码:<%dim mysql_conn,mysql_sql
set mysql_conn = server.createobject("adodb.connection")
mysql_conn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=×××;USER=×××;PASSWORD=×××;" mysql_sql="insert into cms_article (ArticleClassID,ArticleTitle,FromSource,summarytxt,ArticleContent,Accessories,TagIDs,HomePageImage,HomePageTitle,bUse,PublishDate,PublisherName,PublisherID,setTop,recommend,ClickCount) values(5001,'西门','医药经济报','更具','更加','',0,'','',1,'2008-07-28 11:04:43','',0,1,1,55)"mysql_conn.execute(mysql_sql)%>数据库结构:
set mysql_conn = server.createobject("adodb.connection")
mysql_conn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=×××;USER=×××;PASSWORD=×××;" mysql_sql="insert into cms_article (ArticleClassID,ArticleTitle,FromSource,summarytxt,ArticleContent,Accessories,TagIDs,HomePageImage,HomePageTitle,bUse,PublishDate,PublisherName,PublisherID,setTop,recommend,ClickCount) values(5001,'西门','医药经济报','更具','更加','',0,'','',1,'2008-07-28 11:04:43','',0,1,1,55)"mysql_conn.execute(mysql_sql)%>数据库结构:
插入字段列表中貌似没有articleid,自增类型?
除非是自增字段那种。
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html