Slettet bruger
08. juni 2000 - 18:31
Der er
41 kommentarer og 1 løsning
find roden WWW
Den er her virker !!!! ----- <% Dim stMode stMode = request("mode") Dim DirPath, MDBPath, DBPath, connect DirPath = Request.serverVariables("APPL_PHYSICAL_PATH") 'finder wwwroot MDBPath = "../database/users.mdb" 'angiver DB'ens path i forhold til wwwroot DBPath = Dirpath & MDBPath Set Connect = server.createobject("ADODB.connection") Connect.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DBPath %> ------- Så har en hjulpet mig med en fil der ser sådan ud. ------- <%@ Language=VBScript %> <% if Request.QueryString("mode") = "del" then Response.Buffer = true Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../database/users.mdb") & ";DriverId=25;FIL=MS Access" Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "Delete * FROM tblUsers WHERE (id = " & Request.QueryString("u") & ")" rs.Open strSQL, myConn, 1, 3 Response.Redirect "file.asp" else %> den der :Request.serverVariables("APPL_PHYSICAL_PATH") Hvordan får jeg den sat ind i den nederste version ??? someone help - skal lige siges jeg har Viborgnet
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.
Hvordan skal den sættes ind ?? :)
<%@ Language=VBScript %> <% if Request.QueryString("mode") = "del" then Response.Buffer = true Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "Delete * FROM tblUsers WHERE (id = " & Request.QueryString("u") & ")" rs.Open strSQL, myConn, 1, 3 Response.Redirect "file.asp" else %> hvis det bare et diret til databasen, så skal det laves sådan her!
Det vil sige : <%@ Language=VBScript %> <% Dim stMode stMode = request("mode") Dim DirPath, MDBPath, DBPath, connect DirPath = Request.serverVariables("APPL_PHYSICAL_PATH") 'finder wwwroot MDBPath = "../database/users.mdb" 'angiver DB'ens path i forhold til wwwroot DBPath = Dirpath & MDBPath if Request.QueryString("mode") = "del" then Response.Buffer = true Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "Delete * FROM tblUsers WHERE (id = " & Request.QueryString("u") & ")" rs.Open strSQL, myConn, 1, 3 Response.Redirect "file.asp" else ' husk at skrive noget her! End If %>
Slettet bruger
08. juni 2000 - 19:29
#4
synes ikke det funker alså det jo to forskellige måder at gør det på !!! Den ene måde virker det behøver i ikke for tælle mig. Men kan den sættes ind i den nederste version ??? Den skal finde roden !!!!
Slettet bruger
08. juni 2000 - 19:30
#5
<%@ Language=VBScript %> <% if Request.QueryString("mode") = "del" then Response.Buffer = true Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../database/users.mdb") & ";DriverId=25;FIL=MS Access" Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "Delete * FROM tblUsers WHERE (id = " & Request.QueryString("u") & ")" rs.Open strSQL, myConn, 1, 3 Response.Redirect "file.asp" else %> Det her skal sættes ind men hvor ??? Request.serverVariables "APPL_PHYSICAL_PATH")
Hmm .... Endnu en fusker!!!!!!!! Den er da sat ind i den nedderste!!!! Hvis du siger, at den øverste virker, hvor man bruger DBPath .... så virker det jeg har lavet også, idet jeg sætter variablen DBPath ind !! Med mindre du selvfølgelig har lagt filerne i forskellige dir
Slettet bruger
08. juni 2000 - 19:32
#7
ups forkert nick sorry
<%@ Language=VBScript %> <% if Request.QueryString("mode") = "del" then Response.Buffer = true Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Request.serverVariables "APPL_PHYSICAL_PATH") & "../database/users.mdb";DriverId=25;FIL=MS Access" Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "Delete * FROM tblUsers WHERE (id = " & Request.QueryString("u") & ")" rs.Open strSQL, myConn, 1, 3 Response.Redirect "file.asp" else %>
Ja forkert NICK ... det er IKKE lovligt !!
Slettet bruger
08. juni 2000 - 19:36
#10
Fejl - jeg brugte min maskine nr. to - hvor jeg har haft en konto sat op tidligere - kunne ikke lige huske pass så jeg oprettede en ny ... er det ulovligt ?
Slettet bruger
08. juni 2000 - 19:37
#11
den logger jo ind automatisk - så ser mand et jo ikke
08. juni 2000 - 19:37
#12
Jep ... Har du fået det til at virke ??? (det virker nemlig)
Slettet bruger
08. juni 2000 - 19:40
#13
nææ fejl ---- Microsoft VBScript compilation error '800a0401' Expected end of statement /kartotek/view_user.asp, line 6 myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Request.serverVariables "APPL_PHYSICAL_PATH") --------------------------------------------------------------------------------------^
08. juni 2000 - 19:42
#14
<%@ Language=VBScript %> <% if Request.QueryString("mode") = "del" then Response.Buffer = true Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Request.serverVariables("APPL_PHYSICAL_PATH") & "../database/users.mdb";DriverId=25;FIL=MS Access" Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "Delete * FROM tblUsers WHERE (id = " & Request.QueryString("u") & ")" rs.Open strSQL, myConn, 1, 3 Response.Redirect "file.asp" else %>
Slettet bruger
08. juni 2000 - 19:45
#15
Microsoft VBScript compilation error '800a0400' Expected statement /kartotek/view_user.asp, line 7 & "../database/users.mdb";DriverId=25;FIL=MS Access
08. juni 2000 - 19:46
#16
<%@ Language=VBScript %> <% if Request.QueryString("mode") = "del" then Response.Buffer = true Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Request.serverVariables("APPL_PHYSICAL_PATH") & "../database/users.mdb;DriverId=25;FIL=MS Access" Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "Delete * FROM tblUsers WHERE (id = " & Request.QueryString("u") & ")" rs.Open strSQL, myConn, 1, 3 Response.Redirect "file.asp" else %>
Slettet bruger
08. juni 2000 - 19:52
#17
Stadig fejl !!! gider du sætte det ind i filen !! deb connecter jo flere gange kan du se !!! ------- <%@ Language=VBScript %> <% Response.Buffer = true %> <% select case Request.QueryString("mode") %> <% case "del" Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../database/users.mdb") & ";DriverId=25;FIL=MS Access" Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "Delete * FROM tblUsers WHERE (id = " & Request.QueryString("u") & ")" rs.Open strSQL, myConn, 1, 3 Response.Redirect "view_user.asp" %> <% case "" %> <head> <title>Brugere</title> </head> <BODY bgcolor="#000000" link="#FF0000" vlink="#FF0000" alink="#FF0000"> <img border="0" src="logo.gif"> <p> <font color="#FFFFFF"><% strSQL = "SELECT * from tblUsers" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../database/users.mdb") & ";DriverId=25;FIL=MS Access" Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open strDSN Set rs = myConn.Execute(strSQL) If Not (rs.BOF Or rs.EOF) Then Do While Not rs.EOF %></p> <table border="1" width="760" height="47"> <tr> <td width="80" height="47" rowspan="2"> <p><font color="#FFFFFF"><a href=view_user.asp?mode=del&u=<%=rs("id")%>>slet nr. <%=rs("id")%></a><br> <a href=view_user.asp?mode=ret&id=<%=rs("id") %>>Ret</a><br></font></p></td> <td width="205" height="13"><font color="#FFFFFF"><i>Navn:</i> <%=rs("username")%></font></td> <td width="157" height="13"><font color="#FFFFFF"><i>Køn:</i> <%=rs("sex")%></font></td> <td width="290" height="13" colspan="2"><font color="#FFFFFF"><i>E-mail:</i> <%=rs("email")%></font></td> </tr> <tr> <td width="205" height="22"><font color="#FFFFFF"><i>Adresse:</i> <%=rs("adress")%></font></td> <td width="157" height="22"><font color="#FFFFFF"><i>By:</i> <%=rs("post")%> <%=rs("by")%></font></td> <td width="130" height="22"><font color="#FFFFFF"><i>Mobil:</i> <%=rs("mobiltelefon")%></font></td> <td width="154" height="22"><font color="#FFFFFF"><i>Password:</i> <%=rs("password")%><font></td> </tr> </table> <p> </p> <% rs.MoveNext Loop Else Response.Write "<B>Listen er tom!</B><br><br>" End If myConn.Close Set myConn = Nothing Set rs = Nothing %> </font> </body> <% case "ret" %> <% strSQL = "SELECT * from tblUsers where (Id = " & Request("id") & ")" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../database/users.mdb") & ";DriverId=25;FIL=MS Access" Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open strDSN Set rs = myConn.Execute(strSQL) If Not (rs.BOF Or rs.EOF) Then %> <form method="post" action="gem.asp"> <input type="hidden" name="id" value="<%=Request("id")%>"> <body bgcolor="#000000" link="#FF0000" vlink="#FF0000" alink="#FF0000" text="#FFFFFF"> <img border="0" src="logo.gif"> <p> <table border="1" width="50%" cellpadding="0" cellspacing="0"> <tr> <td width="50%">Navn :</td> <td width="50%"><input type="text" name="navn" size="20" value="<%=rs("username")%>"></td> </tr> <tr> <td width="50%">Køn :</td> <td width="50%"><input type="text" name="sex" size="20" value="<%=rs("sex")%>"></td> </tr> <tr> <td width="50%">E-Mail :</td> <td width="50%"><input type="text" name="email" size="20" value="<%=rs("email")%>"></td> </tr> <tr> <td width="50%">Adresse:</td> <td width="50%"><input type="text" name="adresse" size="20" value="<%=rs("adress")%>"></td> </tr> <tr> <td width="50%">By:</td> <td width="50%"><input type="text" name="by" size="20" value="<%=rs("by")%>"></td> </tr> <tr> <td width="50%">Post:</td> <td width="50%"><input type="text" name="post" size="20" value="<%=rs("post")%>"></td> </tr> <tr> <td width="50%">Mobil:</td> <td width="50%"><input type="text" name="mobil" size="20" value="<%=rs("mobiltelefon")%>"></td> </tr> <tr> <td width="50%">Password:</td> <td width="50%"><input type="text" name="password" size="20" value="<%=rs("password")%>"></td> </tr> <tr> <td width="50%">Aktiv ?</td> <td width="50%"><input type="text" name="aktiv" value="<%= rs("aktiv")%>"></td> </tr> <tr> <td width="50%"><input type="submit" value="Gem" name="ret"></td> </tr></table> </form> </body> <% end if %> <% end select %>
08. juni 2000 - 19:53
#18
Hvor på serveren ligger databasen i forhold til dir root dir (der hvor ^^^ denne fil ligger) ???
08. juni 2000 - 19:59
#20
<%@ Language=VBScript %> <% Response.Buffer = true %> <% select case Request.QueryString("mode") %> <% DBPath = Server.MapPath("database\users.mdb") case "del" Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "Delete * FROM tblUsers WHERE (id = " & Request.QueryString("u") & ")" rs.Open strSQL, myConn, 1, 3 Response.Redirect "view_user.asp" %> <% case "" %> <head> <title>Brugere</title> </head> <BODY bgcolor="#000000" link="#FF0000" vlink="#FF0000" alink="#FF0000"> <img border="0" src="logo.gif"> <p> <font color="#FFFFFF"><% strSQL = "SELECT * from tblUsers" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open strDSN Set rs = myConn.Execute(strSQL) If Not (rs.BOF Or rs.EOF) Then Do While Not rs.EOF %></p> <table border="1" width="760" height="47"> <tr> <td width="80" height="47" rowspan="2"> <p><font color="#FFFFFF"><a href=view_user.asp?mode=del&u=<%=rs("id")%>>slet nr. <%=rs("id")%></a><br> <a href=view_user.asp?mode=ret&id=<%=rs("id") %>>Ret</a><br></font></p></td> <td width="205" height="13"><font color="#FFFFFF"><i>Navn:</i> <%=rs("username")%></font></td> <td width="157" height="13"><font color="#FFFFFF"><i>Køn:</i> <%=rs("sex")%></font></td> <td width="290" height="13" colspan="2"><font color="#FFFFFF"><i>E-mail:</i> <%=rs("email")%></font></td> </tr> <tr> <td width="205" height="22"><font color="#FFFFFF"><i>Adresse:</i> <%=rs("adress")%></font></td> <td width="157" height="22"><font color="#FFFFFF"><i>By:</i> <%=rs("post")%> <%=rs("by")%></font></td> <td width="130" height="22"><font color="#FFFFFF"><i>Mobil:</i> <%=rs("mobiltelefon")%></font></td> <td width="154" height="22"><font color="#FFFFFF"><i>Password:</i> <%=rs("password")%><font></td> </tr> </table> <p> </p> <% rs.MoveNext Loop Else Response.Write "<B>Listen er tom!</B><br><br>" End If myConn.Close Set myConn = Nothing Set rs = Nothing %> </font> </body> <% case "ret" %> <% strSQL = "SELECT * from tblUsers where (Id = " & Request("id") & ")" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open strDSN Set rs = myConn.Execute(strSQL) If Not (rs.BOF Or rs.EOF) Then %> <form method="post" action="gem.asp"> <input type="hidden" name="id" value="<%=Request("id")%>"> <body bgcolor="#000000" link="#FF0000" vlink="#FF0000" alink="#FF0000" text="#FFFFFF"> <img border="0" src="logo.gif"> <p> <table border="1" width="50%" cellpadding="0" cellspacing="0"> <tr> <td width="50%">Navn :</td> <td width="50%"><input type="text" name="navn" size="20" value="<%=rs("username")%>"></td> </tr> <tr> <td width="50%">Køn :</td> <td width="50%"><input type="text" name="sex" size="20" value="<%=rs("sex")%>"></td> </tr> <tr> <td width="50%">E-Mail :</td> <td width="50%"><input type="text" name="email" size="20" value="<%=rs("email")%>"></td> </tr> <tr> <td width="50%">Adresse:</td> <td width="50%"><input type="text" name="adresse" size="20" value="<%=rs("adress")%>"></td> </tr> <tr> <td width="50%">By:</td> <td width="50%"><input type="text" name="by" size="20" value="<%=rs("by")%>"></td> </tr> <tr> <td width="50%">Post:</td> <td width="50%"><input type="text" name="post" size="20" value="<%=rs("post")%>"></td> </tr> <tr> <td width="50%">Mobil:</td> <td width="50%"><input type="text" name="mobil" size="20" value="<%=rs("mobiltelefon")%>"></td> </tr> <tr> <td width="50%">Password:</td> <td width="50%"><input type="text" name="password" size="20" value="<%=rs("password")%>"></td> </tr> <tr> <td width="50%">Aktiv ?</td> <td width="50%"><input type="text" name="aktiv" value="<%= rs("aktiv")%>"></td> </tr> <tr> <td width="50%"><input type="submit" value="Gem" name="ret"></td> </tr></table> </form> </body> <% end if %> <% end select %> OG DEN VIRKER :)))
Slettet bruger
08. juni 2000 - 20:05
#21
Damm stadig fejl Microsoft VBScript compilation error '800a03ea' Syntax error /kartotek/view_user.asp, line 8 case "del" ^
08. juni 2000 - 20:07
#22
Ja, det kan jeg se på siden, men det har ikke noget at gøre med databasen :)
Slettet bruger
08. juni 2000 - 20:09
#23
der var jo ingen fejl før hvor den lå under
www.ssu.dk/ grunden til det hele var at den skulle ligge
www.ssu.dk/kartotek
08. juni 2000 - 20:10
#24
<%@ Language=VBScript %> <% Response.Buffer = true strQuery = Request.QueryString("mode") Select case strQuery DBPath = Server.MapPath("database\users.mdb") case "del" Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "Delete * FROM tblUsers WHERE (id = " & Request.QueryString("u") & ")" rs.Open strSQL, myConn, 1, 3 Response.Redirect "view_user.asp" case "" %> <head> <title>Brugere</title> </head> <BODY bgcolor="#000000" link="#FF0000" vlink="#FF0000" alink="#FF0000"> <img border="0" src="logo.gif"> <p> <font color="#FFFFFF"><% strSQL = "SELECT * from tblUsers" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open strDSN Set rs = myConn.Execute(strSQL) If Not (rs.BOF Or rs.EOF) Then Do While Not rs.EOF %></p> <table border="1" width="760" height="47"> <tr> <td width="80" height="47" rowspan="2"> <p><font color="#FFFFFF"><a href=view_user.asp?mode=del&u=<%=rs("id")%>>slet nr. <%=rs("id")%></a><br> <a href=view_user.asp?mode=ret&id=<%=rs("id") %>>Ret</a><br></font></p></td> <td width="205" height="13"><font color="#FFFFFF"><i>Navn:</i> <%=rs("username")%></font></td> <td width="157" height="13"><font color="#FFFFFF"><i>Køn:</i> <%=rs("sex")%></font></td> <td width="290" height="13" colspan="2"><font color="#FFFFFF"><i>E-mail:</i> <%=rs("email")%></font></td> </tr> <tr> <td width="205" height="22"><font color="#FFFFFF"><i>Adresse:</i> <%=rs("adress")%></font></td> <td width="157" height="22"><font color="#FFFFFF"><i>By:</i> <%=rs("post")%> <%=rs("by")%></font></td> <td width="130" height="22"><font color="#FFFFFF"><i>Mobil:</i> <%=rs("mobiltelefon")%></font></td> <td width="154" height="22"><font color="#FFFFFF"><i>Password:</i> <%=rs("password")%><font></td> </tr> </table> <p> </p> <% rs.MoveNext Loop Else Response.Write "<B>Listen er tom!</B><br><br>" End If myConn.Close Set myConn = Nothing Set rs = Nothing %> </font> </body> <% case "ret" %> <% strSQL = "SELECT * from tblUsers where (Id = " & Request("id") & ")" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open strDSN Set rs = myConn.Execute(strSQL) If Not (rs.BOF Or rs.EOF) Then %> <form method="post" action="gem.asp"> <input type="hidden" name="id" value="<%=Request("id")%>"> <body bgcolor="#000000" link="#FF0000" vlink="#FF0000" alink="#FF0000" text="#FFFFFF"> <img border="0" src="logo.gif"> <p> <table border="1" width="50%" cellpadding="0" cellspacing="0"> <tr> <td width="50%">Navn :</td> <td width="50%"><input type="text" name="navn" size="20" value="<%=rs("username")%>"></td> </tr> <tr> <td width="50%">Køn :</td> <td width="50%"><input type="text" name="sex" size="20" value="<%=rs("sex")%>"></td> </tr> <tr> <td width="50%">E-Mail :</td> <td width="50%"><input type="text" name="email" size="20" value="<%=rs("email")%>"></td> </tr> <tr> <td width="50%">Adresse:</td> <td width="50%"><input type="text" name="adresse" size="20" value="<%=rs("adress")%>"></td> </tr> <tr> <td width="50%">By:</td> <td width="50%"><input type="text" name="by" size="20" value="<%=rs("by")%>"></td> </tr> <tr> <td width="50%">Post:</td> <td width="50%"><input type="text" name="post" size="20" value="<%=rs("post")%>"></td> </tr> <tr> <td width="50%">Mobil:</td> <td width="50%"><input type="text" name="mobil" size="20" value="<%=rs("mobiltelefon")%>"></td> </tr> <tr> <td width="50%">Password:</td> <td width="50%"><input type="text" name="password" size="20" value="<%=rs("password")%>"></td> </tr> <tr> <td width="50%">Aktiv ?</td> <td width="50%"><input type="text" name="aktiv" value="<%= rs("aktiv")%>"></td> </tr> <tr> <td width="50%"><input type="submit" value="Gem" name="ret"></td> </tr></table> </form> </body> <% end if %> <% end select %> Men her skulle case gerne virke ... nøj med ekstra point :)))
Slettet bruger
08. juni 2000 - 20:14
#26
Microsoft VBScript compilation error '800a03ea'
Syntax error
/kartotek/view_user.asp, line 7
case "del"
^
stadig fejl
kik selv
http://www.ssu.dk/kartotek/view_user.asp
08. juni 2000 - 20:18
#27
Så gør sådan her :) <%@ Language=VBScript %> <% Response.Buffer = true MODE = Request.QueryString("mode") DBPath = Server.MapPath("database\users.mdb") If MODE = "del" Then Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "Delete * FROM tblUsers WHERE (id = " & Request.QueryString("u") & ")" rs.Open strSQL, myConn, 1, 3 Response.Redirect "view_user.asp" End If If MODE = "" Then %> <head> <title>Brugere</title> </head> <BODY bgcolor="#000000" link="#FF0000" vlink="#FF0000" alink="#FF0000"> <img border="0" src="logo.gif"> <p> <font color="#FFFFFF"><% strSQL = "SELECT * from tblUsers" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open strDSN Set rs = myConn.Execute(strSQL) If Not (rs.BOF Or rs.EOF) Then Do While Not rs.EOF %></p> <table border="1" width="760" height="47"> <tr> <td width="80" height="47" rowspan="2"> <p><font color="#FFFFFF"><a href=view_user.asp?mode=del&u=<%=rs("id")%>>slet nr. <%=rs("id")%></a><br> <a href=view_user.asp?mode=ret&id=<%=rs("id") %>>Ret</a><br></font></p></td> <td width="205" height="13"><font color="#FFFFFF"><i>Navn:</i> <%=rs("username")%></font></td> <td width="157" height="13"><font color="#FFFFFF"><i>Køn:</i> <%=rs("sex")%></font></td> <td width="290" height="13" colspan="2"><font color="#FFFFFF"><i>E-mail:</i> <%=rs("email")%></font></td> </tr> <tr> <td width="205" height="22"><font color="#FFFFFF"><i>Adresse:</i> <%=rs("adress")%></font></td> <td width="157" height="22"><font color="#FFFFFF"><i>By:</i> <%=rs("post")%> <%=rs("by")%></font></td> <td width="130" height="22"><font color="#FFFFFF"><i>Mobil:</i> <%=rs("mobiltelefon")%></font></td> <td width="154" height="22"><font color="#FFFFFF"><i>Password:</i> <%=rs("password")%><font></td> </tr> </table> <p> </p> <% rs.MoveNext Loop Else Response.Write "<B>Listen er tom!</B><br><br>" End If myConn.Close Set myConn = Nothing Set rs = Nothing %> </font> </body> End If If Mode = "ret" Then <% strSQL = "SELECT * from tblUsers where (Id = " & Request("id") & ")" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open strDSN Set rs = myConn.Execute(strSQL) If Not (rs.BOF Or rs.EOF) Then %> <form method="post" action="gem.asp"> <input type="hidden" name="id" value="<%=Request("id")%>"> <body bgcolor="#000000" link="#FF0000" vlink="#FF0000" alink="#FF0000" text="#FFFFFF"> <img border="0" src="logo.gif"> <p> <table border="1" width="50%" cellpadding="0" cellspacing="0"> <tr> <td width="50%">Navn :</td> <td width="50%"><input type="text" name="navn" size="20" value="<%=rs("username")%>"></td> </tr> <tr> <td width="50%">Køn :</td> <td width="50%"><input type="text" name="sex" size="20" value="<%=rs("sex")%>"></td> </tr> <tr> <td width="50%">E-Mail :</td> <td width="50%"><input type="text" name="email" size="20" value="<%=rs("email")%>"></td> </tr> <tr> <td width="50%">Adresse:</td> <td width="50%"><input type="text" name="adresse" size="20" value="<%=rs("adress")%>"></td> </tr> <tr> <td width="50%">By:</td> <td width="50%"><input type="text" name="by" size="20" value="<%=rs("by")%>"></td> </tr> <tr> <td width="50%">Post:</td> <td width="50%"><input type="text" name="post" size="20" value="<%=rs("post")%>"></td> </tr> <tr> <td width="50%">Mobil:</td> <td width="50%"><input type="text" name="mobil" size="20" value="<%=rs("mobiltelefon")%>"></td> </tr> <tr> <td width="50%">Password:</td> <td width="50%"><input type="text" name="password" size="20" value="<%=rs("password")%>"></td> </tr> <tr> <td width="50%">Aktiv ?</td> <td width="50%"><input type="text" name="aktiv" value="<%= rs("aktiv")%>"></td> </tr> <tr> <td width="50%"><input type="submit" value="Gem" name="ret"></td> </tr></table> </form> </body> <% end if End If %>
Slettet bruger
08. juni 2000 - 20:21
#28
08. juni 2000 - 20:23
#29
Kør denne her i det dir! og fortæl mig, hvad den skriver! <% Response.Write Server.MapPath("database\users.mdb") %>
Slettet bruger
08. juni 2000 - 20:26
#30
D:\web\110cri01\ssu.dk\kartotek\database\users.mdb
08. juni 2000 - 20:28
#31
Ja!!!! Og du siger, at du har et dir, der hedder ssu.dk\kartotek\database\ hvor databasen ligger inde under ... passer ikke ...
08. juni 2000 - 20:30
#32
http://www.ssu.dk/kartotek/database/users.mdb Hvis du trykker på ovenstående link, så skulle man kunne download databasen, hvis den ligger, hvor du siger den skal ... men det kan man ikke (lige nu, i hvert fald)
08. juni 2000 - 20:32
#33
Men det jeg kan se er, at den ligger i SELVE diret kartotek - det vil sige, at du skal ændre følgende DBPath = Server.MapPath("users.mdb") Så virker det .. (Det er jo ikke nemt med de forkerte oplysninger!!) :)))))))
Slettet bruger
08. juni 2000 - 20:33
#34
nej den ligger ik der !!! alså www roden D:\web\110cri01\ssu.dk her ligger databasen D:\web\110cri01\database\users.mdb Det det eneste sted på serveren jeg må execute asp filer
08. juni 2000 - 20:36
#35
FOR HEL*!!*!*!*!
Prøv dog at se her!!!!!!!!
http://www.ssu.dk/kartotek/users.mdb TRYKKER DU DER, SÅ HENTER DU DATABASEN --- men, nåå nej -- det kan man ikke, for den ligger der ikke ... jo den gør ... hvis du ændre, som jeg har sagt, så virker det ...
det er også lige meget, hvor databasen ligger henne, bare asp scriptsne ligger, hvor du kan eksekvere dem :)
Slettet bruger
08. juni 2000 - 20:43
#36
Ok jeg har åbenbart ikke forklaret mig ordenligt !! Jeg kan kun få den til at fungere hvis jeg ligger min access database ude i www roden !! Viborgnet accepetere ikke at man ligger dem andre steder når der skal skrives i dem ?? Alså jeg har ikke skriveretighed andre steder end D:\web\110cri01\database\users.mdb ------- Den er her virker !!!! ----- <% Dim stMode stMode = request("mode") Dim DirPath, MDBPath, DBPath, connect DirPath = Request.serverVariables("APPL_PHYSICAL_PATH") 'finder wwwroot MDBPath = "../database/users.mdb" 'angiver DB'ens path i forhold til wwwroot DBPath = Dirpath & MDBPath Set Connect = server.createobject("ADODB.connection") Connect.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DBPath %> Pejer jo der hen !!!!!!!
08. juni 2000 - 20:43
#37
Eller du kan oprette er dir, der hedder database og ligge users.mdb ind der - så slipper du for at rette i asp filen
08. juni 2000 - 20:45
#38
Så ændre det til dette her! DBPath = Server.MapPath("..\database\users.mdb") ELLER skriv DBPath = "D:\web\110cri01\database\users.mdb"
Slettet bruger
08. juni 2000 - 20:47
#39
hmmmm kikker lige på det
08. juni 2000 - 20:49
#40
og kopier lige logo.gif fra ssu.dk til ssu.dk/kartotek
08. juni 2000 - 20:54
#41
Bliver det til noget ?! :)
Slettet bruger
08. juni 2000 - 21:29
#42
her svaret der viker ------------------- <%@ Language=VBScript %> <% Response.Buffer = true %> <% select case Request.QueryString("mode") %> <% case "del" DirPath = Request.serverVariables("APPL_PHYSICAL_PATH") MDBPath = "../database/users.mdb" DBPath = Dirpath & MDBPath Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "Delete * FROM tblUsers WHERE (id = " & Request.QueryString("u") & ")" rs.Open strSQL, myConn, 1, 3 Response.Redirect "view_user.asp" %> <% case "" %> <head> <title>Brugere</title> </head> <BODY bgcolor="#000000" link="#FF0000" vlink="#FF0000" alink="#FF0000"> <img border="0" src="logo.gif"> <p> <font color="#FFFFFF"><% DirPath = Request.serverVariables("APPL_PHYSICAL_PATH") MDBPath = "../database/users.mdb" DBPath = Dirpath & MDBPath strSQL = "SELECT * from tblUsers" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open strDSN Set rs = myConn.Execute(strSQL) If Not (rs.BOF Or rs.EOF) Then Do While Not rs.EOF %></p> <table border="1" width="760" height="47"> <tr> <td width="80" height="47" rowspan="2"><font color="#FFFFFF">Nr. <%=rs("id")%><p><a href=view_user.asp?mode=del&u=<%=rs("id")%>>Slet </a><a href=view_user.asp?mode=ret&id=<%=rs("id") %>>Ret</a><br></font></p></td> <td width="205" height="13"><font color="#FFFFFF"><i>Navn:</i> <%=rs("username")%></font></td> <td width="157" height="13"><font color="#FFFFFF"><i>Køn:</i> <%=rs("sex")%></font></td> <td width="290" height="13" colspan="2"><font color="#FFFFFF"><i>E-mail:</i> <%=rs("email")%></font></td> </tr> <tr> <td width="205" height="22"><font color="#FFFFFF"><i>Adresse:</i> <%=rs("adress")%></font></td> <td width="157" height="22"><font color="#FFFFFF"><i>By:</i> <%=rs("post")%> <%=rs("by")%></font></td> <td width="130" height="22"><font color="#FFFFFF"><i>Mobil:</i> <%=rs("mobiltelefon")%></font></td> <td width="154" height="22"><font color="#FFFFFF"><i>Password:</i> <%=rs("password")%><font></td> </tr> </table> <p> </p> <% rs.MoveNext Loop Else Response.Write "<B>Listen er tom!</B><br><br>" End If myConn.Close Set myConn = Nothing Set rs = Nothing %> </font> </body> <% case "ret" %> <% DirPath = Request.serverVariables("APPL_PHYSICAL_PATH") MDBPath = "../database/users.mdb" DBPath = Dirpath & MDBPath strSQL = "SELECT * from tblUsers where (Id = " & Request("id") & ")" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath & ";DriverId=25;FIL=MS Access" Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open strDSN Set rs = myConn.Execute(strSQL) If Not (rs.BOF Or rs.EOF) Then %> <form method="post" action="gem.asp"> <input type="hidden" name="id" value="<%=Request("id")%>"> <body bgcolor="#000000" link="#FF0000" vlink="#FF0000" alink="#FF0000" text="#FFFFFF"> <img border="0" src="logo.gif"> <p> <table border="1" width="50%" cellpadding="0" cellspacing="0"> <tr> <td width="50%">Navn :</td> <td width="50%"><input type="text" name="navn" size="20" value="<%=rs("username")%>"></td> </tr> <tr> <td width="50%">Køn :</td> <td width="50%"><input type="text" name="sex" size="20" value="<%=rs("sex")%>"></td> </tr> <tr> <td width="50%">E-Mail :</td> <td width="50%"><input type="text" name="email" size="20" value="<%=rs("email")%>"></td> </tr> <tr> <td width="50%">Adresse:</td> <td width="50%"><input type="text" name="adresse" size="20" value="<%=rs("adress")%>"></td> </tr> <tr> <td width="50%">By:</td> <td width="50%"><input type="text" name="by" size="20" value="<%=rs("by")%>"></td> </tr> <tr> <td width="50%">Post:</td> <td width="50%"><input type="text" name="post" size="20" value="<%=rs("post")%>"></td> </tr> <tr> <td width="50%">Mobil:</td> <td width="50%"><input type="text" name="mobil" size="20" value="<%=rs("mobiltelefon")%>"></td> </tr> <tr> <td width="50%">Password:</td> <td width="50%"><input type="text" name="password" size="20" value="<%=rs("password")%>"></td> </tr> <tr> <td width="50%">Aktiv ?</td> <td width="50%"><input type="text" name="aktiv" value="<%= rs("aktiv")%>"></td> </tr> <tr> <td width="50%"><input type="submit" value="Gem" name="ret"></td> </tr></table> </form> </body> <% end if %> <% end select %>
Kurser inden for grundlæggende programmering