5 svar · 294 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. :r
Det var inte felet...
Den där koden ovanför ska fungera. :q
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?