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 |
|
pwcphoto
Yak Posting Veteran
69 Posts |
 Posted - 2005-04-18 : 04:01:05
|
| I have a stored procedure that requests rows from a table. If I enter in a number that is greater then the number of rows is there a way to trap that? Is there an error response that I can pick up in the returned recordset that I can use to execute my error response and handle it so the user does not see the vbscript runtime error?Thanks,Phil-----------------------I used to be a rocket scientist. Now I'm just a space cadet... |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-18 : 04:07:45
|
| hmm..in your sp, you can check for @@rowcount when you do the select and compare that to the parameter representing number of rows?--------------------keeping it simple... |
 |
|
|
|
|
|
How to detect request overrun