SQL Insert using comma as decimal

Write your own insert using DW's command object, not the built-in insert
record behavior. It's shorter and cleaner, and you can do your own
validation and processing before inserting the record.

"oteacher" <webforumsuser@macromedia.com> wrote in message
news:el9g54$d5q$1@forums.macromedia.com...
> Ok, i've imagined that, but how do i raplace a form field server side with
> the
> DW Update behavior?
> I can't alter the fields after they are submitted.
> Maybe a sort of Form Validation Routine?
> I'd like to make this transparent to the final user.
>

Ok, i've imagined that, but how do i raplace a form field server side with the DW Update behavior?
I can't alter the fields after they are submitted.
Maybe a sort of Form Validation Routine?
I'd like to make this transparent to the final user.

"oteacher" <webforumsuser@macromedia.com> wrote in message
news:el7n0e$7an$1@forums.macromedia.com...
> How to insert a number using comma as a decimal separator?

It's not going to work. You'll have to do a find and replace.

myNumber = Replace(Replace(Request.Form("numberField"),".",""),",",".")

The inner replace removes all decimal points (because you indicated that
might be used as a thousands separator), then the outer replace replaces all
commas with decimal points. Using FormatNumber when you write the number to
the screen will format it as you're used to, but the number must be inserted
with a regular decimal point.