Insert SQL problem (Jamie)

[777axa]

I don't know what happend to previous thred.
Below is what worked for me.
Note: I think that the problem was that you named your fields with reserved words like time or date - use prefixes - showTime, showDate

In your case [ ] around the names are needed
--------------------------------------------------
Dim varDate, varTime, varVenue, varLocation, varInfo

varDate=Request.Form("date&quot
varTime=Request.Form("time&quot
varVenue=Request.Form("venue&quot
varLocation=Request.Form("location&quot
varInfo=Request.Form("info&quot

Set cn = Server.CreateObject("ADODB.Connection&quot
cn.open ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\_webs\db\database.mdb;Persist Security Info=False&quot

sql="INSERT INTO shows_table ([date], [time], [venue], [location], [info]) VALUES ("

sql=sql & "'" & varDate & "'"
sql=sql & ", '" & varTime & "'"
sql=sql & ", '" & varVenue & "'"
sql=sql & ", '" & varLocation & "'"
sql=sql & ", '" & varInfo & "')"
response.write sql ' look at your actual string
cn.Execute sql

cn.close
cn=nothing