How can I validate that data entered is numeric and ignore if field is blank?

Ok, so if the student enters something in this field I want to save that info. If the field is blank then ignore it.

The code above give me the following problem. If it's left blank then it does the SET ERROR request.

So, at the moment users would have to at least enter "0" in order to save.

Also, I know ICQ is ancient... What can I say? I don't design the thing, I just code it ^_^

re: How can I validate that data entered is numeric and ignore if field is blank?

The problem with your code is that you're checking the data is not empty, is numeric and is a valid integer, then you have a cfelse which means if the field is not any of those things, give an error message.

What you should do is just make a check for the field being blank separately. If non-blank, then make a check for numeric validation. If that fails, then set an error.

That would be something like:

re: How can I validate that data entered is numeric and ignore if field is blank?

That's it! Thanks! ^_^

re: How can I validate that data entered is numeric and ignore if field is blank?

No problem. You're welcome.

re: How can I validate that data entered is numeric and ignore if field is blank?

anothers issue, I am working from a code I didn't create but now have to modify; The end result of my problem is to make sure that only three numbers are entered for area code, three for phone prefix and four numbers in the last field.

Having hard time, never used CF before and need syntax to validate three fields (form.phone, form.phone2, form.phone.3) to be numeric and contain the correct number of numbers.

A bounus would be to know whow to get the errors to display in a pop up; like I said this is someones code before I was hired and I only new basic HTML until this job; but when it validates and there is an error the error message is in the address bar???

Thank you,

CF

re: How can I validate that data entered is numeric and ignore if field is blank?

Use the len() function to check for maximum length (just requires a slight modification):
To check if it's numeric, use the IsNumeric() function.

re: How can I validate that data entered is numeric and ignore if field is blank?

Sorry, my screen name says it all, OK, I see and understand "not equal to greater than 3" and IsNumeric is easy to read;

What I want to make sure is that the length is 3 and is numeric else error;

I forced the form to only allow three chars so a user can not add more, but do not want them to add none, less than 3 or alpha.

What would that code look like?

re: How can I validate that data entered is numeric and ignore if field is blank?

Similar:

re: How can I validate that data entered is numeric and ignore if field is blank?

<cfif Len(Trim(form.phone)) NEQ 3 or not IsNumeric(Trim(form.phone))>
<cfset errorMsg = errorMsg & '- Please enter 3 digit area code<br/>'>
</cfif>

on the 2nd part "or not" IsNumeric(Trim(form.phone))> would IsNumeric(form.phone)> work, do I need the "trim?"

I posted another reply you are looking at with this, would the cfoutput replace the cfset for the error here?

re: How can I validate that data entered is numeric and ignore if field is blank?

Yes, you need the trim, otherwise if there's a space, it will not be counted as numeric when it could easily be ignored.
No, not here. It would be at the end when all the error messages have been acummulated.