PDA

Click to See Complete Forum and Search --> : Whats wrong with this ASP code?

TvJames
Nov 7th, 2000, 02:10 AM
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 & "');"
Skeen
Nov 7th, 2000, 06:27 AM
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 & "');"
monte96
Nov 7th, 2000, 10:07 AM
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.