467,138 Members | 1,362 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,138 developers. It's quick & easy.

Problem with Insert in to IP to Microsoft Acess by ASP

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

Dec 27 '05 #1
  • viewed: 1087
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Robert Ludig | last post: by
reply views Thread by Rodrigo m. Ferreira | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.