Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-14 : 08:38:29
|
shreekumar writes "i have used a select statement with a where condition in an ASP page. the following errror is raised. The concerned record is not there in the table. for eg: in the students table: a student has an id no: 91A001, but his record does not exist in the student table. at the same time i use a select statement like this: select * from student where studid = '91A001'This statement raises an error of the following type:ADODB.Field error '80020009'. 1) How to handle this error in ASP?2) I am not getting an error number using the 'on error resume next' statement in ASP. How do i handle this.The sample code in my application is as follows: on error resume next sql = "select * from sensory where memno='" & session("editmemno") & "'" if err.number <> 0 then session("insert") = true session("nos") = err.number else session("insert") = false session("nos") = err.number end if set rs = session("cn").Execute(sql)best regards shree" |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
|
|
|
handling error: ADODB.Field error '80020009' 