| no data found / primary key violation exception handling [message #87776] |
Wed, 09 February 2005 21:25  |
Abhishek
Messages: 10
Registered: January 2004
|
Junior Member |
|
|
hi,
i am working on a web site with ASP (VBScript as explicit) as front end and access as the back end. i am facing 2 problems
A> i call a record set by passing on the query 'rs.Open "Select * from CSAT1 where mname='"&mname&"' order by rdate",conn'. this gives me an error if no records are found. how do i handle this exception by passing on a value to a variable which recognises that no records were found?
B> in the same site if i try to enter data and there is a primary key violation it gives me a error. how do i handle this error message?
thanx
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
