28,408
社区成员
发帖
与我相关
我的任务
分享如何检测与处理执行SQL语句后的错误
如果执行一个插入语句,而关键字与已经存在的记录冲突,或删除记录,却因有外键约束关系,不能删除,这时浏览器中显示错误信息,但我希望可以定制这个信息,就是说需要获取错误值,不知道怎么做?
...全文
请发表友善的回复…
发表回复
efis 2002-07-23
- 打赏
- 举报
我用的是UltraDEV 40,它的代码如下:没有建立connection对象
set MM_rsUser = Server.CreateObject(MM_flag)
MM_rsUser.ActiveConnection = MM_proman_STRING
MM_rsUser.Source = "SELECT strUserName, strPassword"
If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
MM_rsUser.Source = MM_rsUser.Source & " FROM tbluser WHERE strUserName='" & MM_valUsername &"' AND strPassword='" & CStr(Request.Form("password")) & "'"
MM_rsUser.CursorType = 0
MM_rsUser.CursorLocation = 2
MM_rsUser.LockType = 3
MM_rsUser.Open
set MM_rsUser = Server.CreateObject(MM_flag)
MM_rsUser.ActiveConnection = MM_proman_STRING
MM_rsUser.Source = "SELECT strUserName, strPassword"
If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
MM_rsUser.Source = MM_rsUser.Source & " FROM tbluser WHERE strUserName='" & MM_valUsername &"' AND strPassword='" & CStr(Request.Form("password")) & "'"
MM_rsUser.CursorType = 0
MM_rsUser.CursorLocation = 2
MM_rsUser.LockType = 3
MM_rsUser.Open
swingcoder 2002-07-22
- 打赏
- 举报
error.desc
gshope 2002-07-22
- 打赏
- 举报
set myerror=conn.errors
...
...
gshope 2002-07-22
- 打赏
- 举报
set myerror=conn.errors
...
...
