Nogle der kan hjælpe mig??
Jeg har denne kode som I ser nede under, men jeg skal udfylde alle felter for at den vil godtage og sende til min database.hvordan gør jeg så jeg ikke behøber at udfylde alle felterne??
<%
If Request.ServerVariables("Request_Method") = "POST" Then
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../db/databaser.mdb")
Conn.Open DSN
Conn.Execute("Insert into film ("& _
"dansk_titel,orginal_titel,orginal_sprog,oprettet,instruktoer,medvirkenden,historie,spilletid,censur,bio_premerer,video_premerer,dvd_premerer,officel_hp,produktions_aar,film_selskab,Genre"& _
") values("& _
"'" & Request.Form("dansk_titel") & "','" & Request.Form("orginal_titel") & "','" & Request.Form("orginal_sprog") & "','" & Now() & "','" & Request.Form("instruktoer") & "','" & Request.Form("medvirkenden") & "','" & Request.Form("historie") & "','" & Request.Form("spilletid") & "','" & Request.Form("censur") & "','" & Request.Form("bio_premerer") & "','" & Request.Form("video_premerer") & "','" & Request.Form("dvd_premerer") & "','" & Request.Form("officel_hp") & "','" & Request.Form("produktions_aar") & "','" & Request.Form("film_selskab") & "','" & Request.Form("Genre") & "')")
Response.write"<h1>opdateret</H1> "
' Luk databaseforbindelse
Conn.Close
Set Conn = Nothing
End if %>
<TABLE ALIGN="left" BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="100%">
<%
response.write"<form action=""tilfoej_film.asp"" method=""post""><tr><td widht=""25%"">Dansk titel:</td><td widht=""25%""><input type=""text"" name=""dansk_titel"" size=""80""></td><td widht=""25%"">Max 255 tegn</td></tr><tr><td widht=""25%"">Orginal titel</td><td widht=""25%""><input type=""text"" name=""orginal_titel"" size=""80""></td><td widht=""25%"">Max 255 tegn</td></tr><tr><td widht=""25%"">orginal_sprog</td><td widht=""25%""><input type=""text"" name=""orginal_sprog"" size=""80""></td><td widht=""25%"">Max 255 tegn</td></tr><tr><td widht=""25%"">instruktoer</td><td widht=""25%""><input type=""text"" name=""instruktoer"" size=""80""></td><td widht=""25%"">Max 255 tegn</td></tr><tr><td widht=""25%"">medvirkenden</td><td widht=""25%""><input type=""text"" name=""medvirkenden"" size=""80""></td><td widht=""25%"">Max 255 tegn</td></tr><tr><td widht=""25%"">historie</td><td widht=""25%""><input type=""text"" name=""historie"" size=""80""></td><td widht=""25%"">Max 255 tegn</td></tr><tr><td widht=""25%"">spilletid</td><td widht=""25%""><input type=""text"" name=""spilletid"" size=""80""></td><td widht=""25%"">I minutter 1 time = 60 min</td></tr><tr><td widht=""25%"">censur</td><td widht=""25%""><input type=""text"" name=""censur"" size=""80""></td><td widht=""25%"">7 - 11 - 15</td></tr><tr><td widht=""25%"">bio_premerer</td><td widht=""25%""><input type=""text"" name=""bio_premerer"" size=""80""></td><td widht=""25%"">Skriv dato dd-mm-åå</td></tr><tr><td widht=""25%"">video_premerer</td><td widht=""25%""><input type=""text"" name=""video_premerer"" size=""80""></td><td widht=""25%"">dd-mm-åå</td></tr><tr><td widht=""25%"">dvd_premerer</td><td widht=""25%""><input type=""text"" name=""dvd_premerer"" size=""80""></td><td widht=""25%"">dd-mm-åå</td></tr><tr><td widht=""25%"">officel_hp</td><td widht=""25%""><input type=""text"" name=""officel_hp"" size=""80""></td><td widht=""25%"">skriv uden http://</td></tr><tr><td widht=""25%"">produktions_aar</td><td widht=""25%""><input type=""text"" name=""produktions_aar"" size=""80""></td><td widht=""25%"">Skriv kun årstallet</td></tr><tr><td widht=""25%"">film_selskab</td><td widht=""25%""><input type=""text"" name=""film_selskab"" size=""80""></td><td widht=""25%"">Max 255 tegn</td></tr><tr><td widht=""25%"">Genre</td><td widht=""25%""><input type=""text"" name=""Genre"" size=""80""></td><td widht=""25%"">Max 255 tegn</td></tr><tr><td widht=""25%""><tr><td><input type=""submit"" value=""Gem""></td></tr></form>"
%>
ps. jeg er villig til at gide 150 poing hvis der er en der kan lave min kode så der er nemmere at overskue.
