Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Validation Toolkit › Validation Number - with Comma Separators

Validation Number - with Comma Separators

Thread began 8/20/2009 11:00 am by karen.marley367377 | Last modified 8/21/2009 10:46 am by karen.marley367377 | 2332 views | 1 replies

8/21/2009 10:46 amEric Mittman

The reason you are getting the numbers inserted without the comma is because you have specified that the column type is numeric.

If you store the comma in with the number you will need to have the column set as a varchar type.

In the database all of these values should be purely numeric, this means you will not be able to store the comma in the number. It is best to have the numbers unformatted in the db, then just format the numbers server side when you want to display them.

Doing a little looking on the web I found this link that has a formatting function, the Standard format looks like the one you are going for.

format_asp.asp

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.