Exception occurred
Hvad fan.... betyder:error ''80020009''
Exception occurred.
/TeamDK/teamshared/information_update.asp, line 48
Min linie 48 ser såfdan ud:
if not RS1("mem_name")="" then
Hele siden:
<!-- #INCLUDE file="include1.asp" -->
<%@ LANGUAGE="VBSCRIPT" %>
<%
Not_There = "No"
ierror = 0
pword_Error = 0
imname = Request.Form("mem_name")
ifname = Request.Form("first_n")
isname = Request.Form("s_name")
itel = Request.Form("tele")
idir = Request.Form("dir")
ibus = Request.Form("bus")
idep = Request.Form("dep")
iloc = Request.Form("loc")
iredirect = Request.Form("Redirect")
ipword = Request.Form("pword")
ipword1 = Request.Form("pword1")
Success = "Yes"
if imname = "" then ierror = 1
if ifname = "" then ierror = 1
if isname = "" then ierror = 1
if itel = "" then ierror = 1
if idir = "" then ierror = 1
if ibus = "" then ierror = 1
if idep = "" then ierror = 1
if iloc = "" then ierror = 1
if iredirect = "" then ierror = 1
if imname = "" then ierror = 1
if ipword ="" then
pword_error = 1
ierror = 1
End If
if ipword <> ipword1 then
pword_error = 2
ierror = 1
End If
%>
<%
set conn1= Server.CreateObject("ADODB.Connection")
Conn1.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("data/message.mdb") & ";DriverId=25;FIL=MS Access;MaxBufferSize=512;PageTimeout=5"
fp_sqry1 = "Select * from user where mem_name = ''" & imname & "''"
set RS1=conn1.Execute (fp_sqry1)
if not RS1("mem_name")="" then
ierror=2
RS1.close
Set RS1 = nothing
end if
%>
<% if ierror= 1 then %>
Fejl i data
<% end if %>
<% if ierror= 2 then %>
Medlem eksisterer
<% end if %>
<% if pword_error = 2 then %>
Fejl i password
<% end if %>
<% if ierror= 0 then
set my_conn= Server.CreateObject("ADODB.Connection")
my_Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("data/message.mdb") & ";DriverId=25;FIL=MS Access;MaxBufferSize=512;PageTimeout=5"
fp_sQry2 = "Update user SET mem_name=''" & imname & "'', redirect=''" & iredirect & "'', Mem_password=''" & ipword & "'',f_name=''" & ifname & "'', s_name=''" & isname & "'',ext=''"& itel & "'',direct=''" & idir & "'',bus_name=''" & ibus & "'',location=''" & iloc & "'', dept=''" & idep & "'' WHERE mem_name = ''" & session("uname") & "''"
set RS=my_conn.Execute (fp_sqry2)
%>
<%= RS1("mem_name") %>
Du får adgang ved at taste dit brugernavn og password i nedenstående
felt
<form method="POST" action="../log/login.asp">
Brugernavn<br>
<input type="text" name="login" size="20">
<br>
Password<br>
<input type="password" name="password" size="20">
<br>
<br>
<input type="submit" value="OK !" name="B1">
<input type="reset" value="Slet" name="B2">
</form>
<% end if %>
<%
set ierror=nothing
%>
</BODY>
</HTML>
