Re: Replace: Problems stripping out Comma for a Integer field

How are you passing the Var argument to the FixPos Function? Unless you have
it in quotes FixApos("1,000"), you will get an error.

And why is the function named FixApos? Even if all it did was escape
apostrophes, wouldn't a better name be FixApostrophes, or my favorite -
FixTix?

When I first looked at it, I was wondering what an Apo was.

Bob Lehmann

<jason@xxxxxxxxxxxxxxx> wrote in message
news:udjWeAVtFHA.1168@xxxxxxxxxxxxxxxxxxxxxxx
> Interesting problem: If a user puts a Comma into an integer field I will
get
> a data type error.
>
> I tried Replacing it with a blank space:
>
> FUNCTION FixApos(Var)
> FixApos=Replace(Var, "'", "")
> FixApos=Replace(Var, ",", "")
>
> END FUNCTION
>
> But still pick up the error. Is tis because the Int field sees the empty
> space as a 'character'?
>
> I have no resorted to redirecting user back to form page if there is a
comma
> detected:
>
> FUNCTION FixApos(Var)
> FixApos=Replace(Var, "'", "")
> FixApos=Replace(Var, ",", "")
> If Instr(Var,",") then
>
> response.redirect "FormAdd.asp?Error=Comma"
>
> End If
> ' this replaces a single apostrophe ( ' ) with two single apostrophes (
'').
> Note: two single apostrophes, not one quotation mark
> END FUNCTION
>
>
> Bsides client side validation there surely has to be a better way to strip
> out commas for an integer field on the fly. I also tried replacing with a
> NULL but error said this was inproper use of Replace function.
>
> Could really use some help here.
>
> Thanks
> Jason
>
>


.

Relevant Pages