Ich erhalte folgender Fehlermeldung wenn ich versuche einen Eintrag zu
�berabreiten (updaten).
Database Errors Occured
Error #-2147217908
Error desc. -> F�r das Befehlsobjekt wurde kein Befehlstext festgelegt.
Hier der Quellcode:
<%
on error resume next
Nickname=request.form("Nickname")
email=request.form("email")
url=request.form("url")
Datum=request.form("Datum")
Text=request.form("Text")
ID=Request.QueryString("ID")
Set Conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN=DM90_aspfreak"
strSQL = "UPDATE gaestebuch"
strSQL = strSQL & "', Nickname='" & Nickname
strSQL = strSQL & "', Email='" & Email
strSQL = strSQL & "', url='" & url
strSQL = strSQL & "', Datum='" & Datum
strSQL = strSQL & "', Text='" & Text
strSQL = strSQL & "', ID='" & ID
Set RS = Conn.Execute(SQLStmt)
If err.number>0 then
response.write "VBScript Errors Occured:" & "<P>"
response.write "Error Number=" & err.number & "<P>"
response.write "Error Descr.=" & err.description & "<P>"
response.write "Help Context=" & err.helpcontext & "<P>"
response.write "Help Path=" & err.helppath & "<P>"
response.write "Native Error=" & err.nativeerror & "<P>"
response.write "Source=" & err.source & "<P>"
response.write "SQLState=" & err.sqlstate & "<P>"
end if
IF conn.errors.count> 0 then
response.write "Database Errors Occured" & "<P>"
response.write SQLstmt & "<P>"
for counter= 0 to conn.errors.count
response.write "Error #" & conn.errors(counter).number & "<P>"
response.write "Error desc. -> " & conn.errors(counter).description &
"<P>"
next
else
response.write "<B>Everything Went Fine. Record is updated now!</b>"
response.write "<br>" & SQLstmt
end if
rs.close
set rs=nothing
Conn.Close
set conn=nothing
%>
F�r jeden Tip Danke ich !!!
cu Erik Fichtner
| Oft Gefragtes: http://www.aspgerman.com/aspgerman/faq/
| [aspdebeginners] als [email protected] subscribed
| http://www.aspgerman.com/archiv/aspdebeginners/ = Listenarchiv
| Sie knnen sich unter folgender URL an- und abmelden:
| http://www.aspgerman.com/aspgerman/listen/anmelden/aspdebeginners.asp
