...nu kan jag plötsligt inte göra egna databaser... Nevermind... =)Jaha, jättekul detta var då...
Får detta meddelande när jag försöker INSERT:a:
HTTP Error 405
405 Method Not Allowed
The method specified in the Request Line is not allowed for the resource identified by the request. Please ensure that you have the proper MIME type set up for the resource you are requesting.
Please contact the server's administrator if this problem persists.
Jöbbegt med såna grejer...
Här är koden:
<code>
If Request.Form("password1") = Request.Form("password2") Then
firstname = Request.Form("firstname")
surname = Request.Form("surname")
nickname = Request.Form("nickname")
password = Request.Form("password1")
email = Request.Form("email")
city = Request.Form("city")
homepage = Request.Form("homepage")
ip = Request.SeverVariables(Remote_ADDR)
dateNow = now()
status = "online"
Else
Response.Redirect "default.asp?regga=:)&fel=pass"
End If
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("databas.mdb")
SQL = "INSERT INTO members(firstname, surname, nickname, password, email, city, homepage, ip, date, status)"
SQL = SQL & "VALUES('" & firstname & "','" & surname & "','" & nickname & "','" & password & "','" & email & "','" & city & "','" & homepage & "','" & ip & "',#" & dateNow & "#,'" & status & "')"
Response.Write SQL
Conn.Execute(SQL)
Conn.Close
Set Conn = Nothing
</code>
Hoppas ni kan hjälpa...
Tja!Sv: Jaha, jättekul detta var då...
Jag kom på re... Jag hade skrivit ett &-tecken istället för ett ?-tecken (varför..?) i action på formen... jaja, tja!!