Passing variables with VBcript
February 7, 2006 12:00 AM
From glancing at it, it appears that your variable names might not be correct. They should not begin with "Var" unless you've named custom ones this way. It should look like:time=Request.form("ElapsedTime") date=Request.form("CurrentDate") title=Request.form("CurrentTitleName") Also, in your SQL statement has a syntax error. It has a single quote for the begining and ending values, but is not properly ended. sSQL = "INSERT INTO MAIN(Score,time,date,title) VALUES ( '" & score & "', '" & time & "', '" & date & "', '" & title & "')" I recommend starting with the Access Database example posted in this topic: Topic: Sorting Test ResultsThen customize the code accordingly.Edited By: aaron on 2006-2-7 11:14:27
Discussions have been disabled for this post