General information
Category:
Internet applications
I am trying to post a date from asp to a foxpro database. I keep getting an "Invalid Data Type" error. The field is formatted as a date field in foxpro. Can anyone help me to resolve this? Here is a sample of the asp code (very simplified):
today = now
Set Conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN=test"
SQL="INSERT INTO foxtable(date) Values (" &_
"'" & today + "')"
Set RS = Conn.Execute(SQL)
set rs=nothing
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only