04. oktober 2002 - 20:41
Der er
6 kommentarer og 1 løsning
opdater
<% Set Conn = Server.CreateObject("ADODB.Connection") DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; " DSN = DSN & "DBQ=" & Server.MapPath("db.mdb") Conn.Open DSN For Each Id in Request.Form("id") %> <% do while not EOF %> <% strSQL = "Update barometer SET " _ & "alder = " & Request.Form("alder" & Id) & ", "_ & "klasse = '" & Request.Form("klasse" & Id) & "', "_ & "patter = " & Request.Form("patter" & Id) & ", "_ & "roev = " & Request.Form("roev" & Id) & ", "_ & "krop = " & Request.Form("krop" & Id) & ", "_ & "cme = " & Request.Form("cme" & Id) & ", "_ & "aksp = '" & Request.Form("aksp" & Id) & "', "_ & "kommentar = '" & Request.Form("kommentar" & Id) & "' "_ & "WHERE id = " & Id %> <% loop %> <% movenext %> <% Next Conn.execute(strSQL) Conn.Close Set Conn = Nothing response.redirect("default1.asp") %> <html> <head> <title></title> </head> <body> </body> </html> Denne kode bruger jeg til at opdatere en masse oplysninger på en gang Men den melder fejl Active Server Pages error 'ASP 0113' Script timed out /update.asp The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools. Er der noget galt med scriptet ?
Annonceindlæg tema
Cloud & AI
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
04. oktober 2002 - 21:13
#1
hmmm - prøv dette engang; <% Set Conn = Server.CreateObject("ADODB.Connection") DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; " DSN = DSN & "DBQ=" & Server.MapPath("db.mdb") Conn.Open DSN For Each Id in Request.Form("id") strSQL = "Update barometer SET " _ & "alder = " & Request.Form("alder" & Id) & ", "_ & "klasse = '" & Request.Form("klasse" & Id) & "', "_ & "patter = " & Request.Form("patter" & Id) & ", "_ & "roev = " & Request.Form("roev" & Id) & ", "_ & "krop = " & Request.Form("krop" & Id) & ", "_ & "cme = " & Request.Form("cme" & Id) & ", "_ & "aksp = '" & Request.Form("aksp" & Id) & "', "_ & "kommentar = '" & Request.Form("kommentar" & Id) & "' "_ & "WHERE id = " & Id Next Conn.execute(strSQL) Conn.Close Set Conn = Nothing response.redirect("default1.asp") %> <html> <head> <title></title> </head> <body> </body> </html>
04. oktober 2002 - 21:14
#2
hvorfor bruger du Dette? For Each Id in Request.Form("id")
06. oktober 2002 - 01:11
#3
Du burde sq snart have lært det... eller VIL du bare ikke lære det ?? <% Set Conn = Server.CreateObject("ADODB.Connection") DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; " DSN = DSN & "DBQ=" & Server.MapPath("db.mdb") Conn.Open DSN For Each Id in Request.Form("id") strSQL = "Update barometer SET " _ & "alder = " & Request.Form("alder" & Id) & ", "_ & "klasse = '" & Request.Form("klasse" & Id) & "', "_ & "patter = " & Request.Form("patter" & Id) & ", "_ & "roev = " & Request.Form("roev" & Id) & ", "_ & "krop = " & Request.Form("krop" & Id) & ", "_ & "cme = " & Request.Form("cme" & Id) & ", "_ & "aksp = '" & Request.Form("aksp" & Id) & "', "_ & "kommentar = '" & Request.Form("kommentar" & Id) & "' "_ & "WHERE id = " & Id Conn.execute(strSQL) Next Conn.Close Set Conn = Nothing response.redirect("default1.asp") %>
06. oktober 2002 - 01:14
#4
Jamen det virker altså ikke. den melder ikke fejl men opdatere heller ikke.
06. oktober 2002 - 01:32
#6
<% Set Conn = Server.CreateObject("ADODB.Connection") DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; " DSN = DSN & "DBQ=" & Server.MapPath("db.mdb") Conn.Open DSN For Each Id in Request.Form("id") strSQL = "Update barometer SET " _ & "alder = " & Request.Form("alder" & Id) & ", "_ & "klasse = '" & Request.Form("klasse" & Id) & "', "_ & "patter = " & Request.Form("patter" & Id) & ", "_ & "roev = " & Request.Form("roev" & Id) & ", "_ & "krop = " & Request.Form("krop" & Id) & ", "_ & "cme = " & Request.Form("cme" & Id) & ", "_ & "aksp = '" & Request.Form("aksp" & Id) & "', "_ & "kommentar = '" & Request.Form("kommentar" & Id) & "' "_ & "WHERE id = " & Id Conn.execute(strSQL) Next Conn.Close Set Conn = Nothing response.redirect("default1.asp") %> <html> <head> <title></title> </head> <body> </body> </html>
06. oktober 2002 - 01:32
#7
asd
Kurser inden for grundlæggende programmering