改为sql语句的代码
Article_ByMonth=Year(date)&month(date)&"||"&Year(now())&"年"&MonthName(Month(Article_Time))&"份"SqlString="INSERT INTO [Article] (User_ID,User_Name,Article_Title,Article_Zy,Blog_Info,Whather,Article_ByMonth,Article_Hid,Article_Time,Article_ByClass,Article_Code,Article_Bl,Article_Form,Article_Tag,Blog_Quote,IP)"
SqlString=SqlString & " VALUES("& Session("UserID") &",'"& Session("UserName") &"','"& Article_Title &"','"& Article_Zy &"','"& Article_Message &"','"& Article_Whather &"','"& Article_ByMonth &"',"& Article_Hid &",'"& Article_Time &"','"& Article_Class &"','"& Article_SysCode &"','"& ArticleBl &"','"& Articleform &"','"& Article_Tag &"','"& QuoteUrl &"','"& IP &"')"
Conn.Execute (SqlString)
ArticleID=CONN.EXECUTE("SELECT @@IDENTITY FROM [Article]")(0)
SqlCount=SqlCount+2
'数据库操作完毕
[此贴子已经被作者于2006-5-22 17:02:56编辑过]
vz1YFVYl.bmp
(438.87 KB)