M
minhadd
Hello
Would Anyone help me ??
I want insert into Microsoft Acess visitor's IP by ASP. But It is not
working
----------------------------------------------------------------------------------------------------------
NOT WORK
<%
........
time = now()
ipp = Request.ServerVariables("remote_addr")
strSQL = "INSERT INTO visitor (time,ipp) VALUES ('" & time & "','" &
ipp & "')"
Set rs = myConnection.Execute(strSQL)
........
%>
-----------------------------------------------------------------------------------------------------------
I tested part of the ASP script then It work very well. Below:
WORK VERY WELL
<%
.......
time = now()
strSQL = "INSERT INTO visitor (time) VALUES ('" & time & "')"
Set rs = myConnection.Execute(strSQL)
......
%>
I created Access database. There are 2 field : time and ipp. Data type
of time is date. Data tye of IPP is text.
I think: Maybe in Access database: the field IPP was problem with data
type.
Thank you for your help...
http://www.anluc.com
Would Anyone help me ??
I want insert into Microsoft Acess visitor's IP by ASP. But It is not
working
----------------------------------------------------------------------------------------------------------
NOT WORK
<%
........
time = now()
ipp = Request.ServerVariables("remote_addr")
strSQL = "INSERT INTO visitor (time,ipp) VALUES ('" & time & "','" &
ipp & "')"
Set rs = myConnection.Execute(strSQL)
........
%>
-----------------------------------------------------------------------------------------------------------
I tested part of the ASP script then It work very well. Below:
WORK VERY WELL
<%
.......
time = now()
strSQL = "INSERT INTO visitor (time) VALUES ('" & time & "')"
Set rs = myConnection.Execute(strSQL)
......
%>
I created Access database. There are 2 field : time and ipp. Data type
of time is date. Data tye of IPP is text.
I think: Maybe in Access database: the field IPP was problem with data
type.
Thank you for your help...
http://www.anluc.com