inserting variables into access2000 db

[sq000]

ive been trying to get variables into a database

"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 & "') ";

i have tried variations without sucess, if anyone can help i would be
very greatful

 

[Microbe]

I suggest stripping out most of the variables and starting with one pair.

See if it works. If so, add another.

Eventually you will find which one is breaking it and be able to work out why. Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au