|
網站計數器 counter.asp 中下命令
可以同時用命令插入二個欄位資料嗎?
我的程式如下,但無法執行,請問要怎麼作?
<%
Set Command1 = Server.CreateObject ("ADODB.Command") Command1.ActiveConnection = MM_chinamember_STRING Command1.CommandText = "INSERT INTO dbo.ClientMemberData (count_ip, mybiz_memberName) VALUES ('"&Request.ServerVariables("REMOTE_ADDR")&(ClientMember.Fields.Item("mybiz_memberName").Value)"')"" Command1.CommandType = 1 Command1.CommandTimeout = 0 Command1.Prepared = true Command1.Execute()
%> |