Clear screen entries if condition exists ASP/vbscript

[acewilli]

FYI - I've also posted in the ASP forum as I did not know where to post this for sure. Thank you for any help.

Hello,

I need to clear the entries on the screen if a certain condition exists so that it never is updated in the database. Below is my update function and is where I am trying to make this happen. I need to make sure that the user doesn't use more than 10 points or less than 10 points such as a negative number. I need to reset the screen after the Update button is pressed but before anything is actually updated in the database. Any help is greatly appreciated.

If Request.Form("submit") = "Update" Then
 While not rsStatus.eof
   If rsStatus("npoints") > "10" Then
[COLOR=red]'need to clear entries here based on condition above
'and refresh the screen[/color]
   elseif rsStatus("npoints") < "10" Then
[COLOR=red]'need to clear entries here based on condition above     
'and refresh the screen[/color]
   else
   end if
'code continues here

Thank you in advance,

acewilli

 

[acewilli]

CORRECTION:

I need to use from 0 to 10. I can't have anything over 10 or less than 0 which would be a negative number. Thank you for correcting me. I never get answers because I make mistakes when typing my questions. I appreciate the catch. Hope you can help me.

Thanks again,

acewilli