getting variables into database

[sq000]

hi im trying to get variables into a database,
can anyone see anything obviousley wrong with this code?
the problem seems to be in the "insert" i would be very greatful for any help

var Command1 = Server.CreateObject("ADODB.Command"
Command1.ActiveConnection = MM_lostat_STRING;
Command1.CommandText = "INSERT INTO tblStats (Recorded, RemoteAddress, HttpReferer, HttpUserAgent, WebPage) VALUES ('" & Request("date&quot & "', '" & Request("REMOTE_ADDR&quot & "', '" & Request("HTTP_REFERER&quot & "', '" & Request("HTTP_USER_AGENT&quot & "', '" & Request("URL&quot & "') ";
Command1.CommandType = 1;
Command1.CommandTimeout = 0;
Command1.Prepared = true;
Command1.Execute();

 

[IonelBurtan]

What's the error that you get? s-)

Blessed is he who in the name of justice and good will, shepards the week through the valley of darknees...

http://www20.brinkster.com/ionelb