5 svar · 301 visningar · startad av scoxi
sql = INSERT INTO UserInformation (UserName, FirstName, SurName, Email, Personalnumber, Passw) sql = sql & " VALUES ("& username &","& firstname &","& surname &","& email &","& personalnumber &","& password &")"
Fel:
Feltyp:
Kompileringsfel i Microsoft VBScript (0x800A0401)
Slut på programsats förväntas.
/michel/register.asp, line 14, column 97
sql = "INSERT INTO UserInformation (UserName, FirstName, SurName, Email, Personalnumber, Passw)" sql = sql & " VALUES ("& username &","& firstname &","& surname &","& email &","& personalnumber &","& password &")"
Du har glömt ett &-tecken. 
sql = "INSERT INTO UserInformation (UserName, FirstName, SurName, Email, Personalnumber, Passw)"
sql = sql & " VALUES (" & username & "," & firstname & "," & surname & "," & email & "," & personalnumber & "," & password & ")"
r/ Fel, radbrytning menade jag ju såklart. 
Det var inte felet...
Den där koden ovanför ska fungera. 
Du såg att jag redigerade koden va? Skriver du den exakt sådär på två rader ska det fungera. Alternativt den här på en rad:
sql = "INSERT INTO UserInformation (UserName, FirstName, SurName, Email, Personalnumber, Passw) VALUES (" & username & "," & firstname & "," & surname & "," & email & "," & personalnumber & "," & password & ")"
jag löste det själv ^^
Vad var det för fel?