Form Validation

[Hatch]

Can someone point me in the right direction or (example) for form validation. I have a text box field in a form that connects to an access database. I want to check for numeric numbers only, and also if the record is not found to display a recond not found page instead of
Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
Thanks

[oracleguy]

Run this asp code to check for numaric numbers.


Dim xC, vC, zC
zC=ControlToValidate
vC = "1234567890"

For xC = 1 To Len(zC)
If Instr(vC, Mid(zC, xC, 1)) < 1 Then
'Error!

Exit For
End If
Next

[oracleguy]

Then for the database part:


'Run your query first

If rs.EOF or rs.BOF then Response.Redirect("NotFound.aspx")



Change 'rs' to whatever your recordset control name is.

[Hatch]

PERCECT!!
Thanks :thumbsup:

[Morgoth]

Am I a newbie for asking this?
What are "numaric numbers"?

[oracleguy]

I think he ment numaric characters/integers.

[Morgoth]

Ah...

and that is?

[whammy]

0-9.

Morgoth, please limit your posts in this forum to questions about ASP or attempting to help someone with their ASP problem.

Understood?

[Morgoth]

Ok Whammy, but alot of this is new to me, and i want to suck up all the info I can so my code and applications will be perfect or close to being that way.

[whammy]

Sorry if I was mistaken, it seemed to me you were being a smart aleck. ;)

Anyway, he apparently wanted to limit the entry to digits - FYI here's another neat way to strip everything but numbers from a string using javascript with asp:

<script language="javascript" runat="server">
function ExtractNumbers(MixedString){
if(MixedString){
MixedString = MixedString.replace(/\D/g,'');
return MixedString;
}
}
</script>

You'd call that function just like a VBScript function. So, in addition to the way Oracleguy showed above, you could also see if something extracted from a database was only numeric like:

<%
If myString <> ExtractNumbers(myString) Then
'It's not numeric!
End If
%>