Whats wrong with this ASP code?

PLease can u tell me whats wrong ...

sqlTemp = "INSERT INTO tUsers ( UserID, username, password, accesslevel, points, posts, Name, Email ) VALUES ( " & userID & ", '" & username & "', '" & password & "', 1, 0, 0,'" & realname & "', '" & email & "');"

Don't know, Maybe you've missed single commers from the hard coded parts:

sqlTemp = "INSERT INTO tUsers ( UserID, username, password, accesslevel, points, posts, Name, Email )
VALUES ( '" & userID & "', '" & username & "', '" & password & "', '1', '0', '0', '" & realname & "', '" & email & "');"

It would probably help if you told us what the problem is.. what error message/odd behavior are you getting.

Your code looks fine if your trying to assign a SQL Insert statement into a variable called sqlTemp.